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

oracle »ù´¡ ¿ØÖÆ»ú¹¹+¸³Öµ

   --±äÁ¿¸³Öµ
   declare
   identity :=0;
   a varchar2(59,0);
   b varchar2(50):='abc';
   a :='cba';
  
   -- ¿ØÖÆÓï¾ä
   ----------------------------------
   if a>b then
       .........
   end if;
   ------------------------------------
   if a>b then
      .....
    else
       .....
    end if;
   -----------------------------------
   if a>b then
       ........
    elsif c>b then
       ........
    else
       ..........
    end if;
    -----------------------------------
    case variable
         when 'tt' then 'value1'
         when 'mm' then 'value2'
         when 'nn' then 'value3'
         else value4
    end;
    --------------------------------------
    while t<10000000 loop
        ........;
    end loop;
   
    --------------------------------------
    for 1_counter in 1-10
    loop
        statements;
    end loop;
    ---------------------------------------
     for 1_counter in reverse 1..10
    loop
        statements;
    end loop;
  


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

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

OracleÖØ×öÈÕÖ¾Îļþ³£ÓòÙ×÷

Ç¿ÖÆÇл»ÖØ×öÈÕÖ¾
ALTER SYSTEM SWITCH LOGFILE; Ç¿ÖÆ²úÉú¼ì²éµã
ALTER SYSTEM CHECKPOINT; ¼ä½Ó²úÉú¼ì²éµã(É趨ʵÀý»Ö¸´Ê±¼ä²»³¬¹ýmmÃë,Ò༴ִÐмì²éµãÖ®ºóÔËÐг¬¹ýÕâ¸öʱ¼ä¾ÍÔÙ´ÎÖ´Ðмì²éµã)
ALTER SYSTEM SET FAST_START_MTTR_TARGET = ÃëÊý; »ñÈ¡ÖØ×öÈÕÖ¾ÎļþÐÅÏ¢
SELECT group#, ......

ORACLE 10g Öлָ´ÒÑɾ³ýµÄ±í_flashback


-- ±Ê¼ÇÖв¿·ÖÄÚÈÝ
SQL> create table tt2 as select * from employee;
Table created.
SQL> drop table tt2;
Table dropped.
SQL> select * from tt2;
select * from tt2
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> flashback table tt2 to before drop;
Flashback comp ......

ORACLE ±í¿Õ¼ä²Ù×÷×ܽá

oracle±í¿Õ¼ä²Ù×÷Ïê½â
Ò»¡¢½¨Á¢±í¿Õ¼ä
CREATE TABLESPACE data01
DATAFILE '/oracle/oradata/db/DATA01.dbf' SIZE 500M
UNIFORM SIZE 128k;
¶þ¡¢½¨Á¢UNDO±í¿Õ¼ä
CREATE UNDO TABLESPACE UNDOTBS02
DATAFILE '/oracle/oradata/db/UNDOTBS02.dbf' SIZE 50M
#×¢Ò⣺ÔÚOPEN״̬ÏÂijЩʱ¿ÌÖ»ÄÜÓÃÒ»¸öUNDO±í¿Õ¼ä£¬Èç¹ûÒ ......

OracleÊý¾Ýµ¼³öµ½DBFµÄÎÊÌâ

 OracleÊý¾Ýµ¼³öºÜ¼òµ¥£¬µ«ÎªÁËÌá¸ßËÙ¶È£¬ÎÒÒ»°ã²»Ö±½Óµ¼³ö³ÉDBF£¬¶øÊÇÏȵ¼³ö³ÉCSV¸ñʽµÄÎı¾Îļþ¡£
½ñÌì¾ÍÓöµ½Ò»¸öÎÊÌ⣬µ¼³öµÄcsvÔÚת»»³Édbfʱ³öÏÖÁ˺ܶà¿ÕÐС£¾­¹ý²éÕÒÎÊÌ⣬·¢ÏÖÊÇ×Ö¶ÎÖк¬Óл»Ðзûµ¼Ö¡£
ʹÓÃ
select Replace(zsyj,chr(13)||chr(10),'')  as SXPD  from TableName
½â¾öÎÊÌâ¡£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ