Oracle record declaration method

Oracle record declaration method Oracle record Declaration has only three methods: 1. the table-based record type Java code student_record student % rowtype. student is a table. After the student_record is declared, the structure is consistent with that of student. cursor-based record type Java code declare -- cursor students_cursor is select * from student; -- declares the cursor-based record student_record students_couror % rowtype; -- defines the type of the cursor variable type students_cursor is ref cursor return student % rowtype; -- declares the cursor variable student_cur_var student_cursor; -- declares that the cursor variable-based record contains limit % rowtype, oracle allows you to declare a cursor-based variable by adding % rowtype to the display cursor or cursor variable. 3. the custom record type can be type... is record statement to define the record type, and then declare a record. java code declare type student_rt is record (id student. id type, name student. name % type, total number (5, 2); student_record student_rt;