ITPub博客

http://blog.chinaunix.net/uid-10951-id-1762465.html

http://space.itpub.net/519536/viewspace-692196

SQL> var a number;SQL> exec :a:=10;PL/SQL 过程已成功完成。SQL> select * from dept where deptno=:a;    DEPTNO DNAME          LOC&nbsp...

SQL> create user expdp_user identified by system account unlock;用户已创建。SQL> grant resource,connect to expdp_user;授权成功。SQL> spoofSP2-0042: 未知命令 "spoof" - 其余行忽略。SQL> spool当...

http://atgc.itpub.net/post/22412/217030 create or replace type acc_type as object(acc varchar2(50))/create or replace type acc_table as table of acc_type/create or replace function str2ta...

create or replace procedure proc_tuning(in_order_id int,in_order_date date,out_refcursor out sys_refcursor)isv_sql varchar2(4000);begin  v_sql:='select * from t_orderbill where ';  i...

8,仅导出特定对象类型procedure expdp scott/system@orcl dumpfile=dir_scott:expdp_20121121_scott_procedure.dmp logfile=dir_scott:expdp_20121121_scott_procedure.log schemas=scott include=procedure...

1,查找历史sqlselect * from dba_hist_sqltext where sql_text like '%PORTAL_ORDERBILL%' and sql_text like '%PORTAL_CONSIGNEE%';2,查找历史sql的执行计划是否发生过变化，并在何时发生变化select a.INST...

--查找某个sql的执行计划是否发生了变化select vp.SQL_ID from v$sql_plan vp where vp.OBJECT_OWNER='SCOTT' group by vp.SQL_ID having count(vp.PLAN_HASH_VALUE)>1

SQL> create table t_rowid as select * from dba_objects;表已创建。SQL> commit;提交完成。SQL> insert into t_rowid select * from t_rowid;已创建3193984行。SQL> commit;提交完成。SQL> select count(*) from t...

Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 Connected as scott SQL> create or replace procedure proc_non_sep  2  as   3  begin  4 &nb...

SQL> create or replace procedure proc_non_sep as  2  begin  3  null;  4  end;  5  / Procedure created SQL> create or replace procedure proC_non_Sep as...

Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 Connected as scott SQL> create or replace procedure proc_non_sep  2  as   3  begin  4 &nb...

Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 Connected as SYS SQL> conn scott/system@orclConnected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0&nbsp...

Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 Connected as scott SQL> show userUser is "scott" SQL> create or replace procedure proc_test_special  2  ...

http://blog.163.com/liuyang_yes/blog/static/128133212201182293538433/

SQL> desc t_timestamp;Name Type         Nullable Default Comments ---- ------------ -------- ------- -------- A    TIMESTAMP(7) Y &n...

SQL> select * from t_timestamp; A--------------------------------------------------------------------------------14-11月-12 10.46.24.195000 上午 SQL> show parameter time NAME&nb...

http://blog.sina.com.cn/s/blog_87479ba60100xhz1.html

http://blog.sina.com.cn/s/blog_4b59232801000b9m.html