摘要：问题描述： 在plsql中执行查询语句时，查询出的结果中中文为乱码，如图： 解决办法： 查看服务器端编码 select userenv('language') from dual; 查询结果为: 查看本地字符集 select * from V$NLS_PARAMETERS; --查看本地字符集 设置 阅读全文

摘要：CREATE [OR REPLACE] PROCEDURE procedure_name ([arg1 [ IN | OUT | IN OUT ]] type1 [DEFAULT value1], [arg2 [ IN | OUT | IN OUT ]] type2 [DEFAULT value1] 阅读全文

摘要：CREATE [OR REPLACE] FUNCTION 函数名称(arg1 [{IN | OUT | IN OUT}] TYPE1 [DEFAULT VALUE1], [arg2 [{IN | OUT |IN OUT }] TYPE2 [DEFAULT VALUE1]],……[argn [ { I 阅读全文

摘要：declare job binary_integer; begin dbms_job.submit(job => job, what => 'DATA_MIGRATION_TOOL2.INSERT_INV_SNAP;', next_date => sysdate ); -- 记得哦 commit; 阅读全文

摘要：oracle写法： select * from (select fu.display_name, row_number() over(order by fu.id) pageId from fnd_user fu) t where t.pageId between 20 and 30 mysql写法 阅读全文

摘要：SELECT * FROM tableName t where NOT REGEXP_LIKE(t.source_transaction_id, '^(+ [ 0 - 9 ] +) $') 备注说明：oracle 判断字段为非数字 阅读全文

摘要：select a.type, a.owner, b.SID, b.SERIAL#, b.OSUSER, b.MACHINE, b.PROGRAM, b.MODULE, b.ACTION From dba_ddl_locks a, v$session b where a.session_id = b. 阅读全文

摘要：--锁表语句 SELECT b.owner, b.object_name, a.session_id, a.locked_mode FROM v$locked_object a, dba_objects b WHERE b.object_id = a.object_id; 备注说明 OWNER ：数 阅读全文