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

ORACLE Êý¾Ý¿âÃû¡¢ÊµÀýÃû¡¢ORACLE_SIDµÄÇø±ð

Êý¾Ý¿âÃû(DB_NAME)¡¢ÊµÀýÃû(Instance_name)¡¢ÒÔ¼°²Ù×÷ϵͳ»·¾³±äÁ¿(ORACLE_SID)
ÔÚORACLE7¡¢8Êý¾Ý¿âÖÐÖ»ÓÐÊý¾Ý¿âÃû(db_name)ºÍÊý¾Ý¿âʵÀýÃû(instance_name)¡£ÔÚORACLE8i¡¢9iÖгöÏÖÁËеIJÎÊý£¬¼´Êý¾Ý¿âÓòÃû(db_domain)¡¢·þÎñÃû(service_name)¡¢ÒÔ¼°²Ù×÷ϵͳ»·¾³±äÁ¿(ORACLE_SID)¡£ÕâЩ¶¼´æÔÚÓÚͬһ¸öÊý¾Ý¿âÖеıêʶ£¬ÓÃÓÚÇø·Ö²»Í¬Êý¾Ý¿âµÄ²ÎÊý¡£
Ò»¡¢Ê²Ã´ÊÇÊý¾Ý¿âÃû(db_name)?
Êý¾Ý¿âÃûÊÇÓÃÓÚÇø·ÖÊý¾ÝµÄÄÚ²¿±êʶ£¬ÊÇÒÔ¶þ½øÖÆ·½Ê½´æ´¢ÓÚÊý¾Ý¿â¿ØÖÆÎļþÖеIJÎÊý£¬ÔÚÊý¾Ý°²×°»ò´´½¨Ö®ºó½«²»µÃÐ޸ġ£Êý¾Ý¿â°²×°Íê³Éºó£¬¸Ã²ÎÊý±»Ð´ÈëÊý¾Ý¿â²ÎÊýÎļþpfileÖУ¬¸ñʽÈçÏ£º
.........
db_name="orcl" #(²»ÔÊÐíÐÞ¸Ä)
db_domain=dbcenter.toys.com
instance_name=orcl
service_names=orcl.dbcenter.toys.com
control_file=(...............
.........
ÔÚÿһ¸öÔËÐеÄORACLE8iÊý¾Ý¿âÖж¼ÓÐÒ»¸öÊý¾Ý¿âÃû(db_name),Èç¹ûÒ»¸ö·þÎñÆ÷³ÌÐòÖд´½¨ÁËÁ½¸öÊý¾Ý¿â£¬ÔòÓÐÁ½¸öÊý¾Ý¿âÃû¡£Æä¿ØÖƲÎÊý¾Ý·ÖÊôÔÚ²»Í¬µÄpfileÖпØÖÆ×ÅÏà¹ØµÄÊý¾Ý¿â¡£
¶þ¡¢Ê²Ã´ÊÇÊý¾Ý¿âʵÀýÃû(instance_name)
Êý¾Ý¿âʵÀýÃûÔòÓÃÓںͲÙ×÷ϵͳ֮¼äµÄÁªÏµ£¬ÓÃÓÚ¶ÔÍⲿÁ¬½ÓʱʹÓá£ÔÚ²Ù×÷ϵͳÖÐҪȡµÃÓëÊý¾Ý¿âÖ®¼äµÄ½»»¥£¬±ØÐëʹÓÃÊý¾Ý¿âʵÀýÃû¡£ÀýÈ磬ҪºÍijһ¸öÊý¾Ý¿âserverÁ¬½Ó£¬¾Í±ØÐëÖªµÀÆäÊý¾Ý¿âʵÀýÃû£¬Ö»ÖªµÀÊý¾Ý¿âÃûÊÇûÓÐÓõģ¬ÓëÊý¾Ý¿âÃû²»Í¬£¬ÔÚÊý¾Ý°²×°»ò´´½¨Êý¾Ý¿âÖ®ºó£¬ÊµÀýÃû¿ÉÒÔ±»Ð޸ġ£Êý¾Ý¿â°²×°Íê³Éºó£¬¸ÃʵÀýÃû±»Ð´ÈëÊý¾Ý¿â²ÎÊýÎļþpfileÖУ¬¸ñʽÈçÏ£º
db_name="orcl" #(²»ÔÊÐíÐÞ¸Ä)
db_domain=dbcenter.toys.com
instance_name=orcl #(¿ÉÒÔÐÞ¸Ä,¿ÉÒÔÓëdb_nameÏàͬҲ¿É²»Í¬)
service_names=orcl.dbcenter.toys.com
control_file=(...............
.........
Êý¾Ý¿âÃûÓëʵÀýÃûÖ®¼äµÄ¹ØÏµ¡£
Êý¾Ý¿âÃûÓëʵÀýÃûÖ®¼äµÄ¹ØÏµÒ»°ãÊÇÒ»Ò»¶ÔÓ¦¹ØÏµ£¬ÓÐÒ»¸öÊý¾Ý¿âÃû¾ÍÓÐÒ»¸öʵÀýÃû£¬Èç¹ûÔÚÒ»¸ö·þÎñÆ÷Öд´½¨Á½¸öÊý¾Ý¿â£¬ÔòÓÐÁ½¸öÊý¾Ý¿âÃû£¬Á½¸öÊý¾Ý¿âʵÀýÃû£¬ÓÃÁ½¸ö±êʶȷ¶¨Ò»¸öÊý¾Ý¿â£¬Óû§ºÍʵÀýÏàÁ¬½Ó¡£
µ«ÔÚ8i¡¢9iµÄ²¢ÐзþÎñÆ÷½á¹¹ÖУ¬Êý¾Ý¿âÓëʵÀýÖ®¼ä²»´æÔÚÒ»Ò»¶ÔÓ¦¹ØÏµ£¬¶øÊÇÒ»¶Ô¶à¹ØÏµ£¬(Ò»¸öÊý¾Ý¿â¶ÔÓ¦¶à¸öʵÀý£¬Í¬Ò»Ê±¼äÄÚÓû§Ö»Ò»¸öʵÀýÏàÁªÏµ£¬µ±Ä³Ò»ÊµÀý³öÏÖ¹ÊÕÏ£¬ÆäËüʵÀý×Ô¶¯·þÎñ£¬ÒÔ±£Ö¤Êý¾Ý¿â°²È«ÔËÐС£)
Èý¡¢²Ù×÷ϵͳ»·¾³±äÁ¿(ORACLE_SID)
ÔÚʵ¼ÊÖУ¬¶ÔÓÚÊý¾Ý¿âʵÀýÃûµÄÃèÊöÓÐʱʹÓÃʵÀýÃû(instance_name)²ÎÊý£¬ÓÐʱʹÓÃORACLE_SID²ÎÊý¡£ÕâÁ½


Ïà¹ØÎĵµ£º

Oracleѧϰ±Ê¼Ç4 ÉÔ¸´ÔӵIJéѯºÍ·ÖÒ³

ÈÔȻʹÓÃSCOTTÓû§À´²Ù×÷£º
1¡¢         ÏÔʾ¹¤×ʱȲ¿ÃÅ30µÄËùÓÐÔ±¹¤µÄ¹¤×ʶ¼¸ßµÄÔ±¹¤µÄÐÅÏ¢£º
Select * from emp where sal>all(select sal from emp where deptno=30);
2¡¢         ÏÔʾ¹¤×ʱȲ¿ÃÅ30µÄÈÎÒâÒ»¸öÔ±¹¤µÄ¹¤×ʸ߾ͿÉÒ ......

oracleÐÐÁÐת»»£¨×ª£©

1¡¢¹Ì¶¨ÁÐÊýµÄÐÐÁÐת»»
Èç
student subject grade
--------- ---------- --------
student1 ÓïÎÄ 80
student1 Êýѧ 70
student1 Ó¢Óï 60
student2 ÓïÎÄ 90
student2 Êýѧ 80
student2 Ó¢Óï 100
……
ת»»Îª
ÓïÎÄ Êýѧ Ó¢Óï
student1 80 70 60
student2 90 80 100
……
Óï¾äÈçÏ£ºs ......

±È½ÏºÃµÄoracleºÍСÐÍ»ú×ÊÁÏ

 ±È½Ïרҵ£¬×¨ÃżÆËã»ú¼¼Êõµç×ÓÊéÏÂÔØµÄ£º
www.itpub.net
www.itepub.net
www.netyi.net/in.asp?id=daotong
www.chmpdf.com
Ïà¶Ô²»Ì«×¨ÒµµÄ£¬ÄÚÈÝÒ²·Ç³£·á¸»
www.infoxa.com
www.xpbook.com
ÕâÐ©ÍøÕ¾¼¸ºõ¿ÉÒÔÕÒµ½ÄãÏëÒªµÄÈ«²¿Êé¼®¡£ ......

ORACLEÁ¬½Ó×Ö·û´®µÄд·¨

½ñÌìÉÏÎç²âÊÔÒ»¸ö·ÃÎÊORACLEµÄc++À࣬ÎĵµÉÏ˵Á¬½Ó×Ö·û´®µÄ¸ñʽΪ"Óû§Ãû/¿ÚÁî@Á¬½ÓÃû"£¬ÎÒ²»ÊÇÌ«Ã÷°×Á¬½ÓÃûµ½µ×ΪºÎÎÏÈÓÃIPµØÖ·ÊÔÁËÊÔ
£¬×ÜÊDZ¨´í£¬ËµÎÞ·¨½âÎöµÄÁ¬½Ó±êʶ·û£¬ºóÀ´ÔÚÍøÉϲéÁ˰ëÌ죬¿´µ½ÓиöÈË˵Á¬½ÓÃû¾ÍÊÇ$(ORACLE_HOME)/network/admin/tnsnames.oraÀﶨÒåµÄÊý¾Ý¿âÁ¬½ÓµÄÃû³Æ£¬ÊÔÁËһϣ¬¹ûÈ»Èç´Ë¡£ ......

oracle cursor ÓαêÓ÷¨

Óα꣺
ÓÃÀ´²éѯÊý¾Ý¿â£¬»ñÈ¡¼Ç¼¼¯ºÏ£¨½á¹û¼¯£©µÄÖ¸Õ룬¿ÉÒÔÈÿª·¢ÕßÒ»´Î·ÃÎÊÒ»Ðнá¹û¼¯£¬ÔÚÿÌõ½á¹û¼¯ÉÏ×÷²Ù×÷¡£
·ÖÀࣺ
¾²Ì¬Óα꣺
·ÖΪÏÔʽÓαêºÍÒþʽÓαꡣ
REFÓα꣺
ÊÇÒ»ÖÖÒýÓÃÀàÐÍ£¬ÀàËÆÓÚÖ¸Õë¡£
ÏÔʽÓα꣺
 CURSOR ÓαêÃû ( ²ÎÊý ) [·µ»ØÖµÀàÐÍ] IS
  Select Óï¾ä
ÉúÃüÖÜÆÚ£º
1.´ò¿ªÓαê(OP ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ