Description: The relationship between the self-built table, write the following procedure: 1. Using PL/SQL stored procedure to delete a record (on the condition as a parameter) 2. With input and output parameters with stored procedure to query the parameters of a given key information about the records 3. 2 with a function for the problem. Trigger and the cursor to define a PLSQL block with an explicit cursor to loop the output of a basic table query information. S flip-flop to generate a basic table, if you delete a record with foreign keys, but also records the corresponding reference table deletion generated the trigger.
To Search:
File list (Check if you may need any files):
oracle实验2ly\OracleFun实验2011-2.doc
.............\plsql_examples_scripts.sql
.............\select.sql
.............\delete.sql
oracle实验2ly
Download