ѧϰOracleÖеĹý³ÌÒ»µãС½á£¡
×î½ü½Ó´¥OracleµÄ¶«Î÷£¬¸Õ¸Õ¿ªÊ¼Ñ§Ï°²¢Í¬Ê±×öµã¶«Î÷£¬×î½üÀÏÊÇʹÓô洢¹ý³Ì¡£ÏÖÔÚͨ¹ýÎÒ¸öÈ˵ÄʹÓüòµ¥ËµÏÂ×Ô¼ºµÄ¸ÐÊÜ£¡
ÔÚÉè¼Æ´æ´¢¹ý³ÌÖУ¬Ò»±¾Í¨¹ý¶þ¸ö·½Ê½ÊµÏÖ£º
1£º¾ÍÊǼòµ¥µÄʵÏÖÓαê
---¹ý³ÌµÄÉùÃ÷---
procedure procedure_name
( var_1 in xx1%type,--¹ý³Ì½ÓÊÕ²ÎÊý1£¬²¢¸ø³öÀàÐÍ
var_2 in xx2%type,--¹ý³Ì½ÓÊÕ²ÎÊý2£¬²¢¸ø³öÀàÐÍ
...... --ÉùÃ÷¹ý³ÌÐèÒª½ÓÊյIJÎÊý£¬²¢¸ø³öÀàÐÍ
varout out cursor ---ÉùÃ÷Ò»¸ö±äÁ¿£¬ÎªÓαêµÄ±äÁ¿£¬ÓÃÀ´·µ»Ø½á¹û
) IS
--------¿ªÊ¼------------
BEGIN
-------ɾ³ý¾ÉµÄÊý¾Ý£¨¸ù¾Ýʵ¼ÊÇé¿ö¶ø¶¨£©---------------
DELETE from TABLE_NAME
WHERE
£»
----½øÐвåÈëµÄ²Ù×÷---------
INSERT INTO TABLE_NAME (X1,X2,.....)
SELECT TABLE_NAME
from
WHERE
;
-------¿ªÊ¼½øÐÐÏàÓ¦µÄ²Ù×÷--------------
UPDATE TABLE_NAME
SET
XX1=(),
XX2=(),
......
XXn=()
WHERE Ìõ¼þ
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
1) Instance in RESTRICTED SESSIONS mode?
¡¡¡¡Check if the instance is in restricted sessions mode:
¡¡¡¡select instance_name,logins from v$instance;
¡¡¡¡If logins=RESTRICTED, then:
¡¡¡¡alter system disable restricted session;
¡¡¡¡^-- Checked!
¡¡¡¡2) JOB_QUEUE_PROCESSES=0
¡¡¡¡Make sure th ......
ÏÈ×°ÁËÊý¾Ý¿â£¬ÓÃnetµ÷ÊÔµÄʱºòûÓÐÎÊÌ⣬µ«ÊÇÉú³ÉÍøÕ¾ºó£¬ÔÚÁ¬½ÓÊý¾Ý¿âµÄʱºòÌáʾ˵¿Í»§¶ËµÄ°æ±¾Ì«µÍ£¨Òâ˼¾ÍÊÇÕâ¸ö£©£¬ºóÓÖ×°ÁËÒ»¸ö9iµÄ¿Í»§¶Ë£¬Ö®ºó¾Í°ÑÏà¹Ø·þÎñ¸Ä³ÉÊÖ¶¯£¬NÌìÖ®ºó·¢ÏÖÊý¾Ý¿â²»ÄÜÕý³£Æô¶¯¡£
Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracl ......
28.1 Oracle 11g¼ò½é
¾¹ýÁËÈýÄêµÄ×¼±¸£¬Oracle£¨¼×¹ÇÎÄ£©¹«Ë¾ÓÚ2007Äê7ÔÂ12ÈÕÔÚÈ«Çò·¶Î§ÄÚͬ²½ÍƳöÁËÆä×îа汾µÄÊý¾Ý¿â²úÆ·——Oracle 11g¡£ÐµÄOracleÊý¾Ý¿âÈÔÈ»ÒÔg×÷Ϊ°æ±¾ºó׺£¬ÒÔ´ú±íÕâÊÇÒ»¸ö°üº¬ÁËÍø¸ñ¼ÆËã¼¼ÊõµÄÊý¾Ý¿âÈí¼þ£¨Oracle×Ô10°æ±¾¿ªÊ¼ÒÔg×÷Ϊ°æ±¾ºó׺£¬¶øÔÚÕâ֮ǰÊÇʹÓÃi£¬ÈçOracle 8i¡¢ ......
[ÕªÒª]Ö÷Òª´Ó´óÐÍÊý¾Ý¿âORACLE»·¾³Ëĸö²»Í¬¼¶±ðµÄµ÷Õû·ÖÎöÈëÊÖ£¬·ÖÎöORACLEµÄϵͳ½á¹¹ºÍ¹¤×÷»úÀí£¬´Ó²»Í¬·½Ãæ½ÏÈ«ÃæµØ×ܽáORACLEÊý¾Ý¿âµÄÓÅ»¯µ÷Õû·½°¸¡£
[¹Ø¼ü´Ê]ORACLEÊý¾Ý¿â¡¢»·¾³µ÷Õû¡¢ÓÅ»¯Éè¼Æ¡¢·½°¸
ÖÐͼ·ÖÀàºÅ£ºTP3 ÎÄÏ×±êʶÂ룺A ÎÄÕ±àºÅ£º1671£7597(2008)0720043£01
¡¡¡¡
¡¡¡¡ORACLEÊý¾Ý¿âÖÐÊý¾Ý´æÈ¡ÐÔÄ ......