-
编辑 删除
动态表名
declare tablename1 number(3);STRSQL varchar2(30);TABLENAME2 varchar2(20);beginTABLENAME2 := 'dept';STRSQL :='SELECT COUNT(*) FROM '||TABLENAME2;EXECUTE IMMEDIATE STRSQL INTO tablename1;dbms_output.put...
-
编辑 删除
动态表名
declare tablename1 number(3);STRSQL varchar2(30);TABLENAME2 varchar2(20);beginTABLENAME2 := 'dept';STRSQL :='SELECT COUNT(*) FROM '||TABLENAME2;EXECUTE IMMEDIATE STRSQL INTO tablename1;dbms_output.put...
-
编辑 删除
record
Recordsa record is composed of one or more fields. There are three different ways to define a record:1. Table-based recordCREATE TABLE books ( book_id &n...
-
编辑 删除
string
单引号两种转义select 'Aren''t you glad you''re learning PL/SQL?'from dualselect q'!Aren't you glad you're learning PL/SQL?!'from dual--! @ 等select q'!Aren''t you glad you're learning PL/SQL?!'from du...
-
编辑 删除
why use dynamic SQL?
Executing DDL and SCL (Session control language (SCL) statements, such as ALTER SESSION and SET ROLE)Statements in PL/SQL
-
编辑 删除
转义 &
insert into emp(empno, ename) values(999,'begin' || '&' || 'end')
-
编辑 删除
07-14 cursor variable
declare type emp_type is ref cursor return emp%rowtype; cur_emp emp_type; ...
-
编辑 删除
pl/sql 07-13
declarev_date varchar2(18);beginv_date := to_char(sysdate, 'Day, hh24:mi');dbms_output.put_line(v_date );end;
-
编辑 删除
pl/sql功能特性
loginsqlplus scott/tiger@orcl块结构DECLAREBEGIN EXCEPTIONEND; sql*plus 的使用1. / 执行2. edit 打开代码3.show error；4. execute display;...
