Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oracle10g SQL ¸ú×Ù

1.¼¤»îSQL¸ú×Ù
   ´Óoracle10gÒÔºóÌṩÁËÐµķ½·¨¼¤»îSQLµÄ¸ú×Ù£¬¼´ÊÇʹÓÃdbms_monitor°üÀ´¿ªÆô»ò¹Ø±ÕSQL¸ú×Ù¡£
   ֮ǰ¾É·½·¨ÊÇʹÓà alter session set events ..  »òÕßʹÓÃdbms_system.set_ev·½Ê½
   ʹÓÃdbms_monitor°ü¿ÉÒÔÔڻỰ£¬¿Í»§¶Ë£¬×é¼þÒÔ¼°Êý¾Ý¿âËĸö²ã¼¶¿ªÆôSQLµÄ¸ú×Ù¡£
   Ö»ÓÐÓµÓÐdba½ÇÉ«µÄÓû§²ÅÄÜÔÊÐíÖ´ÐÐdbms_monitor°ü
   4¸ö²ã´Î¼¶±ðµÄ¼¤»îµ÷Ó÷½·¨£º
    »á »° ¼¶:exec dbms_monitor.session_trace_enable(session_id =>1574,
                        serial_num=>36749,waits=>true,binds=>false);
             ×¢Òâ:ʹÓÃselect *  from v$session where sid=sys_context('userenv','sid');
             »ñµÃsession_idºÍserial
             ¹Ø±ÕÓÃ:
         exec dbms_monitor.session_trace_disable(session_id=>1574,serial_num=>36749)
    ¿Í»§¶Ë¼¶:exec dbms_monitor.cliend_id_trace_enable(
                                 client_id=''JXXXT:Administrator',
                                 waits =>true,binds=>false)
             ×¢Òâ:client_id¼´v$session±íÀïÃæµÄclient_identifier×ֶΣ¬Ä¬ÈÏ´Ë×Ö¶ÎΪ¿Õ,
              ͨ¹ýdba_enabled_traces±í²é¿´ÄÇЩ¿Í»§¶ËÆôÓÃÁËSQL¸ú×Ù
        &nb


Ïà¹ØÎĵµ£º

Oracle µÝ¹é²éѯ

create table tree_table 
(
id number,
pId number,
orderNumber number,
name varchar2(255)
)
select tt.*
from tree_table tt
start with tt.pId = 0
connect by prior tt.id = ttd.pId
order siblings by orderNumber  ......

OracleÌåϵ½á¹¹Ö®£­Âß¼­½á¹¹

Ò»¡¢Oracle Âß¼­½á¹¹¼ò½é
    oracleµÄÂß¼­½á¹¹°üÀ¨±í¿Õ¼ä(tablespace)£¬¶Î(segment),Êý¾Ý¿é(data block)ÒÔ¼°Ä£Ê½¶ÔÏó(schema)¡£
      oracle Êý¾Ý¿âÔÚÂß¼­ÉÏÊÇÓɶà¸ö±í¼ä×é³ÉµÄ£¬±í¿Õ¼äÖд洢µÄ¶ÔÏó½Ð¶Î£¬±ÈÈçÊý¾Ý¶Î£¬Ë÷Òý¶Î£¬ºÍ»ØÍ˶Ρ£¶ÎÓÉÇø×é³É£¬ÇøÊÇ´ÅÅÌ·ÖÅäµÄ×îСµ¥Î»¡£ ......

sqlÖ®left join¡¢right join¡¢inner joinµÄÇø±ð


 
sqlÖ®left join¡¢right join¡¢inner joinµÄÇø±ð
×òÌìÃæÊÔ8Ò³±ÊÊÔÌâÄ¿,»ù±¾É϶¼ÊÇSQl µÄ,ÌØ±ðÊÇÕ⼸¸öÇø±ð,¼ÇµÃ²»ÊǺÜÇåÎú,Ö»¼ÇµÃleftÊÇÒÔ×ó±íΪÖ÷±í,
rightÒÔÓÒ±íΪÖ÷±í,µ¼ÖÂ×ö´íÁ˼¸¸ö!½ñÌìËÑÁËÏÂ!×ÜËãŪÇå³þÁË!ÒÔÏÂÊÇתÌû!
left join(×óÁª½Ó) ·µ»Ø°üÀ¨×ó±íÖеÄËùÓмǼºÍÓÒ±íÖÐÁª½á×Ö¶ÎÏàµÈµÄ¼Ç¼
right j ......

SQL Server 2000 µÄϵͳÊý¾Ý¿â

SQL Server 2000 µÄϵͳÊý¾Ý¿â
SQL Server 2000·þÎñÆ÷°²×°ºó»á½¨Á¢4ϵͳÊý¾Ý¿â¡£·Ö±ðÊÇmaster¡¢model¡¢msdb¡¢tempdb¡£
1¡¢masterÊý¾Ý¿â
    masterÊý¾Ý¿âÊÇSQL Server 2000ÖÐ×îÖØÒªµÄÊý¾Ý¿â£¬¼Ç¼ÁËSQL Server 2000µÄ·þÎñÆ÷¼¶ÏµÍ³ÐÅÏ¢£¬°üÀ¨ËùÓÐÕË»§ºÍÃÜÂ룬´ÅÅ̿ռ䡢Îļþ·ÖÅäºÍʹÓá¢ÏµÍ³¼¶µÄÅäÖòÎÊý¡ ......

SQL Server³£ÓÃϵͳ´æ´¢¹ý³Ì

--ÁгöSQL ServerʵÀýÖеÄÊý¾Ý¿â
sp_databases
--·µ»ØSQL Server¡¢Êý¾Ý¿âÍø¹Ø»ò»ù´¡Êý¾ÝÔ´µÄÌØÐÔÃûºÍÆ¥ÅäÖµµÄÁбí
sp_server_info
--·µ»Øµ±Ç°»·¾³ÖеĴ洢¹ý³ÌÁбí
sp_stored_procedures
--·µ»Øµ±Ç°»·¾³Ï¿ɲéѯµÄ¶ÔÏóµÄÁÐ±í£¨ÈκοɳöÏÖÔÚ from ×Ó¾äÖеĶÔÏó£©
sp_tables
select * from sysobjects
---Ìí¼Ó»ò¸ü¸Ä ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ