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

ÔÚOracleÖеÄÊ÷ÐβÙ×÷

ÔÚOracleÖеÄÊ÷ÐβÙ×÷
1.È¡×ӽڵ㼰·¾¶(ÕýÊ÷):
select t.id ,t.code, t.name ,t.pid
,SYS_CONNECT_BY_PATH(t.id,'.')||'.' as IdPath
from tas_catalog t
--where id!=110
start with id=110
connect by  pid = prior id
order siblings  by id
2.È¡¸÷¼¶¸¸½Úµã(µ¹Ê÷)£º
select t.id ,t.code, t.name ,t.pid
,SYS_CONNECT_BY_PATH(t.id,'.')||'.' as IdPath --·¾¶´Ó·´µÄ
from tas_catalog t
--where id!=110
start with id=110
connect by  id = prior pid
order siblings  by id
ÎÞÂÛÕýÊ÷»¹Êǵ¹Ê÷, ¹Ø¼ü¾ÍÔÚÓÚconnect byµÄÌõ¼þ.
ÕýÊ÷:   ±ØÐëÊÇ   ‘¸¸’= prior ‘×Ó’
µ¹Ê÷:   ±ØÐëÊÇ   ‘×Ó’= prior ‘¸¸’


Ïà¹ØÎĵµ£º

oracleÁ¬½ÓÔ¶³ÌÊý¾Ý¿â

D:\oracle\product\10.2.0\db_2\NETWORK\ADMIN
6¡¢ÐÞ¸Äoracle°²×°Â·¾¶ÏÂD:\oracle\product\10.2.0\db_2\NETWORK\ADMIN\tnsnames.oraµÄtnsnames.oraÎļþ£¬Ìí¼Ó
XXX =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.12.42 ......

Oracle±í¹ÜÀí_3ÔÂ6ÈÕ

3ÔÂ6ÈÕ£º
¾Å¡¢±í¹ÜÀí£º
Ò»¡¢ÔÙ±í¹ÜÀíÖÐÐèҪѧϰµÄÄÚÈÝ£º
1¡¢  ´´½¨±í
2¡¢  ³£ÓõÄÊý¾ÝÀàÐÍ
3¡¢  ɾ³ý±í
4¡¢  ¸´ÖƱí
5¡¢  Ð޸ıí
6¡¢  ±íÖØÃüÃû
7¡¢  ½Ø¶Ï±í
8¡¢  ±íµÄÔ¼ÊøÌõ¼þ
¶þ¡¢´´½¨±í
³£¼û±íÓï·¨£º
´´½¨±íÓï·¨£º
CREATE TABLE ±íÃû
(
   &nb ......

Oracle±¨TNS 12518µÄ´íÎó

TNS-12518: TNS:listener could not hand off client connection
 TNS-12560: TNS:protocol adapter error
  TNS-00530: Protocol adapter error
   32-bit Windows Error: 2: No such file or directory
½â¾ö·½·¨£º
      ÒòΪÎÒʹÓõÄÊÇÐéÄâ»ú£¬ËùÒÔÔÚIPÉÏĬÈϵÄ×Ô¶¯· ......

killtest ·ÖÏí×îеÄoracle 1z0 047Ìâ¿â×ÊÁÏÏÂÔØ

1z0-047 ×ÊÁϵÄ×îзÖÏí£¬ÏÂÃæһЩÌâÄ¿ÊÇ´Ó×îеÄÌâ¿âÖо«ÐÄÕûÀí³öÀ´µÄ£¬ÖÊÁ¿ºÜ¸ß£¬ÐèÒªµÄÅóÓÑ¿´¹ýÀ´µÄ°¡¡£
1. Which statements are true? (Choose all that apply.)
A. The data dictionary is created and maintained by the database administrator.
B. The data dictionary views can consist of joins of dictiona ......

oracle clusterware ºÍ oracle rac µÄÖ÷Òª²¿¼þ

ÏÖÔÚ¿´Ïà¹ØµÄRAC½á¹¹µÄÎÄÕ»¹²»Ì«Àí½â¡£
ÏÖÔÚ¿´Õâ¸ö¾ÍºÜÇå³þÆäÖеÄÒâ˼ÁË¡£
oracle clusterware Ö÷ÒªÓÐÒÔÏÂÖ÷Òª²¿¼þ£º
CSS: ¼¯ÈºÍ¬²½·þÎñ
Ö÷Òª¹ÜÀíÕû¸ö¼¯ÈºÄÚ¸÷¸ö½Úµã¼äµÄÇé¿ö£¬°üÀ¨½ÚµãµÄÌí¼ÓºÍ¼õÉÙ¡£ÓëÖ®¶ÔÓ¦µÄÊÇocssd ½ø³Ì£¬Èç¹û¸Ä½ø³Ì³öÏÖ¹ÊÕϽ«»áµ¼Ö½ڵãÖØÆô¡£Èç¹ûʹÓÃÁ˵ÚÈý·½µÄclusterware£¬css ͨ¹ýµÚÈý·½clus ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ