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

ORACLE×ÔÔö³¤×Ö¶ÎʵÏÖ

Ê×ÏÈ£¬ÄãÒªÓÐÒ»ÕÅ±í£¡
        CREATE TABLE example(
              ID Number(4) NOT NULL PRIMARY KEY,
              NAME VARCHAR(25),
              PHONE VARCHAR(10),
              ADDRESS VARCHAR(50)
           );
      È»ºó£¬ÄãÐèÒªÒ»¸ö×Ô¶¨ÒåµÄsequence
      CREATE SEQUENCE emp_sequence
           INCREMENT BY 1 -- ÿ´Î¼Ó¼¸¸ö
           START WITH 1 -- ´Ó1¿ªÊ¼¼ÆÊý
           NOMAXVALUE -- ²»ÉèÖÃ×î´óÖµ
           NOCYCLE -- Ò»Ö±ÀÛ¼Ó£¬²»Ñ­»·
           NOCACHE -- ²»½¨»º³åÇø
      ÒÔÉÏ´úÂëÍê³ÉÁËÒ»¸öÐòÁÐ(sequence)µÄ½¨Á¢¹ý³Ì,Ãû³ÆÎªemp_sequence,·¶Î§ÊÇ´Ó1¿ªÊ¼µ½ÎÞÏÞ´ó(ÎÞÏÞ´óµÄ³Ì¶ÈÊÇÓÉÄã»úÆ÷¾ö¶¨µÄ),nocycle ÊǾö¶¨²»Ñ­»·,Èç¹ûÄãÉèÖÃÁË×î´óÖµÄÇôÄã¿ÉÒÔÓÃcycle »áʹseqµ½×î´óÖ®ºóÑ­»·.¶ÔÓÚnocache˳±ã˵һÏÂÈç¹ûÄã¸ø³öÁËcacheÖµÄÇôϵͳ½«×Ô¶¯¶ÁÈ¡ÄãµÄcacheÖµ´óС¸öseq
,ÕâÑùÔÚ·´¸´²Ù×÷ʱ»á¼Ó¿ìÔËÐÐËÙ¶È,µ«Èç¹ûÔâÓöÒâÍâÇé¿öÈçµ±»úÁË»òoracleËÀÁË,ÔòÏ´ÎÈ¡³öµÄseqÖµ½«ºÍÉϴεIJ»Á¬¹á.(Èç¹ûÁ¬²»Á¬¹áÎÞËùν½¨ÒéÓÃcache,ÒòΪʱ¼ä¾ÍÊǽðǮѽ!ÅÜÌâÁË£¡)
      Êé½ÓÉÏÎÄ£¬ÄãÖ»ÓÐÁ˱íºÍÐòÁл¹²»¹»£¬»¹ÐèÒªÒ»¸ö´¥·¢Æ÷À´Ö´ÐÐËü£¡´úÂëÈçÏ£º
      CREATE TRIGGER "´¥·¢Æ÷Ãû³Æ" BEFORE
           INSERT ON example FOR EACH ROW WHEN (new.id is null)
       begin
    &nbs


Ïà¹ØÎĵµ£º

´óÐÍÊý¾Ý¿âÓÅ»¯Éè¼ÆÇ³Ì¸(ORACLE) £¨Ò»£©

  
   ¶ÔÓÚORACLEÊý¾Ý¿âµÄÊý¾Ý´æÈ¡£¬Ö÷ÒªÓÐËĸö²»Í¬µÄµ÷Õû¼¶±ð£¬µÚÒ»¼¶µ÷ÕûÊDzÙ×÷ϵͳ¼¶°üÀ¨Ó²¼þƽ̨,µÚ¶þ¼¶µ÷ÕûÊÇORACLE RDBMS¼¶µÄµ÷Õû,µÚÈý¼¶ÊÇÊý¾Ý¿âÉè¼Æ¼¶µÄµ÷Õû,×îºóÒ»¸öµ÷Õû¼¶ÊÇSQL¼¶¡£Í¨³£ÒÀ´ËËļ¶µ÷Õû¼¶±ð¶ÔÊý¾Ý¿â½øÐе÷Õû¡¢ÓÅ»¯£¬Êý¾Ý¿âµÄÕûÌåÐÔÄÜ»áµÃµ½ºÜ´óµÄ¸ÄÉÆ¡£ÏÂÃæ´Ó¼¸¸ö²»Í¬·½Ã ......

oracleµÄ´æ´¢¹ý³ÌºÍÓαê


OracleÖеĴ洢¹ý³ÌºÍÓαê:
select myFunc(²ÎÊý1,²ÎÊý2..) to dual; --¿ÉÒÔÖ´ÐÐһЩҵÎñÂß¼­
Ò»:OracleÖеĺ¯ÊýÓë´æ´¢¹ý³ÌµÄÇø±ð:
A:º¯Êý±ØÐëÓзµ»ØÖµ,¶ø¹ý³ÌûÓÐ.
B:º¯Êý¿ÉÒÔµ¥¶ÀÖ´ÐÐ.¶ø¹ý³Ì±ØÐëͨ¹ýexecuteÖ´ÐÐ.
C:º¯Êý¿ÉÒÔǶÈëµ½SQLÓï¾äÖÐÖ´ÐÐ.¶ø¹ý³Ì²»ÐÐ.
ÆäʵÎÒÃÇ¿ÉÒÔ½«±È½Ï¸´ÔӵIJéѯд³Éº¯Êý.È»ºóµ½´æ´¢¹ý³Ì ......

ORACLE to_charº¯ÊýÏê½â


The following are number examples for the to_char
function.
to_char
(1210.73,
'9999.9')
would return '1210.7'
to_char
(1210.73,
'9,999.99')
would return '1,210.73'
to_char
(1210.73,
'$9,999.00')
would return
'$1,210.73'
to_char
(21,
'000099')
would return '000021'
The foll ......

ÈçºÎ½â¾ö¾ÖÓòÍøÖÐWindows·À»ðǽ²»ÄÜ·ÃÎÊOracleÎÊÌâ!


Èç¹ûÄãÊÇWINXP»òWIN2003µÄϵͳÖÐ×Ô´øµÄ·À»ðǽ,¿ÉÒÔÊÔÒ»ÏÂÒÔÏ·½·¨:
1.ÔÚ·À»ðǽµÄÀýÍâÖÐ,Ìí¼ÓORACLE.EXEÔËÐгÌÐò.(ÔÚoracle°²×°Ä¿Â¼ÕÒµ½binÎļþ¼ÐÖÐ)
2.ÔÙÔÚ·À»ðǽÀýÍâÖУ¬Ìí¼Ó¶Ë¿Ú1521¶Ë¿Ú¾ÍÑù¾ÖÓòÍøÄ򵀮äËû»úÆ÷¾Í¿ÉÒÔ·ÃÎÊÄãµÄORACLEÁË.
»òÕßÔڸ߼¶ÖÐ,Ñ¡Öе±Ç°Ê¹ÓõÄÍø¿¨,Ìí¼ÓIP,¶Ë¿ÚºÅ(1521),ÕâÑù,ÆäËû»úÆ÷Ò²¿ÉÒÔ·ÃÎ ......

Oracle 11g °²×°


¶ÔÓÚOracle£¬±ÊÕßÒ²ÊÇÒ»¸ö³õѧÕߣ¬ÈçÎÄÕÂÖеIJ»×ãÖ®´¦»¹Çë¸÷Î»ÍøÓÑÖ¸Õý
     ÏÂÃæÎÒÃÇ¿ªÊ¼°²×°Oracle£¬ÔÚ°²×°Ö®Ç°£¬ÎÒÃÇÏÈÀ´ÁгöһЩÔÚ°²×°OracleÊý¾Ý¿âʱÐèҪעÒâµÄÊÂÏOracle°²×°³ÌÐò£¨OUI£©²»Ö§³Ö×Ö·û½çÃæ°²×°£¬Òò´Ë°²×°·þÎñÆ÷±ØÐëÓÐX windowsÖ§³Ö ÏÂÃæÊÇÎÒ°²×°OracleÊý¾Ý¿âµÄϵͳÐÅÏ¢
²Ù×÷ϵ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ