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

Oracle PL/SQL±à³Ì¹æ·¶Ö¸ÄÏ

Ò»¡¢PL/SQL±à³Ì¹æ·¶Ö®´óСд
¾ÍÏñÔÚSQLÖÐÒ»Ñù£¬PL / SQLÖÐÊDz»Çø·Ö´óСдµÄ¡£ÆäÒ»°ã×¼ÔòÈçÏ£º
¹Ø¼ü×Ö(BEGIN, EXCEPTION, END, IF THEN ELSE,LOOP, END LOOP)¡¢Êý¾ÝÀàÐÍ(VARCHAR2, NUMBER)¡¢ÄÚ²¿º¯Êý(LEAST, SUBSTR)ºÍÓû§¶¨ÒåµÄ×Ó³ÌÐò(procedures, functions,packages)£¬Ê¹Óôóд¡£
±äÁ¿ÃûÒÔ¼°SQLÖеÄÁÐÃûºÍ±íÃû£¬Ê¹ÓÃСд¡£
¶þ¡¢PL/SQL±à³Ì¹æ·¶Ö®¿Õ°×
¿Õ°×£¨¿ÕÐкͿոñ£©ÔÚPL/SQLÖÐÈçͬÔÚSQLÖÐÒ»ÑùÖØÒª£¬ÒòΪËüÊÇÌá¸ß´úÂë¿É¶ÁÐÔµÄÒ»¸öÖØÒªÒòËØ¡£»»¾ä»°Ëµ£¬¿ÉÒÔͨ¹ýÔÚ´úÂëÖÐʹÓÃËõ½øÀ´ÌåÏÖ³ÌÐòµÄÂß¼­½á¹¹¡£ÒÔÏÂÊÇһЩ½¨Ò飺
ÔڵȺŻò±È½Ï²Ù×÷·ûµÄ×óÓÒ¸÷ÁôÒ»¸ö¿Õ¸ñ£»
½á¹¹´Ê£¨DECLARE, BEGIN, EXCEPTION, END,IF and END IF, LOOP and END LOOP£©¾Ó×óÅÅÁС£ÁíÍ⣬½á¹¹ÖеÄǶÌ׽ṹҪËõ½øÈý¸ö¿Õ¸ñ£¨Ê¹Óÿոñ¼ü£¬¶ø²»ÊÇTab¼ü£©£»
Ö÷Òª´úÂë¶ÎÖ®¼äÓÿÕÐиô¿ª£»
°Ñͬһ½á¹¹µÄ²»Í¬Âß¼­²¿·Ö·Ö¿ªÐ´ÔÚ¶ÀÁ¢µÄÐУ¬¼´Ê¹Õâ¸ö½á¹¹ºÜ¶Ì¡£ÀýÈ磬IFºÍTHEN±»·ÅÔÚͬһÐУ¬¶øELSE ºÍEND IFÔò·ÅÔÚ¶ÀÁ¢µÄÐС£
Èý¡¢PL/SQL±à³Ì¹æ·¶Ö®ÃüÃûÔ¼¶¨
ʹÓÃÒÔÏÂǰ׺¶ÔÓÚ±ÜÃâÓë¹Ø¼ü×ֺͱíÃûÁÐÃûÏà³åÍ»ÊǺÜÓаïÖúµÄ£º
v_±äÁ¿Ãû
con_³£Á¿Ãû
i_ÊäÈë²ÎÊýÃû£¬o_Êä³ö²ÎÊýÃû£¬io_ÊäÈëÊä³ö²ÎÊýÃû
c_ÓαêÃû »òÕß ÓαêÃû_cur
rc_ Ref CursorÃû
r_RecordÃû »òÕß RecordÃû_rec
FOR r_stud IN c_stud LOOP…
FOR stud_rec IN stud_cur LOOP
type_Ãû³Æ£¬Ãû³Æ_type (Óû§¶¨ÒåµÄÀàÐÍ)
t_±íÃû£¬±íÃû_tab £¨PL/SQL ±í£©
rec_RecordÃû£¬RecordÃû_rec £¨Record±äÁ¿£©
e_Òì³£Ãû £¨Óû§¶¨ÒåµÄÒì³££©
°üµÄÃû³ÆÓ¦¸ÃÃèÊö°üÄڵĴ洢¹ý³ÌºÍº¯ÊýÖ÷ÒªËùÍê³ÉµÄ¹¦ÄÜ
´æ´¢¹ý³ÌµÄÃû³ÆÓ¦¸ÃÃèÊö¸Ã´æ´¢¹ý³ÌËùÖ´Ðе͝×÷
º¯ÊýµÄÃû³ÆÓ¦¸ÃÃèÊöËù·µ»ØµÄ±äÁ¿
ÀýÈ磺
PACKAGE student_admin
– admin ºó׺¿ÉÄÜÊÇÓÃÓÚ±íʾ¹ÜÀí¹¦ÄÜ.
PROCEDURE remove_student (i_student_id IN student.studid%TYPE);
FUNCTION student_enroll_count (i_student_id student.studid%TYPE)
RETURN INTEGER;
ËÄ¡¢PL/SQL±à³Ì¹æ·¶Ö®×¢ÊÍ
PL/SQLÖеÄ×¢ÊÍÈçͬSQLÖеÄ×¢ÊÍÒ»ÑùÖØÒª¡£ËûÃÇÓ¦¸Ã½âÊͳÌÐòµÄÖ÷Òª²¿·ÖºÍËùÓйؼüµÄÂß¼­²½Öè¡£
ʹÓõ¥ÐÐ×¢ÊÍ(–)¶ø²»ÊǶàÐÐ×¢ÊÍ(/*)¡£¼´Ê¹PL/SQL¶ÔÕâЩעÊÍ×öͬÑù´¦Àí£¬ÕâÑùÔÚ´úÂëÍê³Éºó½øÐе÷ÊÔÒ²»áÈÝÒ×Щ£¬ÒòΪÄã²»ÄÜÔÚ¶àÐÐ×¢ÊÍÖÐǶÈë¶àÐÐ×¢ÊÍ¡£»»¾ä»°Ëµ£¬µ¥ÐÐ×¢ÊÍ´úÂëÖпÉÒÔ²¿·ÖÈ¡Ïû×¢ÊÍ£¬¶øÔÚ¶àÐÐ×¢ÊÍ´úÂëÖÐÔò²»ÐС£
Îå¡¢ÆäËûµÄ½¨Òé
¶ÔÓÚPL/SQLÖÐǶÈëµÄSQLÉùÃ÷


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

oracleµÄ×óÓÒÁ¬½Ó

¶Ô×óÁ¬½Ó¡¢ÓÒÁ¬½ÓµÄÒÉ»óµÃµ½½â¾ö¡£
ÔÚOracle PL-SQLÖУ¬×óÁ¬½ÓºÍÓÒÁ¬½ÓÒÔÈçÏ·½Ê½À´ÊµÏÖ
²é¿´ÈçÏÂÓï¾ä£º
SELECT emp_name, dept_name
FORM Employee, Department
WHERE Employee.emp_deptid(+) = Department.deptid
      ´ËSQLʹÓÃÁËÓÒÁ¬½Ó£¬¼´“(+)”ËùÔÚλÖõÄÁíÒ»²àΪÁ¬½Óµ ......

SQL ServerÖд洢¹ý³ÌÓ뺯ÊýµÄÇø±ð

SQL ServerÓû§×Ô¶¨Ò庯ÊýºÍ´æ´¢¹ý³ÌÓÐÀàËÆµÄ¹¦ÄÜ£¬¶¼¿ÉÒÔ´´½¨À¦°óSQLÓï¾ä£¬´æ´¢ÔÚserverÖй©ÒÔºóʹÓá£ÕâÑùÄܹ»¼«´óµØÌá¸ß¹¤×÷ЧÂÊ£¬Í¨¹ýÒÔϵĸ÷ÖÖ×ö·¨¿ÉÒÔ¼õÉÙ±à³ÌËùÐèµÄʱ¼ä£º
¡¡¡¡ 1 ÖØ¸´Ê¹Óñà³Ì´úÂ룬¼õÉÙ±à³Ì¿ª·¢Ê±¼ä¡£
¡¡¡¡ 2 Òþ²ØSQLϸ½Ú£¬°ÑSQL·±ËöµÄ¹¤×÷Áô¸øÊý¾Ý¿â¿ª·¢ÈËÔ±£¬¶ø³ÌÐò¿ª·¢Ô±Ôò¼¯Öд¦Àí¸ß¼¶±à³Ì ......

SQLÖÐCONVERTת»¯º¯ÊýµÄÓ÷¨

¸ñʽ:
CONVERT(data_type,expression[,style])
˵Ã÷:
´ËÑùʽһ°ãÔÚʱ¼äÀàÐÍ(datetime,smalldatetime)Óë×Ö·û´®ÀàÐÍ(nchar,nvarchar,char,varchar)
Ï໥ת»»µÄʱºò²ÅÓõ½.
Àý×Ó:
SELECT CONVERT(varchar(30),getdate(),101) now
½á¹ûΪ:
now
---------------------------------------
|09/15/2001
===== ......

SQLÖÐµÄ datetime ¸ñʽ[ת]

SQLÖÐµÄ datetime ¸ñʽ[ת]
2009-05-16 10:42
Óï¾ä¼°²éѯ½á¹û£º
SELECT CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AM
SELECT CONVERT(varchar(100), GETDATE(), 1): 05/16/06
SELECT CONVERT(varchar(100), GETDATE(), 2): 06.05.16
SELECT CONVERT(varchar(100), GETDATE(), 3): 16/05/06
SELECT CONV ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ