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

ÔÚoracleÖйØÓÚÊ÷µÄsql

±ítask£¬×Ö¶Îid_£¬name_
id_µÄÊý¾ÝÈçÏÂÐÎʽ£º
1
1.1
1.1.1
1.1.1.2
1.2
1.2.1
...
10
10.1
10.1.1
10.2.1
10.2.1.1
10.2.1.1.1
10.2.1.1.2
.......
×¢£º“.”±êʶ¸¸×ӵĹØÏµ¡£
ÏÖÔÚͨ¹ýid_²éѯÊ÷½á¹¹µÄЧ¹û£¬²¢ÇÒÖªµÀ´Ë½ÚµãÊÇ·ñΪҶ×Ó½Úµãleaf¡£¡££¿
Óï¾äÈçÏ£º
select
id_ ,
name_ ,
(select count(id_) from  task where t.id_= substr(id_,0,INSTR((id_),'.',-1)-1) )  as  leaf,connect_by_isleaf from  task t 
  start with  t.id_ ='5' connect by prior
  t.id_= substr(t.id_,0,INSTR((t.id_),'.',-1)-1) order by t.id_


Ïà¹ØÎĵµ£º

oracle½âËö

alter system kill session'50,492';
--ÒÔϼ¸¸öΪÏà¹Ø±í
SELECT * from v$lock;
SELECT * from v$sqlarea;
SELECT * from v$session;
SELECT * from v$process ;      
SELECT * from v$locked_object;   
SELECT * from all_objects;   
SELECT * from v$session_wait; ......

oracleÁÙʱ±í

ÔÚOracle8i»òÒÔÉϰ汾ÖУ¬¿ÉÒÔ´´½¨ÒÔÏÂÁ½ÖÖÁÙʱ±í£º
1¡£»á»°ÌØÓеÄÁÙʱ±í
    CREATE GLOBAL TEMPORARY <TABLE_NAME> (<column specification>)
    ON COMMIT PRESERVE ROWS£»
 
2¡£ÊÂÎñÌØÓеÄÁÙʱ±í
    CREATE GLOBAL TEMPORARY <TABLE_N ......

oracle¹¤¾ß»·¾³


SQLPlusÊÇoracleÌṩµÄÒ»¸öÃüÁîÐÐÖ´ÐеŤ¾ß
SQLPlusÖÐÓÃÁ½ÖÖÃüÁ
    sqlplus£ºÒÔÃüÁîÐеķ½Ê½½øÈëÊý¾Ý¿âÁ¬½Ó
    sqlplusw£ºÒÔ´°¿ÚµÄÐÎʽÆô¶¯ÃüÁîÐй¤¾ß  ×¢£ºÖ÷»ú×Ö·û´®£¬ÊäÈëÊý¾Ý¿âÃû³Æ
             &n ......

Oracle³õѧÕß±ØÖªµÄ100¸öÒÉÎÊ

1. Oracle°²×°Íê³ÉºóµÄԭʼ¿ÚÁ
¡¡internal/oracle
¡¡¡¡sys/change_on_install
¡¡¡¡system/manager
¡¡¡¡scott/tiger
¡¡¡¡sysman/oem_temp
2. ORACLE9IAS WEB CACHEµÄԭʼĬÈÏÓû§ºÍÃÜÂ룿
administrator/administrator
3. oracle 8.0.5ÈçºÎ½¨Á¢Êý¾Ý¿â£¿
ÓÃorainst¡£¼ÙÈçÓÐmotif½çÃæ£¬Äܹ»ÓÃorainst /m¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ