Oracle小记

1、拼出删除表数据的SQL

      eg： select 'delete' ||' '||table_name from user_tables

1 delete AP_FD_ORG
2 delete AP_FUNC
3 delete AP_MENU
4 delete AP_ORG
5 delete AP_ROLE
6 delete AP_ROLE_FUNC
7 delete AP_USER
8 delete AP_USER_ROLE
9 delete FA_BBZTB
10 delete FA_CODE_INFO

2、查询所有用户表

     select * from user_tables

3、将字符串转换为timestamp类型

TO_TIMESTAMP_TZ('2014-08-20 16:42:06.43','YYYY-MM-DD HH24:MI:SS.FF TZH:TZM')