摘要:
--查看不同用户的连接数select TERMINAL from v$session where username='username' and machine='machine'---查询用户会话select username,serial#, sid from v$session where s... 阅读全文
摘要:
create or replace function fn_getKeyreturn varchar2isk varchar2(30);beginselect to_char(sysdate, 'yyyymmddhh24miss') ||'-'|| seq_test.nextval into k f... 阅读全文