ʹÓÃoracleµÄһЩ¼¼ÇÉ·½·¨

½«²éѯµÄ½á¹ûÉú³Éµ½ÎļþÖУº
set echo on --ÊÇ·ñÏÔʾִÐеÄÃüÁîÄÚÈÝ
set feedback off --ÊÇ·ñÏÔʾ * rows selected
set heading off --ÊÇ·ñÏÔʾ×ֶεÄÃû³Æ
set verify off --ÊÇ·ñÏÔʾÌæ´ú±äÁ¿±»Ìæ´úÇ°ºóµÄÓï¾ä¡£fil
set trimspool off --È¥×ֶοոñ
set pagesize 1000 --Ò³Ãæ´óС
set linesize 50//linesizeÉ趨¾¡Á¿¸ù¾ÝÐèÒªÀ´É趨£¬´óÁËÉú³ÉµÄÎļþÒ²´ó
define fil= 'e:\exp.txt'
prompt *** Spooling to &fil
spool &fil
select id||','||username||','||'"'||password||'"' from myuser;
spool off;
Ç¿ÐÐɱsession£º
SELECT DISTINCT '(' || s.sid || ') - ' || username AS "(session) - username",
o.kglnaobj from V$SESSION s, sys.x$kglob o, sys.x$kglpn p WHERE upper(o.kglnaobj) LIKE ('%P_CREATE_TABLE_ZJ_USER_INFO%') AND p.kglpnhdl = o.kglhdadr AND s.SADDR =
select spid, osuser, s.program
from v$session s,v$process p
where s.paddr=p.addr and s.sid in(53);