Design of Oracle Database and Its Dynamic Crosstab Based on Data Paradigm
Xinlin Zhang · Computer and Modernization · 2005
The design of Oracle database based on the paradigm of students' mark table was discussed. Under this datasheet, the repeated and unnecessary data were reduced greatly. It is easy to insert, delete and update and maintain the integrity of data. The maintenance of database became more convenient, but the data are not suitable to output directly. The generation of dynamic crosstab was probed into and the concrete codes were given in this paper.