PL/SQL Á¬½ÓOracle£¬N¾ÃûÁ¬ÉÏ£¡¾È¼±
±¾ÈË×°µÄÊÇplsql7.0£¬»úÆ÷ÉÏûÓа²×°Oracle¿Í»§¶Ë£¬ÊDzÉÈ¡ÍøÉÏÄÇÖÖ¼òÒ×°²×°À´°²×°µÄ£¬
¿ªÊ¼Ö®³õÊÇ¿ÉÒÔÁ¬ÉÏOracleÊý¾Ý¿â·þÎñÆ÷£¬¿ÉÊÇijÌìÖØÐ°²×°ÁËÒ»´ÎOracle¿Í»§¶Ë£¬ÇÒ°ÑOracle¿Í»§¶Ëɾ³ýºó£¬
ÔÙÀûÓÃÍøÉϵÄÂÌÉ«Á¬½ÓOracle·½·¨£¬¾Í²»¿ÉÐÐÁË
´óÅ£ÃÇ£¬¾È¾È¼±°¡°¡°¡°¡°¡£¡£¡
ÕÒÏÂtnsnames.oraÎļþ£¬¿´¿´Á¬½ÓÊÇ·ñÅäÖÃÕýÈ·
plsqlÖÐÓиöÑ¡ÏÉèÖóÉoracleName¾Í¿ÉÒÔÁË
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¿â
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......