Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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
ÒÆ¶¯Êý¾Ý¿âÎļþ

OracleÊý¾Ý¿âÓÉÊý¾ÝÎļþ£¬¿ØÖÆÎļþºÍÁª»úÈÕÖ¾Îļþ
ÈýÖÖÎļþ×é³É¡£
ÓÉÓÚ´ÅÅ̿ռäµÄ±ä»¯£¬»òÕß»ùÓÚÊý¾Ý¿â´ÅÅÌI/OÐÔÄܵĵ÷ÕûµÈ£¬ÎÒ們¿ÉÄܻῼÂÇÒÆ¶¯Êý¾Ý¿âÎļþ¡££¨×¢:
»Ö¸´Êý¾Ý¿âʱ·Ç³£
ÓÐÓã¬ÊôÓÚÀ䱸·Ý£©
²éѯµ±Ç°Êý¾Ý¿âÖÐ,Ïà¹ØÎļþ·¾¶

select * from v$datafile;
se ......

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

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

ÈçºÎÔÚOracleÖи´ÖƱí½á¹¹ºÍ±íÊý¾Ý


1. ¸´ÖƱí½á¹¹¼°ÆäÊý¾Ý£º
create table table_name_new as select * from table_name_old
2. Ö»¸´ÖƱí½á¹¹£º
create table table_name_new as select * from table_name_old where 1=2;
»òÕߣº
create table table_name_new like table_name_old
3. Ö»¸´ÖƱíÊý¾Ý£º
Èç¹ûÁ½¸ö±í½á¹¹Ò»Ñù£º
insert into table_name_ ......

[ת]Oracle Ëæ»ú»ñÈ¡NÌõÊý¾Ý


µ±ÎÒÃÇ»ñÈ¡Êý¾Ýʱ,¿ÉÄÜ»áÓÐÕâÑùµÄÐèÇó,¼´Ã¿´Î´Ó±íÖлñÈ¡Êý¾Ýʱ,ÊÇËæ»ú»ñȡһ¶¨µÄ¼Ç¼,¶ø²»ÊÇÿ´Î¶¼»ñȡһÑùµÄÊý¾Ý,ÕâʱÎÒÃÇ¿ÉÒÔ²ÉÈ¡OracleÄÚ²¿Ò»Ð©º¯Êý,À´´ïµ½ÕâÑùµÄÄ¿µÄ.   
  
   1) select * from (select * from tablename order  ......

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ