oracle动态sql
来源:互联网 发布:云校大数据技术研究院 编辑:程序博客网 时间:2024/05/17 03:53
CREATE OR REPLACE
PROCEDURE proc_monitor_detail
--查询考试安排详细 examName,BeginTime,addTime,Address,Course_Name
(
v_examID IN NUMBER DEFAULT NULL ,
v_examName OUT VARCHAR2,
v_beginTime OUT VARCHAR2,
v_addTime OUT VARCHAR2,
v_Address OUT VARCHAR2,
v_courseName OUT VARCHAR2,
v_paperTitle OUT VARCHAR2,
v_paperTime OUT CHAR,
v_readTeacherName OUT VARCHAR2
)
AS
v_courseCode CHAR(3);
v_readTeacherID VARCHAR2(50);
v_paperID NUMBER(10,0);
v_table_spec VARCHAR2(500);
v_table_name CHAR(5);
BEGIN
SELECT PaperID ,
ExamArrangement.CourseCode ,
ExamName ,
BeginTime ,
addTime ,
ADDRESS ,
Course_Name ,
UserInfo.Name
INTO v_paperID,
v_courseCode,
v_examName,
v_beginTime,
v_addTime,
v_Address,
v_courseName,
v_readTeacherName
FROM ExamArrangement ,
CourseInfo ,
UserInfo
WHERE ExamID = v_examID
AND ExamArrangement.CourseCode = CourseInfo.Course_Code
AND ExamArrangement.ReadTeacherID = UserInfo.UserID;
v_table_name := 'SJ' || v_courseCode ;
v_table_spec := 'select Time from ' || v_table_name || ' where PaperID='||v_paperID;
--DBMS_OUTPUT.PUT_LINE(v_table_spec);
execute immediate v_table_spec INTO v_paperTime;
v_table_spec := 'select Title from ' || v_table_name || ' where PaperID='||v_paperID;
execute immediate v_table_spec INTO v_paperTitle;
END;
PROCEDURE proc_monitor_detail
--查询考试安排详细 examName,BeginTime,addTime,Address,Course_Name
(
v_examID IN NUMBER DEFAULT NULL ,
v_examName OUT VARCHAR2,
v_beginTime OUT VARCHAR2,
v_addTime OUT VARCHAR2,
v_Address OUT VARCHAR2,
v_courseName OUT VARCHAR2,
v_paperTitle OUT VARCHAR2,
v_paperTime OUT CHAR,
v_readTeacherName OUT VARCHAR2
)
AS
v_courseCode CHAR(3);
v_readTeacherID VARCHAR2(50);
v_paperID NUMBER(10,0);
v_table_spec VARCHAR2(500);
v_table_name CHAR(5);
BEGIN
SELECT PaperID ,
ExamArrangement.CourseCode ,
ExamName ,
BeginTime ,
addTime ,
ADDRESS ,
Course_Name ,
UserInfo.Name
INTO v_paperID,
v_courseCode,
v_examName,
v_beginTime,
v_addTime,
v_Address,
v_courseName,
v_readTeacherName
FROM ExamArrangement ,
CourseInfo ,
UserInfo
WHERE ExamID = v_examID
AND ExamArrangement.CourseCode = CourseInfo.Course_Code
AND ExamArrangement.ReadTeacherID = UserInfo.UserID;
v_table_name := 'SJ' || v_courseCode ;
v_table_spec := 'select Time from ' || v_table_name || ' where PaperID='||v_paperID;
--DBMS_OUTPUT.PUT_LINE(v_table_spec);
execute immediate v_table_spec INTO v_paperTime;
v_table_spec := 'select Title from ' || v_table_name || ' where PaperID='||v_paperID;
execute immediate v_table_spec INTO v_paperTitle;
END;
- oracle笔记动态SQL
- Oracle中的动态sql
- ORACLE动态SQL
- 转:ORACLE 动态SQL
- Oracle 动态SQL
- Oracle动态SQL语句
- oracle 动态sql
- oracle 动态sql
- oracle动态sql
- Oracle的动态SQL
- oracle动态sql
- Oracle中的动态SQL
- Oracle中的动态SQL
- oracle 动态SQL语句
- Oracle动态SQL语句
- Oracle动态SQL
- oracle动态SQL详解
- Oracle动态SQL语法
- 机房收费系统之 退卡流程
- 常见SQL(生成序列号)
- 无法实现的梦想:孤独之旅计划
- 结构体 net_device常用成员分析
- PHP报错Bus error解决方法
- oracle动态sql
- button.setRolloverIcon的使用
- 编写一个程序,实现顺序环形队列的各种基本运算。
- ARM裸机之系统时钟
- JScrollPane的使用
- HDU2824 The Euler function 欧拉函数的应用
- 位运算
- Accelerated C++ exercises 4-0
- Java NIO学习