oracle SQL語句

閃回數據---oracle INSERT INTO workflow.step SELECT * FROM workflow.step AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '1' HOUR) WHERE substr(summary,1,14)='POYT2010111346' 根據條件選擇顯示結果 select case when to_number(a.UNIT_PRICE)<1 then trim(to_char(a.UNIT_PRICE,'999990.000000')) else trim(to_char(a.UNIT_PRICE,'999,999,999,990.000000')) end UNIT_PRICE from tabla_name 查看是否有特殊字符 select dump(order_no) from archive.WF_PO_DATA_NWING_MT where order_no ='PSB-AB0046' 所有父節點 Select * from DEPARTMENT start with id='44E6584CB97545249B0361E340618B30' connect by prior PARENT_ID=id 所有子界面 Select * from DEPARTMENT start with id='44E6584CB97545249B0361E340618B30' connect by prior id=PARENT_ID 查找用戶下面所有表 SELECT 'delete ' || table_name || ';' delscript FROM user_tables WHERE table_name NOT IN ('CCC_T', 'JOB_PERF_ASSESS_MVIEW', 'MAIL_SPECIAL_BASE_T', 'PERSON_NUM_BASE_T', 'ASSESS_BASE_T');