ORACLE PL/SQL ´æ´¢¹ý³Ì½Ì³Ì
(1)SEQNAME.NEXTVALÀïÃæµÄÖµÈçºÎ¶Á³öÀ´£¿¿ÉÒÔÖ±½ÓÔÚinsert into test values(SEQNAME.NEXTVAL) ÊÇ¿ÉÒÔÓà ÕâÑù£º
SELECT tmp#_seq.NEXTVAL
INTO id_temp
from DUAL; È»ºó¿ÉÒÔÓÃid_temp
(2)PLS-00103: ³öÏÖ·ûºÅ ">"ÔÚÐèÒªÏÂÁÐ֮һʱ£º
´úÂëÈçÏ£º
IF (sum>0)
THEN
begin
INSERT INTO emesp.tp_sn_production_log
VALUES (r_serial_number, , id_temp);
EXIT;
end;
Ò»Ö±±¨sum>0 ÕâÊǸöºÜÓôÃÆµÄÎÊÌâ ÒòΪ±äÁ¿ÓÃÁËsum ËùÒÔ²»ÐУ¬ºó¸ÄΪi_sum>0
(3)oracle Óï·¨
1. OracleÓ¦Óñ༷½·¨¸ÅÀÀ
´ð£º1) Pro*C/C++/... : CÓïÑÔºÍÊý¾Ý¿â´ò½»µÀµÄ·½·¨£¬±ÈOCI¸ü³£ÓÃ;
2) ODBC
3) OCI: CÓïÑÔºÍÊý¾Ý¿â´ò½»µÀµÄ·½·¨£¬ºÍProCºÜÏàËÆ£¬¸üµ×²ã£¬ºÜÉÙÓÃ;
4) SQLJ: ºÜеÄÒ»ÖÖÓÃJava·ÃÎÊOracleÊý¾Ý¿âµÄ·½·¨£¬»áµÄÈ˲»¶à;
5) JDBC
6) PL/SQL: ´æ´¢ÔÚÊý¾ÝÄÚÔËÐÐ, ÆäËû·½·¨ÎªÔÚÊý¾Ý¿âÍâ¶ÔÊý¾Ý¿â·ÃÎÊ;
2. PL/SQL
´ð£º1) PL/SQL(Procedual language/SQL)ÊÇÔÚ±ê×¼SQLµÄ»ù´¡ÉÏÔö¼ÓÁ˹ý³Ì»¯´¦ÀíµÄÓïÑÔ;
2) Oracle¿Í»§¶Ë¹¤¾ß·ÃÎÊOracle·þÎñÆ÷µÄ²Ù×÷ÓïÑÔ;
3) Oracle¶ÔSQLµÄÀ©³ä;
4. PL/SQLµÄÓÅȱµã
´ð£ºÓŵ㣺
1) ½á¹¹»¯Ä£¿é»¯±à³Ì£¬²»ÊÇÃæÏò¶ÔÏó;
2) Á¼ºÃµÄ¿ÉÒÆÖ²ÐÔ(²»¹ÜOracleÔËÐÐÔÚºÎÖÖ²Ù×÷ϵͳ);
3) Á¼ºÃµÄ¿Éά»¤ÐÔ(±àÒëͨ¹ýºó´æ´¢ÔÚÊý¾Ý¿âÀï);
4) ÌáÉýϵͳÐÔÄÜ;
µÚ¶þÕÂ
PL/SQL³ÌÐò½á¹¹
1. PL/SQL¿é
´ð£º1) ÉêÃ÷²¿·Ö, DECLARE(²»¿ÉÉÙ);
2) Ö´Ðв¿·Ö, BEGIN...END;
3) Òì³£´¦Àí£¬EXCEPTION(¿ÉÒÔûÓÐ);
2. PL/SQL¿ª·¢»·¾³
´ð£º¿ÉÒÔÔËÓÃÈκδ¿Îı¾µÄ±à¼Æ÷±à¼£¬ÀýÈ磺VI &
Ïà¹ØÎĵµ£º
ÔÚPL/SQLÖÐʹÓÃÕóÁд¦ÀíÊÇÒ»¸öºÜºÃµÄ×ö·¨(È磬ʹÓÃbulk collectºÍforall)¡£ÅúÁ¿´¦ÀíÄܹ»´ó´ó¼õÉÙPL/SQLÓï¾äÖ´ÐÐÒýÇæµÄ»·¾³Çл»´ÎÊý£¬´Ó¶øÌá¸ßÆäÐÔÄÜ¡£
¡¡¡¡ÁíÒ»¸öÓÅÐãʾÀýÊǰѴ洢¹ý³ÌÖеÄËùÓдúÂë·ÅÈëËø¶¨µÄÈí¼þ°üÖУ¬ÕâÑù¿ÉÒÔÉú³ÉÄ£¿éµ¥Ôª¡£°Ñ´æ´¢¹ý³Ì·ÅÈëÈí¼þ°üÀï¿ÉÒÔʵÏÖÏà¹Ø³ÌÐòºÍ¹¦ÄܵķÖ×é¡£µ±
µ¥¸ö°ü±»Ê¹Óà ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´Ð ......
When queried, virtual columns appear to be normal table columns, but
their values are derived rather than being stored on disc. The syntax
for defining a virtual column is listed below.
column_name [datatype] [GENERATED ALWAYS] AS (expression) [VIRTUAL]
If the datatype is omitted, it is determin ......
========µÚһƪ=========
ÔÚÒ»ÕűíÖÐij¸ö×Ö¶ÎÏÂÃæÓÐÖØ¸´¼Ç¼£¬Óкܶ෽·¨£¬µ«ÊÇÓÐÒ»¸ö·½·¨£¬ÊDZȽϸßЧµÄ£¬ÈçÏÂÓï¾ä£º
select data_guid from adam_entity_datas a where a.rowid > (select min(b.rowid) from adam_entity_datas b where b.data_guid = a.data_guid)
Èç¹û±íÖÐÓдóÁ¿Êý¾Ý£¬µ«ÊÇÖØ¸´Êý¾Ý±È½ÏÉÙ£¬ÄÇô ......
2000·¢²¼Óë¶©ÔÄ
Ô¤±¸¹¤×÷
1.·¢²¼·þÎñÆ÷,¶©ÔÄ·þÎñÆ÷¶¼´´½¨Ò»¸öͬÃûµÄwindowsÓû§,²¢ÉèÖÃÏàͬµÄÃÜÂë,×öΪ·¢²¼¿ìÕÕÎļþ¼ÐµÄÓÐЧ·ÃÎÊÓû§
--¹ÜÀí¹¤¾ß
--¼ÆËã»ú¹ÜÀí
--Óû§ºÍ×é
--ÓÒ¼üÓû§
--н¨Óû§
--½¨Á¢Ò»¸öÁ¥ÊôÓÚadministrator×éµÄµÇ½windowsµÄÓû§£¨SynUser£©
2.ÔÚ·¢²¼·þÎñÆ÷ÉÏ,н¨Ò»¸ö¹²ÏíĿ¼ ......