oralce 学习

2019独角兽企业重金招聘Python工程师标准>>>

递归查询

select * from pure_resources t
start with t.resources_id='workbench'
connect by PRIOR t.resources_id=t.parent_id

decode

substr

instr

 

show parameter cpu;

 

 

select /*+PARALLEL(T,20)*/T.* from  check_ll.ll_cuifeng_zhuzifei@ngsta  T;

 

SELECT * FROM Nls_Database_Parameters;

SELECT * FROM v$sqlarea  a WHERE a.SQL_ID='dayq182sk41ks';

SELECT * FROM Dba_Hist_Active_Sess_History h WHERE h.sql_id='1cq3qr774cu45';

 

 

 

 

 

转载于:https://my.oschina.net/liyonglee/blog/534211