文件名称:oracle2ly
介绍说明--下载内容均来自于网络,请自行研究使用
在自建的关系表上,编写如下程序:
1.用PL/SQL的存储过程删除某条记录(条件作为参数传入);
2.用带输入输出参数的存储过程查询出参数给定的记录的有关关键信息;
3.用函数作第2题。
触发器及游标
定义一个PLSQL块,用显式游标循环输出一基本表查询信息。
生成一个基本表S触发器,如果删除某带外键的记录时,同时也参照表对应的记录;
删除生成的触发器。
-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.
1.用PL/SQL的存储过程删除某条记录(条件作为参数传入);
2.用带输入输出参数的存储过程查询出参数给定的记录的有关关键信息;
3.用函数作第2题。
触发器及游标
定义一个PLSQL块,用显式游标循环输出一基本表查询信息。
生成一个基本表S触发器,如果删除某带外键的记录时,同时也参照表对应的记录;
删除生成的触发器。
-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.
相关搜索: oracle2ly
(系统自动生成,下载前可以参看下载内容)
下载文件列表
oracle实验2ly\OracleFun实验2011-2.doc
.............\plsql_examples_scripts.sql
.............\select.sql
.............\delete.sql
oracle实验2ly
.............\plsql_examples_scripts.sql
.............\select.sql
.............\delete.sql
oracle实验2ly