摘要：查找DB的字符select * from nls_database_parameters t where t.parameter='NLS_CHARACTERSET';SELECT USERENV ('language') FROM DUAL;查找windowsHKEY_LOCAL_MACHINE\software\oracle** NLSLANG值两个的值要一致参考：1. http://blog.csdn.net/dracotianlong/article/details/82701362.http://www.cnblogs.com/brainstormle 阅读全文

摘要：1.user_objects2.user_arguments3.user_object需求：查找oracle中的所有包，包体等select distinct object_type from user_objects;select * from user_objectS where object_type= 'PACKAGE BODY';SELECT * FROM user_arguments;select * from user_source where type='PACKAGE BODY';select name from user_source wher 阅读全文

摘要：需求：修改oracle表设计中字段长度小于100的。使用SQL来动态生成SQL语句例子如：SELECT ' alter table '|| TABLE_NAME ||' modify '|| COLUMN_NAME|| ' VARCHAR2(100);'from user_tab_columnswhere TABLE_name like 'T_%' and column_name like '%DESC'AND DATA_TYPE ='VARCHAR2'AND DATA_LENGTH<' 阅读全文

摘要：as of timestamp,闪回查询,闪回数据库,oracle 阅读全文

摘要：oracle，合并，merge into 阅读全文

摘要：plsql,表数据库同步更新，表结构同步更新，比较表功能，比较用户功能 阅读全文