随笔分类 -  oracle

摘要：有回车换行的数据，要在sqlldr之前处理掉mysqlUPDATE tablename SET field = REPLACE(REPLACE(field, CHAR(10), ”), CHAR(13), ”); char(10): 换行符 char(13):... 阅读全文

摘要：查看进程: 根据存储过程名称查找是否被锁： select * FROM dba_ddl_locks where name =upper('sp_1'); select * FROM dba_ddl_locks where name like upper('%sp_1%'); 查找SID: selec 阅读全文

摘要：1、按年 2、按月 3、按季 4、按周 5、按小时 6、按分钟 SELECT trunc(sysdate-1) + (ROWNUM - 1) / 24 / 60 AS STAT_TIME FROM DUAL d CONNECT BY ROWNUM <= 1440 +(trunc(sysdate, ' 阅读全文

摘要：oracle查看表名select table_name from user_tables;select table_name from dba_tables;select * from all_all_tablesoracle查看数据库名select * from v$database;mysql查... 阅读全文

摘要：配置contrl文件load datacharacterset utf8append into table role_res_goldfields terminated by ';'TRAILING NULLCOLS(F_USERNAME ,F_RES_TYPE ,F_INDEX... 阅读全文