oracle SQL語句

原创于 2010-11-30 10:26:00 发布 · 399 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #sql #table #delete #user #2010

本文介绍了一种使用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');