摘要：oracle生成uuid SELECT SYS_GUID() FROM DUAL; 存储过程构建sql时，拼接的字符 INDENT_STRING VARCHAR2(10 CHAR) := ' '; --CHR(9); FOR TAB NEWLINE_CHAR VARCHAR2(2 CHAR) := 阅读全文

摘要：oracle动态执行sql DECLARE V_SQL CLOB; V_NAME VARCHAR2(200); BEGIN -- 定义SQL V_SQL := 'SELECT NAME FROM SYS_USER_T WHERE ROWNUM = 1'; -- 执行SQL EXECUTE IMMED 阅读全文

摘要：查询表被锁住 --查询被锁的表 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; --查看是哪个s 阅读全文