ITPub博客

create database link  mes1_likseq_wfl40 connect to wfl identified by wfldata using 'SGERPDB'select seq_wfs_tb_fcsmail.nextval@mes1_likseq_wfl40 from dual;select * from mes1_lik_wfl40.wfs_tb_fcsma...

create database link  mes1_likseq_wfl40 connect to wfl identified by wfldata using 'SGERPDB'select seq_wfs_tb_fcsmail.nextval@mes1_likseq_wfl40 from dual;select * from mes1_lik_wfl40.wfs_tb_fcsma...

http://**/index.php

identified by "符號"

select * from  v$locked_objectselect * from v$lockselect t2.username,t2.sid,t2.serial#,t2.logon_time ??from v$locked_object t1,v$session t2 ??where t1.session_id=t2.sid order by t2.logon_time; se...

select * from  v$locked_objectselect * from v$lockselect spid from v$process p where p.addr='9F2B64FC'select  * from v$sessionselect * from v$lock  where kaddr='9F2B64FC'select * from v...

SQL> alter tablespace TBS_FATHR  add datafile  2  '/u03/oradata/ecard/tbs_fathr03.dbf' size 2048M  3  autoextend on next 2048K  4  maxsize 4096M;Tablespace altered....

select * from DBA_tab_privs where GRANTEE ='INFUSE'select * from DBA_tab_privs where WNER ='INFUSE'select * from dba_objects where OBJECT_NAME LIKE '%testinf3%';SELECT * from  dba_objects where O...

select * from dba_sys_privs;select * from role_sys_privs;select * from DBA_tab_privs where WNER ='CVS'select * from DBA_tab_privs where GRANTEE ='SSA'SELECT * FROM CVS.CVS_LEAVELIMITSELECT * from&nbsp...

select * from dba_users  where USERNAME='QCP'select distinct tablespace_name from dba_tables where wner='QCP'select distinct tablespace_name from  dba_indexes where wner='QCP'SELECT * FROM D...

select distinct tablespace_name from dba_tables where wner='EMS'select distinct tablespace_name from dba_tables where wner='HEM'select DEFAULT TABLESPACE  from dba_users where USERNAME='HEM'sele...

  Class.forName("oracle.jdbc.driver.OracleDriver");         conn = DriverManager.getConnection("jdbc:oracle:thin:@123.15.51.111:1521:ora10g", "ims", "ora12...