oracle 存储过程和函数
一)存储过程
执行存储过程
exec procedure_name;
exec procedure_name(parameter);
call procedure_name();
call procedure_name(parameter);
begin
exec procedure procedure_name;
end;
/
修改存储过程:
or replace参数
删除存储过程
drop procedure procedure_name;
重新编译存储过程:
alter procedure procedure_name compile;
1:创建无参数的存储过程:
eg:
create procedure pro_emp
is
begin
update emp set sal=sal+200;
commit;
end;
/
搜索hiredate日期在1981到1987之间的人员的信息,并判断其sal是否大于4000如果不是那么sal+1000;
create or replace procedure emp_sal_up
is
cursor cur_emp is select * from emp;
v_emp_cur emp%rowtype;
begin
open cur_emp;
loop
fetch cur_emp into v_emp_cur;
exit when cur_emp%notfound;
if v_emp_cur.hiredate>to_date('1981-01-01','yyyy-mm-dd') and v_emp_cur.hiredate<to_date('1987-01-01','yyyy-mm-dd') then
if v_emp_cur.sal>4000 then
null;
else
update emp set sal=sal+1000 where empno=v_emp_cur.empno;
end if;
end if;
end loop;
close cur_emp;
end;
/
create or replace procedure proce_emp_tes1
(v_empn in number)
as
type emp_record is record(
v_empno emp.empno%type,
v_ename emp.ename%type,
v_job emp.job%type,
v_sal emp.sal%type);
emp_re emp_record;
begin
select empno,ename,job,sal into emp_re.v_empno,emp_re.v_ename,emp_re.v_job,emp_re.v_sal
from emp where empno=v_empn;
dbms_output.put_line(emp_re.v_empno||'@@@@'||emp_re.v_ename||'@@@@'||emp_re.v_job||'@@@@'||emp_re.v_sal);
end;
/
create or replace procedure proce_emp_test2
(v_empn in number,v_ena out varchar2,v_sa out number)
as
type emp_record is record(
v_empno emp.empno%type,
v_ename emp.ename%type,
v_job emp.job%type,
v_sal emp.sal%type);
emp_re emp_record;
begin
select empno,ename,job,sal into emp_re.v_empno,emp_re.v_ename,emp_re.v_job,emp_re.v_sal
from emp where empno=v_empn;
v_ena:=emp_re.v_ename;
v_sa:=emp_re.v_sal;
dbms_output.put_line(emp_re.v_empno||'@@@@'||emp_re.v_ename||'@@@@'||emp_re.v_job||'@@@@'||emp_re.v_sal);
end;
/
注意接收参数的值已经要声明如下:
SCOTT@orcl#var name varchar2(20)
SCOTT@orcl#var sal number
SCOTT@orcl#exec proce_emp_test2(7000,:name,:sal);
PL/SQL 过程已成功完成。
SCOTT@orcl#set serveroutput on
SCOTT@orcl#exec proce_emp_test2(7000,:name,:sal);
7000@@@@MILLER@@@@hello@@@@3220
PL/SQL 过程已成功完成。
SCOTT@orcl#print name sal;
NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
MILLER
SAL
----------
3220
create or replace procedure p_emp (v_eno number,v_enam in out varchar2,v_sa in out number)
as
type emp_record_type is record(
v_empno emp.empno%type,
v_ename emp.ename%type,
v_job emp.job%type,
v_sal emp.sal%type);
emp_re emp_record_type;
begin
select empno,ename,job,sal into emp_re.v_empno,emp_re.v_ename,emp_re.v_job,emp_re.v_sal
from emp where empno=v_eno;
v_enam:=EMP_RE.v_ename;
v_sa:=emp_re.v_sal;
dbms_output.put_line(emp_re.v_empno||'@@@@'||emp_re.v_ename||'@@@@'||emp_re.v_job||'@@@@'||emp_re.v_sal);
end;
/
create or replace procedure compute(
num1 in out number,num2 in out number)
is
v1 number;
v2 number;
begin
v1:=num1/num2;
v2:=mod(num1,num2);
num1:=v1;
num2:=v2;
end;
/
SCOTT@orcl#var m1 number;
SCOTT@orcl#var m2 number;
SCOTT@orcl#exec :m1:=100;
PL/SQL 过程已成功完成。
SCOTT@orcl#exec :m2:=200;
PL/SQL 过程已成功完成。
SCOTT@orcl#exec compute(:m1,:m2);
PL/SQL 过程已成功完成。
SCOTT@orcl#print m1 m2;
M1
----------
.5
M2
----------
100
user_source;all_source;
OWNER VARCHAR2(30) NOT NULL Owner of the object
NAME VARCHAR2(30) NOT NULL Name of the object
TYPE VARCHAR2(12) Type of object: FUNCTION, JAVA SOURCE, PACKAGE, PACKAGE BODY, PROCEDURE, TRIGGER, TYPE, TYPE BODY
LINE NUMBER NOT NULL Line number of this line of source
TEXT VARCHAR2(4000) Text source of the stored object
create or replace function emp_fun
return varchar2
is
v_loginuser varchar2(20);
begin
select sys.login_user into v_loginuser from dual;
return v_loginuser;
end;
/
create or replace function emp_full
(v_empn number)
return varchar2
is
emp_record emp%rowtype;
begin
select * into emp_record from emp where empno=v_empn;
return emp_record.ename;
end;
/
CREATE OR REPLACE FUNCTION MYUSER02
RETURN VARCHAR2
IS
V_QNTY VARCHAR2(20);
BEGIN
SELECT USERENV('SID') INTO V_QNTY FROM DUAL;
RETURN V_QNTY;
END;
/
SCOTT@orcl#r
1 declare
2 type emp_table_cursor is ref cursor return emp%rowtype;
3 c_emp emp_table_cursor;
4 rec_emp emp%rowtype;
5 begin
6 if not c_emp%isopen then
7 open c_emp for select * from emp where deptno=10;
8 end if;
9 loop
10 fetch c_emp into rec_emp;
11 exit when c_emp%notfound;
12 dbms_output.put_line('@@@@@@@#####::::'||rec_emp.ename);
13 end loop;
14 close c_emp;
15* end;
@@@@@@@#####::::CLARK
@@@@@@@#####::::KING
@@@@@@@#####::::MILLER
PL/SQL 过程已成功完成。
SCOTT@orcl#create type emp_type is object
2 (name varchar2(10),sal number(6,2));
3 ;
4
SCOTT@orcl#create type emp_type is object
2 (name varchar2(10),sal number(6,2))
3 /
类型已创建。
SCOTT@orcl#declare
2 emp emp_type;
3 begin
4 emp.name:='SCOTT';
5 exception
6 when access_into_null then
7 dbms_output.put_line('init the object first');
8 end;
9 /
init the object first
PL/SQL 过程已成功完成。
SCOTT@orcl#declare
2 type ename_table_type is table of emp.ename%type;
3 ename_table ename_table_type;
4 begin
5 select ename into ename_table(2) from emp where empno=7788;
6 dbms_oputput.put_line('ok');
7 exception
8 when collection_is_null then
9 dbms_output.put_line('error');
10 end;
11 /
dbms_oputput.put_line('ok');
*
第 6 行出现错误:
ORA-06550: 第 6 行, 第 1 列:
PLS-00201: 必须声明标识符 'DBMS_OPUTPUT.PUT_LINE'
ORA-06550: 第 6 行, 第 1 列:
PL/SQL: Statement ignored
SCOTT@orcl#6
6* dbms_oputput.put_line('ok');
SCOTT@orcl#c /oputput/output
6* dbms_output.put_line('ok');
SCOTT@orcl#r
1 declare
2 type ename_table_type is table of emp.ename%type;
3 ename_table ename_table_type;
4 begin
5 select ename into ename_table(2) from emp where empno=7788;
6 dbms_output.put_line('ok');
7 exception
8 when collection_is_null then
9 dbms_output.put_line('error');
10* end;
error
PL/SQL 过程已成功完成。
SCOTT@orcl#begin
2 ;
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#select * from emp;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- -------------------- ------------------ ---------- -------------- ---------- ---------- ----------
7369 SMITH CLERK 7902 17-12月-80 3020 20
7499 ALLEN SALESMAN 7698 20-2月 -81 4820 300 30
7521 WARD SALESMAN 7698 22-2月 -81 4470 500 30
7566 JONES MANAGER 7839 02-4月 -81 4195 20
7654 MARTIN SALESMAN 7698 28-9月 -81 4470 1400 30
7698 BLAKE MANAGER 7839 01-5月 -81 4070 30
7782 CLARK hello 7839 09-6月 -81 3670 10
7788 SCOTT h 7566 19-4月 -87 422 20
7839 KING PRESIDENT 17-11月-81 5220 10
7844 TURNER hello 7698 08-9月 -81 4720 0 30
7876 ADAMS hello 7788 23-5月 -87 3320 20
7000 MILLER hello 2000 23-1月 -82 3220 10
2000 rhys DBA 2000 01-5月 -13 20000 200 30
已选择13行。
SCOTT@orcl#desc emp;
名称 是否为空? 类型
----------------------------------------------------------------------------------------------------------------- -------- ----------------------------------------------------------------------------
EMPNO NUMBER(38)
ENAME VARCHAR2(10)
JOB VARCHAR2(9)
MGR NUMBER(4)
HIREDATE DATE
SAL NUMBER
COMM NUMBER(7,2)
DEPTNO NUMBER(2)
SCOTT@orcl#desc user_constraints;
名称 是否为空? 类型
----------------------------------------------------------------------------------------------------------------- -------- ----------------------------------------------------------------------------
OWNER NOT NULL VARCHAR2(30)
CONSTRAINT_NAME NOT NULL VARCHAR2(30)
CONSTRAINT_TYPE VARCHAR2(1)
TABLE_NAME NOT NULL VARCHAR2(30)
SEARCH_CONDITION LONG
R_OWNER VARCHAR2(30)
R_CONSTRAINT_NAME VARCHAR2(30)
DELETE_RULE VARCHAR2(9)
STATUS VARCHAR2(8)
DEFERRABLE VARCHAR2(14)
DEFERRED VARCHAR2(9)
VALIDATED VARCHAR2(13)
GENERATED VARCHAR2(14)
BAD VARCHAR2(3)
RELY VARCHAR2(4)
LAST_CHANGE DATE
INDEX_OWNER VARCHAR2(30)
INDEX_NAME VARCHAR2(30)
INVALID VARCHAR2(7)
VIEW_RELATED VARCHAR2(14)
SCOTT@orcl#select constraint_name,constraint_type,table_name,status from user_constraints where table_name='EMP';
未选定行
SCOTT@orcl#alter table emp add constraint primary_k primary key(empno);
表已更改。
SCOTT@orcl#select constraint_name,constraint_type,table_name,status from user_constraints where table_name='EMP';
CONSTRAINT_NAME CO TABLE_NAME STATUS
------------------------------------------------------------ -- ------------------------------------------------------------ ----------------
PRIMARY_K P EMP ENABLED
SCOTT@orcl#select * from user_cons_columns;
OWNER CONSTRAINT_NAME TABLE_NAME
------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
POSITION
----------
SCOTT PK_DEPT DEPT
DEPTNO
1
SCOTT BIN$3IGbb/U3Wd7gQKjABIlTGg==$0 BIN$3IGbb/U5Wd7gQKjABIlTGg==$0
SCHEMA_ID
1
SCOTT BIN$3IGbb/U2Wd7gQKjABIlTGg==$0 BIN$3IGbb/U5Wd7gQKjABIlTGg==$0
VERSION
SCOTT BIN$3IGbb/U6Wd7gQKjABIlTGg==$0 BIN$3IGbb/U+Wd7gQKjABIlTGg==$0
TRACE_FILE_ID
SCOTT BIN$3IGbb/U8Wd7gQKjABIlTGg==$0 BIN$3IGbb/U+Wd7gQKjABIlTGg==$0
TRACE_FILE_ID
1
SCOTT BIN$3IGbb/U8Wd7gQKjABIlTGg==$0 BIN$3IGbb/U+Wd7gQKjABIlTGg==$0
SQL_ID
2
SCOTT BIN$3IGbb/U8Wd7gQKjABIlTGg==$0 BIN$3IGbb/U+Wd7gQKjABIlTGg==$0
PARSE_ID
3
SCOTT BIN$3IGbb/U8Wd7gQKjABIlTGg==$0 BIN$3IGbb/U+Wd7gQKjABIlTGg==$0
EXECUTION_ID
4
SCOTT BIN$3IGbb/U7Wd7gQKjABIlTGg==$0 BIN$3IGbb/U+Wd7gQKjABIlTGg==$0
ERROR_ID
SCOTT BIN$3IGbb/U8Wd7gQKjABIlTGg==$0 BIN$3IGbb/U+Wd7gQKjABIlTGg==$0
ERROR_ID
5
SCOTT BIN$3IGbb/U/Wd7gQKjABIlTGg==$0 BIN$3IGbb/VJWd7gQKjABIlTGg==$0
TRACE_FILE_ID
OWNER CONSTRAINT_NAME TABLE_NAME
------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
POSITION
----------
SCOTT BIN$3IGbb/VHWd7gQKjABIlTGg==$0 BIN$3IGbb/VJWd7gQKjABIlTGg==$0
TRACE_FILE_ID
1
SCOTT BIN$3IGbb/VAWd7gQKjABIlTGg==$0 BIN$3IGbb/VJWd7gQKjABIlTGg==$0
SQL_ID
SCOTT BIN$3IGbb/VHWd7gQKjABIlTGg==$0 BIN$3IGbb/VJWd7gQKjABIlTGg==$0
SQL_ID
2
SCOTT BIN$3IGbb/VBWd7gQKjABIlTGg==$0 BIN$3IGbb/VJWd7gQKjABIlTGg==$0
PARSE_ID
SCOTT BIN$3IGbb/VHWd7gQKjABIlTGg==$0 BIN$3IGbb/VJWd7gQKjABIlTGg==$0
PARSE_ID
3
SCOTT BIN$3IGbb/VCWd7gQKjABIlTGg==$0 BIN$3IGbb/VJWd7gQKjABIlTGg==$0
WAIT_ID
SCOTT BIN$3IGbb/VHWd7gQKjABIlTGg==$0 BIN$3IGbb/VJWd7gQKjABIlTGg==$0
WAIT_ID
4
SCOTT BIN$3IGbb/VDWd7gQKjABIlTGg==$0 BIN$3IGbb/VJWd7gQKjABIlTGg==$0
NAM
SCOTT BIN$3IGbb/VEWd7gQKjABIlTGg==$0 BIN$3IGbb/VJWd7gQKjABIlTGg==$0
WAIT_COUNT
SCOTT BIN$3IGbb/VFWd7gQKjABIlTGg==$0 BIN$3IGbb/VJWd7gQKjABIlTGg==$0
SUM_ELAPSED
SCOTT BIN$3IGbb/VGWd7gQKjABIlTGg==$0 BIN$3IGbb/VJWd7gQKjABIlTGg==$0
SUMSQUARES_ELAPSED
OWNER CONSTRAINT_NAME TABLE_NAME
------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
POSITION
----------
SCOTT BIN$3IGbb/VKWd7gQKjABIlTGg==$0 BIN$3IGbb/VRWd7gQKjABIlTGg==$0
TRACE_FILE_ID
SCOTT BIN$3IGbb/VPWd7gQKjABIlTGg==$0 BIN$3IGbb/VRWd7gQKjABIlTGg==$0
TRACE_FILE_ID
1
SCOTT BIN$3IGbb/VLWd7gQKjABIlTGg==$0 BIN$3IGbb/VRWd7gQKjABIlTGg==$0
SQL_ID
SCOTT BIN$3IGbb/VPWd7gQKjABIlTGg==$0 BIN$3IGbb/VRWd7gQKjABIlTGg==$0
SQL_ID
2
SCOTT BIN$3IGbb/VMWd7gQKjABIlTGg==$0 BIN$3IGbb/VRWd7gQKjABIlTGg==$0
PARSE_ID
SCOTT BIN$3IGbb/VPWd7gQKjABIlTGg==$0 BIN$3IGbb/VRWd7gQKjABIlTGg==$0
PARSE_ID
3
SCOTT BIN$3IGbb/VNWd7gQKjABIlTGg==$0 BIN$3IGbb/VRWd7gQKjABIlTGg==$0
ID
SCOTT BIN$3IGbb/VPWd7gQKjABIlTGg==$0 BIN$3IGbb/VRWd7gQKjABIlTGg==$0
ID
4
SCOTT BIN$3IGbb/VOWd7gQKjABIlTGg==$0 BIN$3IGbb/VRWd7gQKjABIlTGg==$0
OPERATION_ID
SCOTT BIN$3IGbb/VSWd7gQKjABIlTGg==$0 BIN$3IGbb/VYWd7gQKjABIlTGg==$0
TRACE_FILE_ID
SCOTT BIN$3IGbb/VWWd7gQKjABIlTGg==$0 BIN$3IGbb/VYWd7gQKjABIlTGg==$0
OWNER CONSTRAINT_NAME TABLE_NAME
------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
POSITION
----------
TRACE_FILE_ID
1
SCOTT BIN$3IGbb/VTWd7gQKjABIlTGg==$0 BIN$3IGbb/VYWd7gQKjABIlTGg==$0
SQL_ID
SCOTT BIN$3IGbb/VWWd7gQKjABIlTGg==$0 BIN$3IGbb/VYWd7gQKjABIlTGg==$0
SQL_ID
2
SCOTT BIN$3IGbb/VUWd7gQKjABIlTGg==$0 BIN$3IGbb/VYWd7gQKjABIlTGg==$0
PARSE_ID
SCOTT BIN$3IGbb/VWWd7gQKjABIlTGg==$0 BIN$3IGbb/VYWd7gQKjABIlTGg==$0
PARSE_ID
3
SCOTT BIN$3IGbb/VVWd7gQKjABIlTGg==$0 BIN$3IGbb/VYWd7gQKjABIlTGg==$0
CURSOR_NO
SCOTT BIN$3IGbb/VZWd7gQKjABIlTGg==$0 BIN$3IGbb/VfWd7gQKjABIlTGg==$0
TRACE_FILE_ID
SCOTT BIN$3IGbb/VdWd7gQKjABIlTGg==$0 BIN$3IGbb/VfWd7gQKjABIlTGg==$0
TRACE_FILE_ID
1
SCOTT BIN$3IGbb/VaWd7gQKjABIlTGg==$0 BIN$3IGbb/VfWd7gQKjABIlTGg==$0
SQL_ID
SCOTT BIN$3IGbb/VdWd7gQKjABIlTGg==$0 BIN$3IGbb/VfWd7gQKjABIlTGg==$0
SQL_ID
2
SCOTT BIN$3IGbb/VbWd7gQKjABIlTGg==$0 BIN$3IGbb/VfWd7gQKjABIlTGg==$0
PARSE_ID
OWNER CONSTRAINT_NAME TABLE_NAME
------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
POSITION
----------
SCOTT BIN$3IGbb/VdWd7gQKjABIlTGg==$0 BIN$3IGbb/VfWd7gQKjABIlTGg==$0
PARSE_ID
3
SCOTT BIN$3IGbb/VcWd7gQKjABIlTGg==$0 BIN$3IGbb/VfWd7gQKjABIlTGg==$0
ERROR_ID
SCOTT BIN$3IGbb/VdWd7gQKjABIlTGg==$0 BIN$3IGbb/VfWd7gQKjABIlTGg==$0
ERROR_ID
4
SCOTT BIN$3IGbb/VgWd7gQKjABIlTGg==$0 BIN$3IGbb/VpWd7gQKjABIlTGg==$0
SESSION_ID
SCOTT BIN$3IGbb/VnWd7gQKjABIlTGg==$0 BIN$3IGbb/VpWd7gQKjABIlTGg==$0
SESSION_ID
5
SCOTT BIN$3IGbb/VhWd7gQKjABIlTGg==$0 BIN$3IGbb/VpWd7gQKjABIlTGg==$0
SID
SCOTT BIN$3IGbb/ViWd7gQKjABIlTGg==$0 BIN$3IGbb/VpWd7gQKjABIlTGg==$0
SERIAL
SCOTT BIN$3IGbb/VjWd7gQKjABIlTGg==$0 BIN$3IGbb/VpWd7gQKjABIlTGg==$0
TRACE_FILE_ID
SCOTT BIN$3IGbb/VnWd7gQKjABIlTGg==$0 BIN$3IGbb/VpWd7gQKjABIlTGg==$0
TRACE_FILE_ID
1
SCOTT BIN$3IGbb/VkWd7gQKjABIlTGg==$0 BIN$3IGbb/VpWd7gQKjABIlTGg==$0
SQL_ID
SCOTT BIN$3IGbb/VnWd7gQKjABIlTGg==$0 BIN$3IGbb/VpWd7gQKjABIlTGg==$0
SQL_ID
2
OWNER CONSTRAINT_NAME TABLE_NAME
------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
POSITION
----------
SCOTT BIN$3IGbb/VlWd7gQKjABIlTGg==$0 BIN$3IGbb/VpWd7gQKjABIlTGg==$0
PARSE_ID
SCOTT BIN$3IGbb/VnWd7gQKjABIlTGg==$0 BIN$3IGbb/VpWd7gQKjABIlTGg==$0
PARSE_ID
3
SCOTT BIN$3IGbb/VmWd7gQKjABIlTGg==$0 BIN$3IGbb/VpWd7gQKjABIlTGg==$0
EXECUTION_ID
SCOTT BIN$3IGbb/VnWd7gQKjABIlTGg==$0 BIN$3IGbb/VpWd7gQKjABIlTGg==$0
EXECUTION_ID
4
SCOTT BIN$3IGbb/VqWd7gQKjABIlTGg==$0 BIN$3IGbb/VxWd7gQKjABIlTGg==$0
TRACE_FILE_ID
SCOTT BIN$3IGbb/VvWd7gQKjABIlTGg==$0 BIN$3IGbb/VxWd7gQKjABIlTGg==$0
TRACE_FILE_ID
1
SCOTT BIN$3IGbb/VrWd7gQKjABIlTGg==$0 BIN$3IGbb/VxWd7gQKjABIlTGg==$0
SQL_ID
SCOTT BIN$3IGbb/VvWd7gQKjABIlTGg==$0 BIN$3IGbb/VxWd7gQKjABIlTGg==$0
SQL_ID
2
SCOTT BIN$3IGbb/VsWd7gQKjABIlTGg==$0 BIN$3IGbb/VxWd7gQKjABIlTGg==$0
PARSE_ID
SCOTT BIN$3IGbb/VvWd7gQKjABIlTGg==$0 BIN$3IGbb/VxWd7gQKjABIlTGg==$0
PARSE_ID
3
SCOTT BIN$3IGbb/VtWd7gQKjABIlTGg==$0 BIN$3IGbb/VxWd7gQKjABIlTGg==$0
EXECUTION_ID
OWNER CONSTRAINT_NAME TABLE_NAME
------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
POSITION
----------
SCOTT BIN$3IGbb/VvWd7gQKjABIlTGg==$0 BIN$3IGbb/VxWd7gQKjABIlTGg==$0
EXECUTION_ID
4
SCOTT BIN$3IGbb/VuWd7gQKjABIlTGg==$0 BIN$3IGbb/VxWd7gQKjABIlTGg==$0
BIND_VAR_ID
SCOTT BIN$3IGbb/VvWd7gQKjABIlTGg==$0 BIN$3IGbb/VxWd7gQKjABIlTGg==$0
BIND_VAR_ID
5
SCOTT BIN$3IGbb/VyWd7gQKjABIlTGg==$0 BIN$3IGbb/V4Wd7gQKjABIlTGg==$0
TRACE_FILE_ID
SCOTT BIN$3IGbb/V2Wd7gQKjABIlTGg==$0 BIN$3IGbb/V4Wd7gQKjABIlTGg==$0
TRACE_FILE_ID
1
SCOTT BIN$3IGbb/VzWd7gQKjABIlTGg==$0 BIN$3IGbb/V4Wd7gQKjABIlTGg==$0
SQL_ID
SCOTT BIN$3IGbb/V2Wd7gQKjABIlTGg==$0 BIN$3IGbb/V4Wd7gQKjABIlTGg==$0
SQL_ID
2
SCOTT BIN$3IGbb/V0Wd7gQKjABIlTGg==$0 BIN$3IGbb/V4Wd7gQKjABIlTGg==$0
PARSE_ID
SCOTT BIN$3IGbb/V2Wd7gQKjABIlTGg==$0 BIN$3IGbb/V4Wd7gQKjABIlTGg==$0
PARSE_ID
3
SCOTT BIN$3IGbb/V1Wd7gQKjABIlTGg==$0 BIN$3IGbb/V4Wd7gQKjABIlTGg==$0
EXECUTION_ID
SCOTT BIN$3IGbb/V2Wd7gQKjABIlTGg==$0 BIN$3IGbb/V4Wd7gQKjABIlTGg==$0
OWNER CONSTRAINT_NAME TABLE_NAME
------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
POSITION
----------
EXECUTION_ID
4
SCOTT BIN$3IGbb/V5Wd7gQKjABIlTGg==$0 BIN$3IGbb/WDWd7gQKjABIlTGg==$0
TRACE_FILE_ID
SCOTT BIN$3IGbb/WBWd7gQKjABIlTGg==$0 BIN$3IGbb/WDWd7gQKjABIlTGg==$0
TRACE_FILE_ID
1
SCOTT BIN$3IGbb/V6Wd7gQKjABIlTGg==$0 BIN$3IGbb/WDWd7gQKjABIlTGg==$0
SQL_ID
SCOTT BIN$3IGbb/WBWd7gQKjABIlTGg==$0 BIN$3IGbb/WDWd7gQKjABIlTGg==$0
SQL_ID
2
SCOTT BIN$3IGbb/V7Wd7gQKjABIlTGg==$0 BIN$3IGbb/WDWd7gQKjABIlTGg==$0
PARSE_ID
SCOTT BIN$3IGbb/WBWd7gQKjABIlTGg==$0 BIN$3IGbb/WDWd7gQKjABIlTGg==$0
PARSE_ID
3
SCOTT BIN$3IGbb/V8Wd7gQKjABIlTGg==$0 BIN$3IGbb/WDWd7gQKjABIlTGg==$0
EXECUTION_ID
SCOTT BIN$3IGbb/WBWd7gQKjABIlTGg==$0 BIN$3IGbb/WDWd7gQKjABIlTGg==$0
EXECUTION_ID
4
SCOTT BIN$3IGbb/V9Wd7gQKjABIlTGg==$0 BIN$3IGbb/WDWd7gQKjABIlTGg==$0
FETCH_ID
SCOTT BIN$3IGbb/WBWd7gQKjABIlTGg==$0 BIN$3IGbb/WDWd7gQKjABIlTGg==$0
FETCH_ID
5
OWNER CONSTRAINT_NAME TABLE_NAME
------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
POSITION
----------
SCOTT BIN$3IGbb/V+Wd7gQKjABIlTGg==$0 BIN$3IGbb/WDWd7gQKjABIlTGg==$0
FETCH_COUNT
SCOTT BIN$3IGbb/V/Wd7gQKjABIlTGg==$0 BIN$3IGbb/WDWd7gQKjABIlTGg==$0
CPU
SCOTT BIN$3IGbb/WAWd7gQKjABIlTGg==$0 BIN$3IGbb/WDWd7gQKjABIlTGg==$0
ELAPSED
SCOTT BIN$3IGbb/WEWd7gQKjABIlTGg==$0 BIN$3IGbb/WJWd7gQKjABIlTGg==$0
TRACE_FILE_ID
SCOTT BIN$3IGbb/WGWd7gQKjABIlTGg==$0 BIN$3IGbb/WJWd7gQKjABIlTGg==$0
TRACE_FILE_ID
1
SCOTT BIN$3IGbb/WFWd7gQKjABIlTGg==$0 BIN$3IGbb/WJWd7gQKjABIlTGg==$0
SQL_ID
SCOTT BIN$3IGbb/WGWd7gQKjABIlTGg==$0 BIN$3IGbb/WJWd7gQKjABIlTGg==$0
SQL_ID
2
SCOTT BIN$3IGbb/WKWd7gQKjABIlTGg==$0 BIN$3IGbb/WPWd7gQKjABIlTGg==$0
TRACE_FILE_ID
SCOTT BIN$3IGbb/WNWd7gQKjABIlTGg==$0 BIN$3IGbb/WPWd7gQKjABIlTGg==$0
TRACE_FILE_ID
1
SCOTT BIN$3IGbb/WLWd7gQKjABIlTGg==$0 BIN$3IGbb/WPWd7gQKjABIlTGg==$0
SQL_ID
SCOTT BIN$3IGbb/WNWd7gQKjABIlTGg==$0 BIN$3IGbb/WPWd7gQKjABIlTGg==$0
SQL_ID
2
OWNER CONSTRAINT_NAME TABLE_NAME
------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
POSITION
----------
SCOTT BIN$3IGbb/WMWd7gQKjABIlTGg==$0 BIN$3IGbb/WPWd7gQKjABIlTGg==$0
PIECE_NO
SCOTT BIN$3IGbb/WNWd7gQKjABIlTGg==$0 BIN$3IGbb/WPWd7gQKjABIlTGg==$0
PIECE_NO
3
SCOTT BIN$3IGbb/WQWd7gQKjABIlTGg==$0 BIN$3IGbb/WZWd7gQKjABIlTGg==$0
TRACE_FILE_ID
SCOTT BIN$3IGbb/WXWd7gQKjABIlTGg==$0 BIN$3IGbb/WZWd7gQKjABIlTGg==$0
TRACE_FILE_ID
1
SCOTT BIN$3IGbb/WRWd7gQKjABIlTGg==$0 BIN$3IGbb/WZWd7gQKjABIlTGg==$0
SQL_ID
SCOTT BIN$3IGbb/WXWd7gQKjABIlTGg==$0 BIN$3IGbb/WZWd7gQKjABIlTGg==$0
SQL_ID
2
SCOTT BIN$3IGbb/WSWd7gQKjABIlTGg==$0 BIN$3IGbb/WZWd7gQKjABIlTGg==$0
PARSE_ID
SCOTT BIN$3IGbb/WXWd7gQKjABIlTGg==$0 BIN$3IGbb/WZWd7gQKjABIlTGg==$0
PARSE_ID
3
SCOTT BIN$3IGbb/WTWd7gQKjABIlTGg==$0 BIN$3IGbb/WZWd7gQKjABIlTGg==$0
EXECUTION_ID
SCOTT BIN$3IGbb/WXWd7gQKjABIlTGg==$0 BIN$3IGbb/WZWd7gQKjABIlTGg==$0
EXECUTION_ID
4
SCOTT BIN$3IGbb/WUWd7gQKjABIlTGg==$0 BIN$3IGbb/WZWd7gQKjABIlTGg==$0
WAIT_ID
OWNER CONSTRAINT_NAME TABLE_NAME
------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
POSITION
----------
SCOTT BIN$3IGbb/WXWd7gQKjABIlTGg==$0 BIN$3IGbb/WZWd7gQKjABIlTGg==$0
WAIT_ID
5
SCOTT BIN$3IGbb/WVWd7gQKjABIlTGg==$0 BIN$3IGbb/WZWd7gQKjABIlTGg==$0
WAIT_COUNT
SCOTT BIN$3IGbb/WWWd7gQKjABIlTGg==$0 BIN$3IGbb/WZWd7gQKjABIlTGg==$0
EVENT_ID
SCOTT BIN$3IGbb/UqWd7gQKjABIlTGg==$0 BIN$3IGbb/UxWd7gQKjABIlTGg==$0
TRACE_FILE_ID
SCOTT BIN$3IGbb/UtWd7gQKjABIlTGg==$0 BIN$3IGbb/UxWd7gQKjABIlTGg==$0
TRACE_FILE_ID
1
SCOTT BIN$3IGbb/UuWd7gQKjABIlTGg==$0 BIN$3IGbb/UxWd7gQKjABIlTGg==$0
TRACE_FILE_ID
2
SCOTT BIN$3IGbb/UrWd7gQKjABIlTGg==$0 BIN$3IGbb/UxWd7gQKjABIlTGg==$0
INST_ID
SCOTT BIN$3IGbb/UuWd7gQKjABIlTGg==$0 BIN$3IGbb/UxWd7gQKjABIlTGg==$0
INST_ID
1
SCOTT BIN$3IGbb/UsWd7gQKjABIlTGg==$0 BIN$3IGbb/UxWd7gQKjABIlTGg==$0
TRACE_FILE_NAME
SCOTT BIN$3IGbb/UkWd7gQKjABIlTGg==$0 BIN$3IGbb/UpWd7gQKjABIlTGg==$0
EVENT_ID
SCOTT BIN$3IGbb/UlWd7gQKjABIlTGg==$0 BIN$3IGbb/UpWd7gQKjABIlTGg==$0
OWNER CONSTRAINT_NAME TABLE_NAME
------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
POSITION
----------
EVENT_ID
1
SCOTT BIN$3IGbb/UmWd7gQKjABIlTGg==$0 BIN$3IGbb/UpWd7gQKjABIlTGg==$0
NAM
1
SCOTT BIN$3IGbb/UfWd7gQKjABIlTGg==$0 BIN$3IGbb/UjWd7gQKjABIlTGg==$0
OPERATION_ID
SCOTT BIN$3IGbb/UhWd7gQKjABIlTGg==$0 BIN$3IGbb/UjWd7gQKjABIlTGg==$0
OPERATION_ID
1
SCOTT BIN$3IGbb/UgWd7gQKjABIlTGg==$0 BIN$3IGbb/UjWd7gQKjABIlTGg==$0
TRACE_FILE_ID
SCOTT BIN$3IGbb/UhWd7gQKjABIlTGg==$0 BIN$3IGbb/UjWd7gQKjABIlTGg==$0
TRACE_FILE_ID
2
SCOTT SYS_C0012898 MYBOOK
BOOKID
SCOTT BOOK1_PK MYBOOK
BOOKID
1
SCOTT SYS_C0012902 MYBOOK5
BOOKID
SCOTT SYS_C0012903 MYBOOK5
BOOKID
1
SCOTT SYS_C0012904 MYBOOK5_1
BOOKID
OWNER CONSTRAINT_NAME TABLE_NAME
------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
POSITION
----------
SCOTT SYS_C0012905 MYBOOK5_1
BOOKID
1
SCOTT SYS_C0012928 BOOKS_01
B_ID
SCOTT UNIQUE_KEY_02 BOOKS_01
B_ID
1
SCOTT SYS_C0012929 BOOKS_01
B_NAME
SCOTT PR B
B
1
SCOTT PRIMARY_K EMP
EMPNO
1
SCOTT FORE A
A
1
SCOTT UNI A
B
1
SCOTT UNIQ C
A
1
SCOTT PRI_KEY SEQUENCE01
ID
1
SCOTT SYS_C0013308 EMPLOYEE
SYS_NC0000400005$
1
OWNER CONSTRAINT_NAME TABLE_NAME
------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
POSITION
----------
已选择140行。
SCOTT@orcl#col COLUMN_NAME for a30;
SCOTT@orcl#r
1* select * from user_cons_columns
OWNER CONSTRAINT_NAME TABLE_NAME
------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------
COLUMN_NAME POSITION
------------------------------ ----------
SCOTT PK_DEPT DEPT
DEPTNO 1
SCOTT BIN$3IGbb/U3Wd7gQKjABIlTGg==$0 BIN$3IGbb/U5Wd7gQKjABIlTGg==$0
SCHEMA_ID 1
SCOTT BIN$3IGbb/U2Wd7gQKjABIlTGg==$0 BIN$3IGbb/U5Wd7gQKjABIlTGg==$0
VERSION
SCOTT BIN$3IGbb/U6Wd7gQKjABIlTGg==$0 BIN$3IGbb/U+Wd7gQKjABIlTGg==$0
TRACE_FILE_ID
SCOTT BIN$3IGbb/U8Wd7gQKjABIlTGg==$0 BIN$3IGbb/U+Wd7gQKjABIlTGg==$0
TRACE_FILE_ID 1
SCOTT BIN$3IGbb/U8Wd7gQKjABIlTGg==$0 BIN$3IGbb/U+Wd7gQKjABIlTGg==$0
SQL_ID 2
SCOTT BIN$3IGbb/U8Wd7gQKjABIlTGg==$0 BIN$3IGbb/U+Wd7gQKjABIlTGg==$0
PARSE_ID 3
SCOTT BIN$3IGbb/U8Wd7gQKjABIlTGg==$0 BIN$3IGbb/U+Wd7gQKjABIlTGg==$0
EXECUTION_ID 4
SCOTT BIN$3IGbb/U7Wd7gQKjABIlTGg==$0 BIN$3IGbb/U+Wd7gQKjABIlTGg==$0
ERROR_ID
SCOTT BIN$3IGbb/U8Wd7gQKjABIlTGg==$0 BIN$3IGbb/U+Wd7gQKjABIlTGg==$0
ERROR_ID 5
SCOTT BIN$3IGbb/U/Wd7gQKjABIlTGg==$0 BIN$3IGbb/VJWd7gQKjABIlTGg==$0
TRACE_FILE_ID
SCOTT BIN$3IGbb/VHWd7gQKjABIlTGg==$0 BIN$3IGbb/VJWd7gQKjABIlTGg==$0
TRACE_FILE_ID 1
SCOTT BIN$3IGbb/VAWd7gQKjABIlTGg==$0 BIN$3IGbb/VJWd7gQKjABIlTGg==$0
SQL_ID
SCOTT BIN$3IGbb/VHWd7gQKjABIlTGg==$0 BIN$3IGbb/VJWd7gQKjABIlTGg==$0
SQL_ID 2
SCOTT BIN$3IGbb/VBWd7gQKjABIlTGg==$0 BIN$3IGbb/VJWd7gQKjABIlTGg==$0
PARSE_ID
OWNER CONSTRAINT_NAME TABLE_NAME
------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------
COLUMN_NAME POSITION
------------------------------ ----------
SCOTT BIN$3IGbb/VHWd7gQKjABIlTGg==$0 BIN$3IGbb/VJWd7gQKjABIlTGg==$0
PARSE_ID 3
SCOTT BIN$3IGbb/VCWd7gQKjABIlTGg==$0 BIN$3IGbb/VJWd7gQKjABIlTGg==$0
WAIT_ID
SCOTT BIN$3IGbb/VHWd7gQKjABIlTGg==$0 BIN$3IGbb/VJWd7gQKjABIlTGg==$0
WAIT_ID 4
SCOTT BIN$3IGbb/VDWd7gQKjABIlTGg==$0 BIN$3IGbb/VJWd7gQKjABIlTGg==$0
NAM
SCOTT BIN$3IGbb/VEWd7gQKjABIlTGg==$0 BIN$3IGbb/VJWd7gQKjABIlTGg==$0
WAIT_COUNT
SCOTT BIN$3IGbb/VFWd7gQKjABIlTGg==$0 BIN$3IGbb/VJWd7gQKjABIlTGg==$0
SUM_ELAPSED
SCOTT BIN$3IGbb/VGWd7gQKjABIlTGg==$0 BIN$3IGbb/VJWd7gQKjABIlTGg==$0
SUMSQUARES_ELAPSED
SCOTT BIN$3IGbb/VKWd7gQKjABIlTGg==$0 BIN$3IGbb/VRWd7gQKjABIlTGg==$0
TRACE_FILE_ID
SCOTT BIN$3IGbb/VPWd7gQKjABIlTGg==$0 BIN$3IGbb/VRWd7gQKjABIlTGg==$0
TRACE_FILE_ID 1
SCOTT BIN$3IGbb/VLWd7gQKjABIlTGg==$0 BIN$3IGbb/VRWd7gQKjABIlTGg==$0
SQL_ID
SCOTT BIN$3IGbb/VPWd7gQKjABIlTGg==$0 BIN$3IGbb/VRWd7gQKjABIlTGg==$0
SQL_ID 2
SCOTT BIN$3IGbb/VMWd7gQKjABIlTGg==$0 BIN$3IGbb/VRWd7gQKjABIlTGg==$0
PARSE_ID
SCOTT BIN$3IGbb/VPWd7gQKjABIlTGg==$0 BIN$3IGbb/VRWd7gQKjABIlTGg==$0
PARSE_ID 3
SCOTT BIN$3IGbb/VNWd7gQKjABIlTGg==$0 BIN$3IGbb/VRWd7gQKjABIlTGg==$0
ID
SCOTT BIN$3IGbb/VPWd7gQKjABIlTGg==$0 BIN$3IGbb/VRWd7gQKjABIlTGg==$0
ID 4
OWNER CONSTRAINT_NAME TABLE_NAME
------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------
COLUMN_NAME POSITION
------------------------------ ----------
SCOTT BIN$3IGbb/VOWd7gQKjABIlTGg==$0 BIN$3IGbb/VRWd7gQKjABIlTGg==$0
OPERATION_ID
SCOTT BIN$3IGbb/VSWd7gQKjABIlTGg==$0 BIN$3IGbb/VYWd7gQKjABIlTGg==$0
TRACE_FILE_ID
SCOTT BIN$3IGbb/VWWd7gQKjABIlTGg==$0 BIN$3IGbb/VYWd7gQKjABIlTGg==$0
TRACE_FILE_ID 1
SCOTT BIN$3IGbb/VTWd7gQKjABIlTGg==$0 BIN$3IGbb/VYWd7gQKjABIlTGg==$0
SQL_ID
SCOTT BIN$3IGbb/VWWd7gQKjABIlTGg==$0 BIN$3IGbb/VYWd7gQKjABIlTGg==$0
SQL_ID 2
SCOTT BIN$3IGbb/VUWd7gQKjABIlTGg==$0 BIN$3IGbb/VYWd7gQKjABIlTGg==$0
PARSE_ID
SCOTT BIN$3IGbb/VWWd7gQKjABIlTGg==$0 BIN$3IGbb/VYWd7gQKjABIlTGg==$0
PARSE_ID 3
SCOTT BIN$3IGbb/VVWd7gQKjABIlTGg==$0 BIN$3IGbb/VYWd7gQKjABIlTGg==$0
CURSOR_NO
SCOTT BIN$3IGbb/VZWd7gQKjABIlTGg==$0 BIN$3IGbb/VfWd7gQKjABIlTGg==$0
TRACE_FILE_ID
SCOTT BIN$3IGbb/VdWd7gQKjABIlTGg==$0 BIN$3IGbb/VfWd7gQKjABIlTGg==$0
TRACE_FILE_ID 1
SCOTT BIN$3IGbb/VaWd7gQKjABIlTGg==$0 BIN$3IGbb/VfWd7gQKjABIlTGg==$0
SQL_ID
SCOTT BIN$3IGbb/VdWd7gQKjABIlTGg==$0 BIN$3IGbb/VfWd7gQKjABIlTGg==$0
SQL_ID 2
SCOTT BIN$3IGbb/VbWd7gQKjABIlTGg==$0 BIN$3IGbb/VfWd7gQKjABIlTGg==$0
PARSE_ID
SCOTT BIN$3IGbb/VdWd7gQKjABIlTGg==$0 BIN$3IGbb/VfWd7gQKjABIlTGg==$0
PARSE_ID 3
SCOTT BIN$3IGbb/VcWd7gQKjABIlTGg==$0 BIN$3IGbb/VfWd7gQKjABIlTGg==$0
ERROR_ID
OWNER CONSTRAINT_NAME TABLE_NAME
------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------
COLUMN_NAME POSITION
------------------------------ ----------
SCOTT BIN$3IGbb/VdWd7gQKjABIlTGg==$0 BIN$3IGbb/VfWd7gQKjABIlTGg==$0
ERROR_ID 4
SCOTT BIN$3IGbb/VgWd7gQKjABIlTGg==$0 BIN$3IGbb/VpWd7gQKjABIlTGg==$0
SESSION_ID
SCOTT BIN$3IGbb/VnWd7gQKjABIlTGg==$0 BIN$3IGbb/VpWd7gQKjABIlTGg==$0
SESSION_ID 5
SCOTT BIN$3IGbb/VhWd7gQKjABIlTGg==$0 BIN$3IGbb/VpWd7gQKjABIlTGg==$0
SID
SCOTT BIN$3IGbb/ViWd7gQKjABIlTGg==$0 BIN$3IGbb/VpWd7gQKjABIlTGg==$0
SERIAL
SCOTT BIN$3IGbb/VjWd7gQKjABIlTGg==$0 BIN$3IGbb/VpWd7gQKjABIlTGg==$0
TRACE_FILE_ID
SCOTT BIN$3IGbb/VnWd7gQKjABIlTGg==$0 BIN$3IGbb/VpWd7gQKjABIlTGg==$0
TRACE_FILE_ID 1
SCOTT BIN$3IGbb/VkWd7gQKjABIlTGg==$0 BIN$3IGbb/VpWd7gQKjABIlTGg==$0
SQL_ID
SCOTT BIN$3IGbb/VnWd7gQKjABIlTGg==$0 BIN$3IGbb/VpWd7gQKjABIlTGg==$0
SQL_ID 2
SCOTT BIN$3IGbb/VlWd7gQKjABIlTGg==$0 BIN$3IGbb/VpWd7gQKjABIlTGg==$0
PARSE_ID
SCOTT BIN$3IGbb/VnWd7gQKjABIlTGg==$0 BIN$3IGbb/VpWd7gQKjABIlTGg==$0
PARSE_ID 3
SCOTT BIN$3IGbb/VmWd7gQKjABIlTGg==$0 BIN$3IGbb/VpWd7gQKjABIlTGg==$0
EXECUTION_ID
SCOTT BIN$3IGbb/VnWd7gQKjABIlTGg==$0 BIN$3IGbb/VpWd7gQKjABIlTGg==$0
EXECUTION_ID 4
SCOTT BIN$3IGbb/VqWd7gQKjABIlTGg==$0 BIN$3IGbb/VxWd7gQKjABIlTGg==$0
TRACE_FILE_ID
SCOTT BIN$3IGbb/VvWd7gQKjABIlTGg==$0 BIN$3IGbb/VxWd7gQKjABIlTGg==$0
TRACE_FILE_ID 1
OWNER CONSTRAINT_NAME TABLE_NAME
------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------
COLUMN_NAME POSITION
------------------------------ ----------
SCOTT BIN$3IGbb/VrWd7gQKjABIlTGg==$0 BIN$3IGbb/VxWd7gQKjABIlTGg==$0
SQL_ID
SCOTT BIN$3IGbb/VvWd7gQKjABIlTGg==$0 BIN$3IGbb/VxWd7gQKjABIlTGg==$0
SQL_ID 2
SCOTT BIN$3IGbb/VsWd7gQKjABIlTGg==$0 BIN$3IGbb/VxWd7gQKjABIlTGg==$0
PARSE_ID
SCOTT BIN$3IGbb/VvWd7gQKjABIlTGg==$0 BIN$3IGbb/VxWd7gQKjABIlTGg==$0
PARSE_ID 3
SCOTT BIN$3IGbb/VtWd7gQKjABIlTGg==$0 BIN$3IGbb/VxWd7gQKjABIlTGg==$0
EXECUTION_ID
SCOTT BIN$3IGbb/VvWd7gQKjABIlTGg==$0 BIN$3IGbb/VxWd7gQKjABIlTGg==$0
EXECUTION_ID 4
SCOTT BIN$3IGbb/VuWd7gQKjABIlTGg==$0 BIN$3IGbb/VxWd7gQKjABIlTGg==$0
BIND_VAR_ID
SCOTT BIN$3IGbb/VvWd7gQKjABIlTGg==$0 BIN$3IGbb/VxWd7gQKjABIlTGg==$0
BIND_VAR_ID 5
SCOTT BIN$3IGbb/VyWd7gQKjABIlTGg==$0 BIN$3IGbb/V4Wd7gQKjABIlTGg==$0
TRACE_FILE_ID
SCOTT BIN$3IGbb/V2Wd7gQKjABIlTGg==$0 BIN$3IGbb/V4Wd7gQKjABIlTGg==$0
TRACE_FILE_ID 1
SCOTT BIN$3IGbb/VzWd7gQKjABIlTGg==$0 BIN$3IGbb/V4Wd7gQKjABIlTGg==$0
SQL_ID
SCOTT BIN$3IGbb/V2Wd7gQKjABIlTGg==$0 BIN$3IGbb/V4Wd7gQKjABIlTGg==$0
SQL_ID 2
SCOTT BIN$3IGbb/V0Wd7gQKjABIlTGg==$0 BIN$3IGbb/V4Wd7gQKjABIlTGg==$0
PARSE_ID
SCOTT BIN$3IGbb/V2Wd7gQKjABIlTGg==$0 BIN$3IGbb/V4Wd7gQKjABIlTGg==$0
PARSE_ID 3
SCOTT BIN$3IGbb/V1Wd7gQKjABIlTGg==$0 BIN$3IGbb/V4Wd7gQKjABIlTGg==$0
EXECUTION_ID
OWNER CONSTRAINT_NAME TABLE_NAME
------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------
COLUMN_NAME POSITION
------------------------------ ----------
SCOTT BIN$3IGbb/V2Wd7gQKjABIlTGg==$0 BIN$3IGbb/V4Wd7gQKjABIlTGg==$0
EXECUTION_ID 4
SCOTT BIN$3IGbb/V5Wd7gQKjABIlTGg==$0 BIN$3IGbb/WDWd7gQKjABIlTGg==$0
TRACE_FILE_ID
SCOTT BIN$3IGbb/WBWd7gQKjABIlTGg==$0 BIN$3IGbb/WDWd7gQKjABIlTGg==$0
TRACE_FILE_ID 1
SCOTT BIN$3IGbb/V6Wd7gQKjABIlTGg==$0 BIN$3IGbb/WDWd7gQKjABIlTGg==$0
SQL_ID
SCOTT BIN$3IGbb/WBWd7gQKjABIlTGg==$0 BIN$3IGbb/WDWd7gQKjABIlTGg==$0
SQL_ID 2
SCOTT BIN$3IGbb/V7Wd7gQKjABIlTGg==$0 BIN$3IGbb/WDWd7gQKjABIlTGg==$0
PARSE_ID
SCOTT BIN$3IGbb/WBWd7gQKjABIlTGg==$0 BIN$3IGbb/WDWd7gQKjABIlTGg==$0
PARSE_ID 3
SCOTT BIN$3IGbb/V8Wd7gQKjABIlTGg==$0 BIN$3IGbb/WDWd7gQKjABIlTGg==$0
EXECUTION_ID
SCOTT BIN$3IGbb/WBWd7gQKjABIlTGg==$0 BIN$3IGbb/WDWd7gQKjABIlTGg==$0
EXECUTION_ID 4
SCOTT BIN$3IGbb/V9Wd7gQKjABIlTGg==$0 BIN$3IGbb/WDWd7gQKjABIlTGg==$0
FETCH_ID
SCOTT BIN$3IGbb/WBWd7gQKjABIlTGg==$0 BIN$3IGbb/WDWd7gQKjABIlTGg==$0
FETCH_ID 5
SCOTT BIN$3IGbb/V+Wd7gQKjABIlTGg==$0 BIN$3IGbb/WDWd7gQKjABIlTGg==$0
FETCH_COUNT
SCOTT BIN$3IGbb/V/Wd7gQKjABIlTGg==$0 BIN$3IGbb/WDWd7gQKjABIlTGg==$0
CPU
SCOTT BIN$3IGbb/WAWd7gQKjABIlTGg==$0 BIN$3IGbb/WDWd7gQKjABIlTGg==$0
ELAPSED
SCOTT BIN$3IGbb/WEWd7gQKjABIlTGg==$0 BIN$3IGbb/WJWd7gQKjABIlTGg==$0
TRACE_FILE_ID
OWNER CONSTRAINT_NAME TABLE_NAME
------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------
COLUMN_NAME POSITION
------------------------------ ----------
SCOTT BIN$3IGbb/WGWd7gQKjABIlTGg==$0 BIN$3IGbb/WJWd7gQKjABIlTGg==$0
TRACE_FILE_ID 1
SCOTT BIN$3IGbb/WFWd7gQKjABIlTGg==$0 BIN$3IGbb/WJWd7gQKjABIlTGg==$0
SQL_ID
SCOTT BIN$3IGbb/WGWd7gQKjABIlTGg==$0 BIN$3IGbb/WJWd7gQKjABIlTGg==$0
SQL_ID 2
SCOTT BIN$3IGbb/WKWd7gQKjABIlTGg==$0 BIN$3IGbb/WPWd7gQKjABIlTGg==$0
TRACE_FILE_ID
SCOTT BIN$3IGbb/WNWd7gQKjABIlTGg==$0 BIN$3IGbb/WPWd7gQKjABIlTGg==$0
TRACE_FILE_ID 1
SCOTT BIN$3IGbb/WLWd7gQKjABIlTGg==$0 BIN$3IGbb/WPWd7gQKjABIlTGg==$0
SQL_ID
SCOTT BIN$3IGbb/WNWd7gQKjABIlTGg==$0 BIN$3IGbb/WPWd7gQKjABIlTGg==$0
SQL_ID 2
SCOTT BIN$3IGbb/WMWd7gQKjABIlTGg==$0 BIN$3IGbb/WPWd7gQKjABIlTGg==$0
PIECE_NO
SCOTT BIN$3IGbb/WNWd7gQKjABIlTGg==$0 BIN$3IGbb/WPWd7gQKjABIlTGg==$0
PIECE_NO 3
SCOTT BIN$3IGbb/WQWd7gQKjABIlTGg==$0 BIN$3IGbb/WZWd7gQKjABIlTGg==$0
TRACE_FILE_ID
SCOTT BIN$3IGbb/WXWd7gQKjABIlTGg==$0 BIN$3IGbb/WZWd7gQKjABIlTGg==$0
TRACE_FILE_ID 1
SCOTT BIN$3IGbb/WRWd7gQKjABIlTGg==$0 BIN$3IGbb/WZWd7gQKjABIlTGg==$0
SQL_ID
SCOTT BIN$3IGbb/WXWd7gQKjABIlTGg==$0 BIN$3IGbb/WZWd7gQKjABIlTGg==$0
SQL_ID 2
SCOTT BIN$3IGbb/WSWd7gQKjABIlTGg==$0 BIN$3IGbb/WZWd7gQKjABIlTGg==$0
PARSE_ID
SCOTT BIN$3IGbb/WXWd7gQKjABIlTGg==$0 BIN$3IGbb/WZWd7gQKjABIlTGg==$0
PARSE_ID 3
OWNER CONSTRAINT_NAME TABLE_NAME
------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------
COLUMN_NAME POSITION
------------------------------ ----------
SCOTT BIN$3IGbb/WTWd7gQKjABIlTGg==$0 BIN$3IGbb/WZWd7gQKjABIlTGg==$0
EXECUTION_ID
SCOTT BIN$3IGbb/WXWd7gQKjABIlTGg==$0 BIN$3IGbb/WZWd7gQKjABIlTGg==$0
EXECUTION_ID 4
SCOTT BIN$3IGbb/WUWd7gQKjABIlTGg==$0 BIN$3IGbb/WZWd7gQKjABIlTGg==$0
WAIT_ID
SCOTT BIN$3IGbb/WXWd7gQKjABIlTGg==$0 BIN$3IGbb/WZWd7gQKjABIlTGg==$0
WAIT_ID 5
SCOTT BIN$3IGbb/WVWd7gQKjABIlTGg==$0 BIN$3IGbb/WZWd7gQKjABIlTGg==$0
WAIT_COUNT
SCOTT BIN$3IGbb/WWWd7gQKjABIlTGg==$0 BIN$3IGbb/WZWd7gQKjABIlTGg==$0
EVENT_ID
SCOTT BIN$3IGbb/UqWd7gQKjABIlTGg==$0 BIN$3IGbb/UxWd7gQKjABIlTGg==$0
TRACE_FILE_ID
SCOTT BIN$3IGbb/UtWd7gQKjABIlTGg==$0 BIN$3IGbb/UxWd7gQKjABIlTGg==$0
TRACE_FILE_ID 1
SCOTT BIN$3IGbb/UuWd7gQKjABIlTGg==$0 BIN$3IGbb/UxWd7gQKjABIlTGg==$0
TRACE_FILE_ID 2
SCOTT BIN$3IGbb/UrWd7gQKjABIlTGg==$0 BIN$3IGbb/UxWd7gQKjABIlTGg==$0
INST_ID
SCOTT BIN$3IGbb/UuWd7gQKjABIlTGg==$0 BIN$3IGbb/UxWd7gQKjABIlTGg==$0
INST_ID 1
SCOTT BIN$3IGbb/UsWd7gQKjABIlTGg==$0 BIN$3IGbb/UxWd7gQKjABIlTGg==$0
TRACE_FILE_NAME
SCOTT BIN$3IGbb/UkWd7gQKjABIlTGg==$0 BIN$3IGbb/UpWd7gQKjABIlTGg==$0
EVENT_ID
SCOTT BIN$3IGbb/UlWd7gQKjABIlTGg==$0 BIN$3IGbb/UpWd7gQKjABIlTGg==$0
EVENT_ID 1
SCOTT BIN$3IGbb/UmWd7gQKjABIlTGg==$0 BIN$3IGbb/UpWd7gQKjABIlTGg==$0
NAM 1
OWNER CONSTRAINT_NAME TABLE_NAME
------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------
COLUMN_NAME POSITION
------------------------------ ----------
SCOTT BIN$3IGbb/UfWd7gQKjABIlTGg==$0 BIN$3IGbb/UjWd7gQKjABIlTGg==$0
OPERATION_ID
SCOTT BIN$3IGbb/UhWd7gQKjABIlTGg==$0 BIN$3IGbb/UjWd7gQKjABIlTGg==$0
OPERATION_ID 1
SCOTT BIN$3IGbb/UgWd7gQKjABIlTGg==$0 BIN$3IGbb/UjWd7gQKjABIlTGg==$0
TRACE_FILE_ID
SCOTT BIN$3IGbb/UhWd7gQKjABIlTGg==$0 BIN$3IGbb/UjWd7gQKjABIlTGg==$0
TRACE_FILE_ID 2
SCOTT SYS_C0012898 MYBOOK
BOOKID
SCOTT BOOK1_PK MYBOOK
BOOKID 1
SCOTT SYS_C0012902 MYBOOK5
BOOKID
SCOTT SYS_C0012903 MYBOOK5
BOOKID 1
SCOTT SYS_C0012904 MYBOOK5_1
BOOKID
SCOTT SYS_C0012905 MYBOOK5_1
BOOKID 1
SCOTT SYS_C0012928 BOOKS_01
B_ID
SCOTT UNIQUE_KEY_02 BOOKS_01
B_ID 1
SCOTT SYS_C0012929 BOOKS_01
B_NAME
SCOTT PR B
B 1
SCOTT PRIMARY_K EMP
EMPNO 1
OWNER CONSTRAINT_NAME TABLE_NAME
------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------
COLUMN_NAME POSITION
------------------------------ ----------
SCOTT FORE A
A 1
SCOTT UNI A
B 1
SCOTT UNIQ C
A 1
SCOTT PRI_KEY SEQUENCE01
ID 1
SCOTT SYS_C0013308 EMPLOYEE
SYS_NC0000400005$ 1
已选择140行。
SCOTT@orcl#col TABLE_NAME for a20
SCOTT@orcl#col OWNER for a10
SCOTT@orcl#col CONSTRAINT_NAME for a20
SCOTT@orcl#r
1* select * from user_cons_columns
OWNER CONSTRAINT_NAME TABLE_NAME COLUMN_NAME POSITION
---------- -------------------- -------------------- ------------------------------ ----------
SCOTT PK_DEPT DEPT DEPTNO 1
SCOTT BIN$3IGbb/U3Wd7gQKjA BIN$3IGbb/U5Wd7gQKjA SCHEMA_ID 1
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/U2Wd7gQKjA BIN$3IGbb/U5Wd7gQKjA VERSION
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/U6Wd7gQKjA BIN$3IGbb/U+Wd7gQKjA TRACE_FILE_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/U8Wd7gQKjA BIN$3IGbb/U+Wd7gQKjA TRACE_FILE_ID 1
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/U8Wd7gQKjA BIN$3IGbb/U+Wd7gQKjA SQL_ID 2
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/U8Wd7gQKjA BIN$3IGbb/U+Wd7gQKjA PARSE_ID 3
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/U8Wd7gQKjA BIN$3IGbb/U+Wd7gQKjA EXECUTION_ID 4
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/U7Wd7gQKjA BIN$3IGbb/U+Wd7gQKjA ERROR_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/U8Wd7gQKjA BIN$3IGbb/U+Wd7gQKjA ERROR_ID 5
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/U/Wd7gQKjA BIN$3IGbb/VJWd7gQKjA TRACE_FILE_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VHWd7gQKjA BIN$3IGbb/VJWd7gQKjA TRACE_FILE_ID 1
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VAWd7gQKjA BIN$3IGbb/VJWd7gQKjA SQL_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VHWd7gQKjA BIN$3IGbb/VJWd7gQKjA SQL_ID 2
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VBWd7gQKjA BIN$3IGbb/VJWd7gQKjA PARSE_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VHWd7gQKjA BIN$3IGbb/VJWd7gQKjA PARSE_ID 3
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VCWd7gQKjA BIN$3IGbb/VJWd7gQKjA WAIT_ID
OWNER CONSTRAINT_NAME TABLE_NAME COLUMN_NAME POSITION
---------- -------------------- -------------------- ------------------------------ ----------
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VHWd7gQKjA BIN$3IGbb/VJWd7gQKjA WAIT_ID 4
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VDWd7gQKjA BIN$3IGbb/VJWd7gQKjA NAM
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VEWd7gQKjA BIN$3IGbb/VJWd7gQKjA WAIT_COUNT
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VFWd7gQKjA BIN$3IGbb/VJWd7gQKjA SUM_ELAPSED
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VGWd7gQKjA BIN$3IGbb/VJWd7gQKjA SUMSQUARES_ELAPSED
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VKWd7gQKjA BIN$3IGbb/VRWd7gQKjA TRACE_FILE_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VPWd7gQKjA BIN$3IGbb/VRWd7gQKjA TRACE_FILE_ID 1
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VLWd7gQKjA BIN$3IGbb/VRWd7gQKjA SQL_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VPWd7gQKjA BIN$3IGbb/VRWd7gQKjA SQL_ID 2
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VMWd7gQKjA BIN$3IGbb/VRWd7gQKjA PARSE_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VPWd7gQKjA BIN$3IGbb/VRWd7gQKjA PARSE_ID 3
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VNWd7gQKjA BIN$3IGbb/VRWd7gQKjA ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VPWd7gQKjA BIN$3IGbb/VRWd7gQKjA ID 4
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VOWd7gQKjA BIN$3IGbb/VRWd7gQKjA OPERATION_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VSWd7gQKjA BIN$3IGbb/VYWd7gQKjA TRACE_FILE_ID
BIlTGg==$0 BIlTGg==$0
OWNER CONSTRAINT_NAME TABLE_NAME COLUMN_NAME POSITION
---------- -------------------- -------------------- ------------------------------ ----------
SCOTT BIN$3IGbb/VWWd7gQKjA BIN$3IGbb/VYWd7gQKjA TRACE_FILE_ID 1
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VTWd7gQKjA BIN$3IGbb/VYWd7gQKjA SQL_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VWWd7gQKjA BIN$3IGbb/VYWd7gQKjA SQL_ID 2
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VUWd7gQKjA BIN$3IGbb/VYWd7gQKjA PARSE_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VWWd7gQKjA BIN$3IGbb/VYWd7gQKjA PARSE_ID 3
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VVWd7gQKjA BIN$3IGbb/VYWd7gQKjA CURSOR_NO
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VZWd7gQKjA BIN$3IGbb/VfWd7gQKjA TRACE_FILE_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VdWd7gQKjA BIN$3IGbb/VfWd7gQKjA TRACE_FILE_ID 1
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VaWd7gQKjA BIN$3IGbb/VfWd7gQKjA SQL_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VdWd7gQKjA BIN$3IGbb/VfWd7gQKjA SQL_ID 2
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VbWd7gQKjA BIN$3IGbb/VfWd7gQKjA PARSE_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VdWd7gQKjA BIN$3IGbb/VfWd7gQKjA PARSE_ID 3
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VcWd7gQKjA BIN$3IGbb/VfWd7gQKjA ERROR_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VdWd7gQKjA BIN$3IGbb/VfWd7gQKjA ERROR_ID 4
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VgWd7gQKjA BIN$3IGbb/VpWd7gQKjA SESSION_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VnWd7gQKjA BIN$3IGbb/VpWd7gQKjA SESSION_ID 5
BIlTGg==$0 BIlTGg==$0
OWNER CONSTRAINT_NAME TABLE_NAME COLUMN_NAME POSITION
---------- -------------------- -------------------- ------------------------------ ----------
SCOTT BIN$3IGbb/VhWd7gQKjA BIN$3IGbb/VpWd7gQKjA SID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/ViWd7gQKjA BIN$3IGbb/VpWd7gQKjA SERIAL
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VjWd7gQKjA BIN$3IGbb/VpWd7gQKjA TRACE_FILE_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VnWd7gQKjA BIN$3IGbb/VpWd7gQKjA TRACE_FILE_ID 1
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VkWd7gQKjA BIN$3IGbb/VpWd7gQKjA SQL_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VnWd7gQKjA BIN$3IGbb/VpWd7gQKjA SQL_ID 2
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VlWd7gQKjA BIN$3IGbb/VpWd7gQKjA PARSE_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VnWd7gQKjA BIN$3IGbb/VpWd7gQKjA PARSE_ID 3
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VmWd7gQKjA BIN$3IGbb/VpWd7gQKjA EXECUTION_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VnWd7gQKjA BIN$3IGbb/VpWd7gQKjA EXECUTION_ID 4
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VqWd7gQKjA BIN$3IGbb/VxWd7gQKjA TRACE_FILE_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VvWd7gQKjA BIN$3IGbb/VxWd7gQKjA TRACE_FILE_ID 1
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VrWd7gQKjA BIN$3IGbb/VxWd7gQKjA SQL_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VvWd7gQKjA BIN$3IGbb/VxWd7gQKjA SQL_ID 2
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VsWd7gQKjA BIN$3IGbb/VxWd7gQKjA PARSE_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VvWd7gQKjA BIN$3IGbb/VxWd7gQKjA PARSE_ID 3
OWNER CONSTRAINT_NAME TABLE_NAME COLUMN_NAME POSITION
---------- -------------------- -------------------- ------------------------------ ----------
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VtWd7gQKjA BIN$3IGbb/VxWd7gQKjA EXECUTION_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VvWd7gQKjA BIN$3IGbb/VxWd7gQKjA EXECUTION_ID 4
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VuWd7gQKjA BIN$3IGbb/VxWd7gQKjA BIND_VAR_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VvWd7gQKjA BIN$3IGbb/VxWd7gQKjA BIND_VAR_ID 5
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VyWd7gQKjA BIN$3IGbb/V4Wd7gQKjA TRACE_FILE_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/V2Wd7gQKjA BIN$3IGbb/V4Wd7gQKjA TRACE_FILE_ID 1
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/VzWd7gQKjA BIN$3IGbb/V4Wd7gQKjA SQL_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/V2Wd7gQKjA BIN$3IGbb/V4Wd7gQKjA SQL_ID 2
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/V0Wd7gQKjA BIN$3IGbb/V4Wd7gQKjA PARSE_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/V2Wd7gQKjA BIN$3IGbb/V4Wd7gQKjA PARSE_ID 3
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/V1Wd7gQKjA BIN$3IGbb/V4Wd7gQKjA EXECUTION_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/V2Wd7gQKjA BIN$3IGbb/V4Wd7gQKjA EXECUTION_ID 4
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/V5Wd7gQKjA BIN$3IGbb/WDWd7gQKjA TRACE_FILE_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/WBWd7gQKjA BIN$3IGbb/WDWd7gQKjA TRACE_FILE_ID 1
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/V6Wd7gQKjA BIN$3IGbb/WDWd7gQKjA SQL_ID
BIlTGg==$0 BIlTGg==$0
OWNER CONSTRAINT_NAME TABLE_NAME COLUMN_NAME POSITION
---------- -------------------- -------------------- ------------------------------ ----------
SCOTT BIN$3IGbb/WBWd7gQKjA BIN$3IGbb/WDWd7gQKjA SQL_ID 2
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/V7Wd7gQKjA BIN$3IGbb/WDWd7gQKjA PARSE_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/WBWd7gQKjA BIN$3IGbb/WDWd7gQKjA PARSE_ID 3
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/V8Wd7gQKjA BIN$3IGbb/WDWd7gQKjA EXECUTION_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/WBWd7gQKjA BIN$3IGbb/WDWd7gQKjA EXECUTION_ID 4
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/V9Wd7gQKjA BIN$3IGbb/WDWd7gQKjA FETCH_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/WBWd7gQKjA BIN$3IGbb/WDWd7gQKjA FETCH_ID 5
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/V+Wd7gQKjA BIN$3IGbb/WDWd7gQKjA FETCH_COUNT
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/V/Wd7gQKjA BIN$3IGbb/WDWd7gQKjA CPU
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/WAWd7gQKjA BIN$3IGbb/WDWd7gQKjA ELAPSED
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/WEWd7gQKjA BIN$3IGbb/WJWd7gQKjA TRACE_FILE_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/WGWd7gQKjA BIN$3IGbb/WJWd7gQKjA TRACE_FILE_ID 1
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/WFWd7gQKjA BIN$3IGbb/WJWd7gQKjA SQL_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/WGWd7gQKjA BIN$3IGbb/WJWd7gQKjA SQL_ID 2
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/WKWd7gQKjA BIN$3IGbb/WPWd7gQKjA TRACE_FILE_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/WNWd7gQKjA BIN$3IGbb/WPWd7gQKjA TRACE_FILE_ID 1
BIlTGg==$0 BIlTGg==$0
OWNER CONSTRAINT_NAME TABLE_NAME COLUMN_NAME POSITION
---------- -------------------- -------------------- ------------------------------ ----------
SCOTT BIN$3IGbb/WLWd7gQKjA BIN$3IGbb/WPWd7gQKjA SQL_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/WNWd7gQKjA BIN$3IGbb/WPWd7gQKjA SQL_ID 2
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/WMWd7gQKjA BIN$3IGbb/WPWd7gQKjA PIECE_NO
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/WNWd7gQKjA BIN$3IGbb/WPWd7gQKjA PIECE_NO 3
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/WQWd7gQKjA BIN$3IGbb/WZWd7gQKjA TRACE_FILE_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/WXWd7gQKjA BIN$3IGbb/WZWd7gQKjA TRACE_FILE_ID 1
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/WRWd7gQKjA BIN$3IGbb/WZWd7gQKjA SQL_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/WXWd7gQKjA BIN$3IGbb/WZWd7gQKjA SQL_ID 2
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/WSWd7gQKjA BIN$3IGbb/WZWd7gQKjA PARSE_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/WXWd7gQKjA BIN$3IGbb/WZWd7gQKjA PARSE_ID 3
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/WTWd7gQKjA BIN$3IGbb/WZWd7gQKjA EXECUTION_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/WXWd7gQKjA BIN$3IGbb/WZWd7gQKjA EXECUTION_ID 4
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/WUWd7gQKjA BIN$3IGbb/WZWd7gQKjA WAIT_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/WXWd7gQKjA BIN$3IGbb/WZWd7gQKjA WAIT_ID 5
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/WVWd7gQKjA BIN$3IGbb/WZWd7gQKjA WAIT_COUNT
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/WWWd7gQKjA BIN$3IGbb/WZWd7gQKjA EVENT_ID
OWNER CONSTRAINT_NAME TABLE_NAME COLUMN_NAME POSITION
---------- -------------------- -------------------- ------------------------------ ----------
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/UqWd7gQKjA BIN$3IGbb/UxWd7gQKjA TRACE_FILE_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/UtWd7gQKjA BIN$3IGbb/UxWd7gQKjA TRACE_FILE_ID 1
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/UuWd7gQKjA BIN$3IGbb/UxWd7gQKjA TRACE_FILE_ID 2
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/UrWd7gQKjA BIN$3IGbb/UxWd7gQKjA INST_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/UuWd7gQKjA BIN$3IGbb/UxWd7gQKjA INST_ID 1
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/UsWd7gQKjA BIN$3IGbb/UxWd7gQKjA TRACE_FILE_NAME
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/UkWd7gQKjA BIN$3IGbb/UpWd7gQKjA EVENT_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/UlWd7gQKjA BIN$3IGbb/UpWd7gQKjA EVENT_ID 1
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/UmWd7gQKjA BIN$3IGbb/UpWd7gQKjA NAM 1
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/UfWd7gQKjA BIN$3IGbb/UjWd7gQKjA OPERATION_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/UhWd7gQKjA BIN$3IGbb/UjWd7gQKjA OPERATION_ID 1
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/UgWd7gQKjA BIN$3IGbb/UjWd7gQKjA TRACE_FILE_ID
BIlTGg==$0 BIlTGg==$0
SCOTT BIN$3IGbb/UhWd7gQKjA BIN$3IGbb/UjWd7gQKjA TRACE_FILE_ID 2
BIlTGg==$0 BIlTGg==$0
SCOTT SYS_C0012898 MYBOOK BOOKID
SCOTT BOOK1_PK MYBOOK BOOKID 1
SCOTT SYS_C0012902 MYBOOK5 BOOKID
SCOTT SYS_C0012903 MYBOOK5 BOOKID 1
SCOTT SYS_C0012904 MYBOOK5_1 BOOKID
SCOTT SYS_C0012905 MYBOOK5_1 BOOKID 1
OWNER CONSTRAINT_NAME TABLE_NAME COLUMN_NAME POSITION
---------- -------------------- -------------------- ------------------------------ ----------
SCOTT SYS_C0012928 BOOKS_01 B_ID
SCOTT UNIQUE_KEY_02 BOOKS_01 B_ID 1
SCOTT SYS_C0012929 BOOKS_01 B_NAME
SCOTT PR B B 1
SCOTT PRIMARY_K EMP EMPNO 1
SCOTT FORE A A 1
SCOTT UNI A B 1
SCOTT UNIQ C A 1
SCOTT PRI_KEY SEQUENCE01 ID 1
SCOTT SYS_C0013308 EMPLOYEE SYS_NC0000400005$ 1
已选择140行。
SCOTT@orcl#l
1* select * from user_cons_columns
SCOTT@orcl#append where table_name='EMP';
1* select * from user_cons_columns where table_name='EMP'
SCOTT@orcl#R
1* select * from user_cons_columns where table_name='EMP'
OWNER CONSTRAINT_NAME TABLE_NAME COLUMN_NAME POSITION
---------- -------------------- -------------------- ------------------------------ ----------
SCOTT PRIMARY_K EMP EMPNO 1
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#begin
2 ;
3 /
;
*
第 2 行出现错误:
ORA-06550: 第 2 行, 第 1 列:
PLS-00103: 出现符号 ";"在需要下列之一时:
( begin case
declare exit for goto if loop mod null pragma raise return
select update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
continue close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge pipe purge
SCOTT@orcl#select * from empno;
select * from empno
*
第 1 行出现错误:
ORA-00942: 表或视图不存在
SCOTT@orcl#select * from emp;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- -------------------- ------------------ ---------- -------------- ---------- ---------- ----------
7369 SMITH CLERK 7902 17-12月-80 3020 20
7499 ALLEN SALESMAN 7698 20-2月 -81 4820 300 30
7521 WARD SALESMAN 7698 22-2月 -81 4470 500 30
7566 JONES MANAGER 7839 02-4月 -81 4195 20
7654 MARTIN SALESMAN 7698 28-9月 -81 4470 1400 30
7698 BLAKE MANAGER 7839 01-5月 -81 4070 30
7782 CLARK hello 7839 09-6月 -81 3670 10
7788 SCOTT h 7566 19-4月 -87 422 20
7839 KING PRESIDENT 17-11月-81 5220 10
7844 TURNER hello 7698 08-9月 -81 4720 0 30
7876 ADAMS hello 7788 23-5月 -87 3320 20
7000 MILLER hello 2000 23-1月 -82 3220 10
2000 rhys DBA 2000 01-5月 -13 20000 200 30
已选择13行。
SCOTT@orcl#begin
2 insert into emp(empno,ename) values(2000,'rhys2');
3 exception
4 when dup_val_on_index then
5 dbms_output.put_line('the error on the primary key index');
6 end;
7 /
the error on the primary key index
PL/SQL 过程已成功完成。
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#declare
2 select * from emp where empno=3000;
3 exception
4 when no_data_found then
5 dbms_output.put_line('no data found');
6 end;
7 /
select * from emp where empno=3000;
*
第 2 行出现错误:
ORA-06550: 第 2 行, 第 1 列:
PLS-00103: 出现符号 "SELECT"在需要下列之一时:
begin
function pragma procedure subtype type <an identifier>
<a double-quoted delimited-identifier> current cursor delete
exists prior
符号 "begin" 被替换为 "SELECT" 后继续。
SCOTT@orcl#declare
2 v_emp emp.emp%rowtype;
3 begin
4 select * into v_emp where empno=3000;
5 end;
6 /
select * into v_emp where empno=3000;
*
第 4 行出现错误:
ORA-06550: 第 4 行, 第 21 列:
PL/SQL: ORA-00923: 未找到要求的 FROM 关键字
ORA-06550: 第 4 行, 第 1 列:
PL/SQL: SQL Statement ignored
SCOTT@orcl#declare
2 v_emp emp%rowtype;
3 begin
4 select * into v_emp from emp where empno=3000;
5 dbms_output.put_line(v_emp.ename);
6 exception
7 when no_data_found then
8 dbms_output.put_line('no data found');
9 end;
10 /
no data found
PL/SQL 过程已成功完成。
SCOTT@orcl#declare
2 v_emp emp%type;
3 begin
4 select * into v_emp from emp where deptno=10;
5 dbms_output.put_line(v_emp.ename);
6 exception
7 when too_many_rows then
8 dbms_output.put_line('too many rows');
9 end;
10 /
v_emp emp%type;
*
第 2 行出现错误:
ORA-06550: 第 2 行, 第 7 列:
PLS-00206: %TYPE 必须用于变量, 列, 字段或属性, 而不是 'EMP'
ORA-06550: 第 2 行, 第 7 列:
PL/SQL: Item ignored
ORA-06550: 第 4 行, 第 15 列:
PLS-00320: 此表达式的类型声明不完整或格式不正确
ORA-06550: 第 4 行, 第 21 列:
PL/SQL: ORA-00904: : 标识符无效
ORA-06550: 第 4 行, 第 1 列:
PL/SQL: SQL Statement ignored
ORA-06550: 第 5 行, 第 22 列:
PLS-00320: 此表达式的类型声明不完整或格式不正确
ORA-06550: 第 5 行, 第 1 列:
PL/SQL: Statement ignored
SCOTT@orcl#l
1 declare
2 v_emp emp%type;
3 begin
4 select * into v_emp from emp where deptno=10;
5 dbms_output.put_line(v_emp.ename);
6 exception
7 when too_many_rows then
8 dbms_output.put_line('too many rows');
9* end;
SCOTT@orcl#2
2* v_emp emp%type;
SCOTT@orcl#c /emp%type/emp%rowtype;
2* v_emp emp%rowtype;
SCOTT@orcl#r
1 declare
2 v_emp emp%rowtype;
3 begin
4 select * into v_emp from emp where deptno=10;
5 dbms_output.put_line(v_emp.ename);
6 exception
7 when too_many_rows then
8 dbms_output.put_line('too many rows');
9* end;
too many rows
PL/SQL 过程已成功完成。
SCOTT@orcl#
SCOTT@orcl#declare
2 e_no_employee exception;
3 pragma execption_init(e_no_employee,-2291);
4 begin
5 update emp set deptno=10 where empno=1111;
6 if sql%notfound then
7 raise e_no_employee;
8 end if;
9 exception
10 when e_no_employee then
11 dbms_output.put_line('no');
12 end;
13 /
pragma execption_init(e_no_employee,-2291);
*
第 3 行出现错误:
ORA-06550: 第 3 行, 第 8 列:
PLS-00127: 编译指示 EXECPTION_INIT 是不受支持的编译指示
SCOTT@orcl#3
3* pragma execption_init(e_no_employee,-2291);
SCOTT@orcl#c /pragma exception_init/pragma exception_init
SP2-0023: 未找到字符串
SCOTT@orcl#r
1 declare
2 e_no_employee exception;
3 pragma execption_init(e_no_employee,-2291);
4 begin
5 update emp set deptno=10 where empno=1111;
6 if sql%notfound then
7 raise e_no_employee;
8 end if;
9 exception
10 when e_no_employee then
11 dbms_output.put_line('no');
12* end;
pragma execption_init(e_no_employee,-2291);
*
第 3 行出现错误:
ORA-06550: 第 3 行, 第 8 列:
PLS-00127: 编译指示 EXECPTION_INIT 是不受支持的编译指示
SCOTT@orcl#3
3* pragma execption_init(e_no_employee,-2291);
SCOTT@orcl#c /execption/exception
3* pragma exception_init(e_no_employee,-2291);
SCOTT@orcl#r
1 declare
2 e_no_employee exception;
3 pragma exception_init(e_no_employee,-2291);
4 begin
5 update emp set deptno=10 where empno=1111;
6 if sql%notfound then
7 raise e_no_employee;
8 end if;
9 exception
10 when e_no_employee then
11 dbms_output.put_line('no');
12* end;
no
PL/SQL 过程已成功完成。
SCOTT@orcl#begin
2 exception exception_emp;
3 pragma exception_init(exception_emp,-2001);
4 begin
5 update emp set deptno=10 where empno=1111;
6 if sql%notfound then
7 raise exception_emp;
8 end if;
9 exception
10 when exception_emp then
11 dbms_output.put_line('the error is found');
12 end;
13 /
exception exception_emp;
*
第 2 行出现错误:
ORA-06550: 第 2 行, 第 1 列:
PLS-00103: 出现符号 "EXCEPTION"在需要下列之一时:
( begin
case declare exit for goto if loop mod null pragma raise
return select update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
continue close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge pipe purge
符号 "EXCEPTION" 被忽略。
ORA-06550: 第 12 行, 第 4 列:
PLS-00103: 出现符号 "end-of-file"在需要下列之一时:
(
begin case declare end exception exit for goto if loop mod
null pragma raise return select update while with
<an identifier> <a double-quoted delimited-identifie
SCOTT@orcl#2
2* exception exception_emp;
SCOTT@orcl#c exception_emp exception;
2* eption_eption exception_emp;
SCOTT@orcl#r
1 begin
2 eption_eption exception_emp;
3 pragma exception_init(exception_emp,-2001);
4 begin
5 update emp set deptno=10 where empno=1111;
6 if sql%notfound then
7 raise exception_emp;
8 end if;
9 exception
10 when exception_emp then
11 dbms_output.put_line('the error is found');
12* end;
eption_eption exception_emp;
*
第 2 行出现错误:
ORA-06550: 第 2 行, 第 15 列:
PLS-00103: 出现符号 "EXCEPTION_EMP"在需要下列之一时:
:= .
( @ % ;
符号 ":=" 被替换为 "EXCEPTION_EMP" 后继续。
ORA-06550: 第 12 行, 第 4 列:
PLS-00103: 出现符号 "end-of-file"在需要下列之一时:
(
begin case declare end exception exit for goto if loop mod
null pragma raise return select update while with
<an identifier> <a double-quoted delimited-identifie
SCOTT@orcl#2
2* eption_eption exception_emp;
SCOTT@orcl#c /eption_eption/exception_emp
2* exception_emp exception_emp;
SCOTT@orcl#c /exception_emp exception_emp/exception_emp exception;;
2* exception_emp exception;;
SCOTT@orcl#c /;/
2* exception_emp exception;
SCOTT@orcl#r
1 begin
2 exception_emp exception;
3 pragma exception_init(exception_emp,-2001);
4 begin
5 update emp set deptno=10 where empno=1111;
6 if sql%notfound then
7 raise exception_emp;
8 end if;
9 exception
10 when exception_emp then
11 dbms_output.put_line('the error is found');
12* end;
exception_emp exception;
*
第 2 行出现错误:
ORA-06550: 第 2 行, 第 15 列:
PLS-00103: 出现符号 "EXCEPTION"在需要下列之一时:
:= . ( @
% ;
符号 "EXCEPTION" 被忽略。
ORA-06550: 第 12 行, 第 4 列:
PLS-00103: 出现符号 "end-of-file"在需要下列之一时:
(
begin case declare end exception exit for goto if loop mod
null pragma raise return select update while with
<an identifier> <a double-quoted delimited-identifie
SCOTT@orcl#1
1* begin
SCOTT@orcl#c /begin/declare
1* declare
SCOTT@orcl#r
1 declare
2 exception_emp exception;
3 pragma exception_init(exception_emp,-2001);
4 begin
5 update emp set deptno=10 where empno=1111;
6 if sql%notfound then
7 raise exception_emp;
8 end if;
9 exception
10 when exception_emp then
11 dbms_output.put_line('the error is found');
12* end;
the error is found
PL/SQL 过程已成功完成。
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#declare
2 err_exception exception;
3 pragma exception_init(err_exception,-2999);
4 begin
5 update emp set sal=2000 where empno=22222;
6 if sql%notfound then
7 raise err_exception;
8 end if;
9 exception
10 when err_exception then
11 dbms_output.put_lien('the error is found');
12 end;
13 /
dbms_output.put_lien('the error is found');
*
第 11 行出现错误:
ORA-06550: 第 11 行, 第 13 列:
PLS-00302: 必须声明 'PUT_LIEN' 组件
ORA-06550: 第 11 行, 第 1 列:
PL/SQL: Statement ignored
SCOTT@orcl#11
11* dbms_output.put_lien('the error is found');
SCOTT@orcl#c /put_lien/put_line
11* dbms_output.put_line('the error is found');
SCOTT@orcl#r
1 declare
2 err_exception exception;
3 pragma exception_init(err_exception,-2999);
4 begin
5 update emp set sal=2000 where empno=22222;
6 if sql%notfound then
7 raise err_exception;
8 end if;
9 exception
10 when err_exception then
11 dbms_output.put_line('the error is found');
12* end;
the error is found
PL/SQL 过程已成功完成。
SCOTT@orcl#declare
2 v_ename emp.ename%type;
3 begin
4 select ename into v_ename from emp where sal=3000;
5 dbms_output.put_line(v_ename);
6 exception
7 when no_data_found then
8 dbms_output.put_line('no');
9 when others then
10 dbms_output.put_line(sqlcode);
11 dbms_output.put_line(sqlerrm);
12 end;
13 ./
14 /
./
*
第 13 行出现错误:
ORA-06550: 第 13 行, 第 1 列:
PLS-00103: 出现符号 "."
SCOTT@orcl#13
13* ./
SCOTT@orcl#c /.///
13* /
SCOTT@orcl#del 13
SCOTT@orcl#r
1 declare
2 v_ename emp.ename%type;
3 begin
4 select ename into v_ename from emp where sal=3000;
5 dbms_output.put_line(v_ename);
6 exception
7 when no_data_found then
8 dbms_output.put_line('no');
9 when others then
10 dbms_output.put_line(sqlcode);
11 dbms_output.put_line(sqlerrm);
12* end;
no
PL/SQL 过程已成功完成。
SCOTT@orcl#select empno from emp where sal=3000;
未选定行
SCOTT@orcl#select * from emp;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- -------------------- ------------------ ---------- -------------- ---------- ---------- ----------
7369 SMITH CLERK 7902 17-12月-80 3020 20
7499 ALLEN SALESMAN 7698 20-2月 -81 4820 300 30
7521 WARD SALESMAN 7698 22-2月 -81 4470 500 30
7566 JONES MANAGER 7839 02-4月 -81 4195 20
7654 MARTIN SALESMAN 7698 28-9月 -81 4470 1400 30
7698 BLAKE MANAGER 7839 01-5月 -81 4070 30
7782 CLARK hello 7839 09-6月 -81 3670 10
7788 SCOTT h 7566 19-4月 -87 422 20
7839 KING PRESIDENT 17-11月-81 5220 10
7844 TURNER hello 7698 08-9月 -81 4720 0 30
7876 ADAMS hello 7788 23-5月 -87 3320 20
7000 MILLER hello 2000 23-1月 -82 3220 10
2000 rhys DBA 2000 01-5月 -13 20000 200 30
已选择13行。
SCOTT@orcl#update emp set sal=3000 where empno=2000;
已更新 1 行。
SCOTT@orcl#commit;
提交完成。
SCOTT@orcl#l
1* commit
SCOTT@orcl#declare
2 v_ename emp.ename%type;
3 begin
4 select ename into v_ename from emp where sal=3000;
5 dbms_output.put_line(v_ename);
6 exception
7 when no_data_found then
8 dbms_output.put_line('no');
9 when others then
10 dbms_output.put_line(sqlcode);
11 dbms_output.put_line(sqlerrm);
12 end;
13 /
rhys
PL/SQL 过程已成功完成。
SCOTT@orcl#del 8 9
SCOTT@orcl#l
1 declare
2 v_ename emp.ename%type;
3 begin
4 select ename into v_ename from emp where sal=3000;
5 dbms_output.put_line(v_ename);
6 exception
7 when no_data_found then
8 dbms_output.put_line(sqlcode);
9 dbms_output.put_line(sqlerrm);
10* end;
SCOTT@orcl#r
1 declare
2 v_ename emp.ename%type;
3 begin
4 select ename into v_ename from emp where sal=3000;
5 dbms_output.put_line(v_ename);
6 exception
7 when no_data_found then
8 dbms_output.put_line(sqlcode);
9 dbms_output.put_line(sqlerrm);
10* end;
rhys
PL/SQL 过程已成功完成。
SCOTT@orcl#update emp set sal=3001 where ename='RHYS';
已更新0行。
SCOTT@orcl#SELECT * FROM EMP;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- -------------------- ------------------ ---------- -------------- ---------- ---------- ----------
7369 SMITH CLERK 7902 17-12月-80 3020 20
7499 ALLEN SALESMAN 7698 20-2月 -81 4820 300 30
7521 WARD SALESMAN 7698 22-2月 -81 4470 500 30
7566 JONES MANAGER 7839 02-4月 -81 4195 20
7654 MARTIN SALESMAN 7698 28-9月 -81 4470 1400 30
7698 BLAKE MANAGER 7839 01-5月 -81 4070 30
7782 CLARK hello 7839 09-6月 -81 3670 10
7788 SCOTT h 7566 19-4月 -87 422 20
7839 KING PRESIDENT 17-11月-81 5220 10
7844 TURNER hello 7698 08-9月 -81 4720 0 30
7876 ADAMS hello 7788 23-5月 -87 3320 20
7000 MILLER hello 2000 23-1月 -82 3220 10
2000 rhys DBA 2000 01-5月 -13 3000 200 30
已选择13行。
SCOTT@orcl#UPDATE EMP SET SAL=3001 WHERE EMPNO=2000;
已更新 1 行。
SCOTT@orcl#COMMIT;
提交完成。
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#create or replace proceduce out_time
2 begin
3 dbms_output.put_line(systimestamp);
create or replace proceduce out_time
*
第 1 行出现错误:
ORA-00922: 选项缺失或无效
SCOTT@orcl#create or replace procedure out_time
2 is
3 begin
4 dbms_output.put_line(systimestamp);
5 end;
6 /
过程已创建。
SCOTT@orcl#exec out_time;
12-5月 -13 04.38.48.793354000 下午 +08:00
PL/SQL 过程已成功完成。
SCOTT@orcl#call out_time();
12-5月 -13 04.39.07.961741000 下午 +08:00
调用完成。
SCOTT@orcl#alter session set nls_data_format='yyyy-mm-dd hh24:mi:ss';
alter session set nls_data_format='yyyy-mm-dd hh24:mi:ss'
*
第 1 行出现错误:
ORA-00922: 选项缺失或无效
SCOTT@orcl#alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
会话已更改。
SCOTT@orcl#call out_time();
12-5月 -13 04.40.00.677758000 下午 +08:00
调用完成。
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#exec out_time;
12-5月 -13 04.40.09.086474000 下午 +08:00
PL/SQL 过程已成功完成。
SCOTT@orcl#desc emp;
名称 是否为空? 类型
----------------------------------------------------------------------------------------------------------------- -------- ----------------------------------------------------------------------------
EMPNO NOT NULL NUMBER(38)
ENAME VARCHAR2(10)
JOB VARCHAR2(9)
MGR NUMBER(4)
HIREDATE DATE
SAL NUMBER
COMM NUMBER(7,2)
DEPTNO NUMBER(2)
SCOTT@orcl#create or replace procedure pro_emp
2 (empno emp%type,ename emp%type,sal emp%sql)
3 is
4 begin
5 /
警告: 创建的过程带有编译错误。
SCOTT@orcl#drop procedure pro_emp;
过程已删除。
SCOTT@orcl#create or replace procedure pro_emp
2 (v_empno number,v_ename varchar2,v_sal number)
3 is
4 begin
5 insert into emp (empno,ename,sal) values(v_empno,v_ename,v_sal);
6 end;
7 /
过程已创建。
SCOTT@orcl#exec pro_emp(1000,'xiaohai',20000);
PL/SQL 过程已成功完成。
SCOTT@orcl#select * from emp;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- -------------------- ------------------ ---------- ------------------- ---------- ---------- ----------
7369 SMITH CLERK 7902 1980-12-17 00:00:00 3020 20
7499 ALLEN SALESMAN 7698 1981-02-20 00:00:00 4820 300 30
7521 WARD SALESMAN 7698 1981-02-22 00:00:00 4470 500 30
7566 JONES MANAGER 7839 1981-04-02 00:00:00 4195 20
7654 MARTIN SALESMAN 7698 1981-09-28 00:00:00 4470 1400 30
7698 BLAKE MANAGER 7839 1981-05-01 00:00:00 4070 30
7782 CLARK hello 7839 1981-06-09 00:00:00 3670 10
7788 SCOTT h 7566 1987-04-19 00:00:00 422 20
7839 KING PRESIDENT 1981-11-17 00:00:00 5220 10
7844 TURNER hello 7698 1981-09-08 00:00:00 4720 0 30
7876 ADAMS hello 7788 1987-05-23 00:00:00 3320 20
7000 MILLER hello 2000 1982-01-23 00:00:00 3220 10
2000 rhys DBA 2000 2013-05-01 00:00:00 3001 200 30
1000 xiaohai 20000
已选择14行。
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#
SCOTT@orcl#create or replace procedure query_employee
2 (eno number,name out varchar2,salary out number)
3 is
4 begin
5 select ename,sal,into name,salary from emp where empno=eno;
6 exception
7 when no_data_found then
8 raise_application_error(-20000,'error');
9 end;
10 /
警告: 创建的过程带有编译错误。
SCOTT@orcl#show errors procedure query_employee;
PROCEDURE QUERY_EMPLOYEE 出现错误:
LINE/COL ERROR
-------- -----------------------------------------------------------------
5/1 PL/SQL: SQL Statement ignored
5/18 PL/SQL: ORA-00936: 缺失表达式
SCOTT@orcl#l
1 create or replace procedure query_employee
2 (eno number,name out varchar2,salary out number)
3 is
4 begin
5 select ename,sal,into name,salary from emp where empno=eno;
6 exception
7 when no_data_found then
8 raise_application_error(-20000,'error');
9* end;
SCOTT@orcl#5
5* select ename,sal,into name,salary from emp where empno=eno;
SCOTT@orcl#c /sal,/sal
5* select ename,salinto name,salary from emp where empno=eno;
SCOTT@orcl#c /salinto/sal into
5* select ename,sal into name,salary from emp where empno=eno;
SCOTT@orcl#r
1 create or replace procedure query_employee
2 (eno number,name out varchar2,salary out number)
3 is
4 begin
5 select ename,sal into name,salary from emp where empno=eno;
6 exception
7 when no_data_found then
8 raise_application_error(-20000,'error');
9* end;
过程已创建。
SCOTT@orcl#var name varchar2(10)
SCOTT@orcl#var salary number
SCOTT@orcl#exec query_employee(7788,:name,:salary);
PL/SQL 过程已成功完成。
SCOTT@orcl#print name;
NAME
----------------------------------------------------------------
SCOTT
SCOTT@orcl#print salary;
SALARY
----------
422