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

PL/SQL Á¬½ÓOracle£¬N¾ÃûÁ¬ÉÏ£¡¾È¼±

±¾ÈË×°µÄÊÇplsql7.0£¬»úÆ÷ÉÏûÓа²×°Oracle¿Í»§¶Ë£¬ÊDzÉÈ¡ÍøÉÏÄÇÖÖ¼òÒ×°²×°À´°²×°µÄ£¬
¿ªÊ¼Ö®³õÊÇ¿ÉÒÔÁ¬ÉÏOracleÊý¾Ý¿â·þÎñÆ÷£¬¿ÉÊÇijÌìÖØÐ°²×°ÁËÒ»´ÎOracle¿Í»§¶Ë£¬ÇÒ°ÑOracle¿Í»§¶Ëɾ³ýºó£¬
ÔÙÀûÓÃÍøÉϵÄÂÌÉ«Á¬½ÓOracle·½·¨£¬¾Í²»¿ÉÐÐÁË
´óÅ£ÃÇ£¬¾È¾È¼±°¡°¡°¡°¡°¡£¡£¡
ÕÒÏÂtnsnames.oraÎļþ£¬¿´¿´Á¬½ÓÊÇ·ñÅäÖÃÕýÈ·

plsqlÖÐÓиöÑ¡ÏÉèÖóÉoracleName¾Í¿ÉÒÔÁË

ÒýÓÃ
ÕÒÏÂtnsnames.oraÎļþ£¬¿´¿´Á¬½ÓÊÇ·ñÅäÖÃÕýÈ·

up

ÓÐʲôÌáʾ£¬Ìù³öÀ´¿´Ò»Ï¡£

ÒýÓÃ
ÒýÓà 1 Â¥ csuxp2008 µÄ»Ø¸´:
ÕÒÏÂtnsnames.oraÎļþ£¬¿´¿´Á¬½ÓÊÇ·ñÅäÖÃÕýÈ·
up

ÎÒµÄtnsnames.oraÎļþÈçÏ£º
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.(SERVER = DEDICATED)
# Çë¸ù¾Ýʵ¼ÊÇé¿öÔÚ±¾ÎļþÖÐÔö¼ÓÏàÓ¦µÄÁ¬½Ó²ÎÊý

DDDD_X.X.X.X =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = X.X.X.X)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = DDDD_192.168.242.26)
    )
)

²é¿´²¢È·ÈÏÄãµÄʵÀýÃûÊÇ·ñÊÇDDDD_192.168.242.26 ¸öÈ˾õµÃ×îºÃ±ðÓÃ.

¼ì²éÁ¬½ÓÊÇ·ñÕýÈ·
ÔÚPLSQL DeveloperÖÐÑ¡Ôñ ¹¤¾ß-Ê×Ñ¡ÏÁ¬½Ó,ÒÔÏÂÁ½ÏîÐèÕýÈ·ÅäÖÃ
Oracle Ö÷Ŀ¼Ãû
OCI¿â

ÒýÓÃ
¼ì²éÁ¬½ÓÊÇ·ñÕýÈ·
ÔÚP


Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

OracleÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ