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

ORACLEÊý¾Ý¿â±íµÄ²Ù×÷

      ×î½üæÓÚ¹«Ë¾µÄÏîÄ¿¿ª·¢£¬ºÜ¾ÃûÓÐÀ´csdnÁË¡£½ñÌìÎÞÊ£¬ÉÏÀ´Ð´µã¶«Î÷¡£¹©´ó¼Ò²Î¿¼£¬²»¶ÔµÄµØ·½»¹Ï£Íû´ó¼ÒÅúÆÀÖ¸Õý¡£
     Ò»ÏÂÊǶÔoracleÊý¾Ý¿â±íµÄһЩ²Ù×÷Óï¾ä£º
ÒѾ­½¨ºÃµÄ±íÌí¼Ó×Ö¶Î
alter   table   Tablename   add(column1   varchar2(20) default 'Y',column2   number(7,2)...)
ɾ³ý×ֶΣº
alter table Tablename  drop column assessment_methods
Ϊ×Ö¶ÎÌí¼Ó×¢ÊÍ£º
comment on column bill_result.bill_no is 'Ãû´Î';
Ð޸ıíµÄ×Ö¶ÎÃû³Æ
ALTER TABLE table_name   RENAME COLUMN column1 TO column2;
--Ϊ±ítablename1  µÄis_deletedÁÐÌí¼ÓĬÈÏÖµ
alter table tablename1  modify is_deleted default 'N'


Ïà¹ØÎĵµ£º

°²×°ÍêÁËOracleÊý¾Ý¿â£¬¸øscottÕË»§½âËø·½·¨

    ×°ÍêÁËOracle 10gÊý¾Ý¿â£¬ÍüÁ˸øscottÕË»§½âËø¡£Õâʱ¿ÉÒÔÔÚsql plus¹¤¾ßÀ¿ªÊ¼|ËùÓгÌÐò|<Oracle-Home>|Ó¦ÓóÌÐò¿ª·¢|SQL Plus£©£¬Ò²¿ÉÒÔÔÚ¿ØÖÆÌ¨Í¨¹ýÃüÁîÐиøscottÕË»§½âËø¡£
    ÔÚµÚÒ»ÖÖÇé¿öÏ£¬ÒÔsystemÕË»§µÇ¼SQL Plus£¬È»ºóʹÓÃÃüÁî“alter user scott accoun ......

oracleÏÂÔØµØÖ· for linux or windows


Oracle9i Database Release 2 Enterprise/Standard/Personal Edition for Windows NT/2000/XP
http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk1.zip
http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk2.zip
http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk3.zip
Oracle9i ......

[ÍÆ¼ö] Éî¶È¶Ô±ÈOracleÓëSQL Server [1]

±¾ÒëÎIJÉÓÃ֪ʶ¹²ÏíÊðÃû-·ÇÉÌÒµÐÔʹÓÃ-Ïàͬ·½Ê½¹²Ïí 3.0 UnportedÐí¿ÉЭÒé·¢²¼£¬×ªÔØÇë±£Áô´ËÐÅÏ¢
ÒëÕߣºÂí³ÝÜÈ | Á´½Ó£ºhttp://www.dbabeta.com/2010/oracle-sql-server-comparison-i.html
×÷ÕߣºSadequl Hussain | Ô­ÎÄ£ºhttp://www.sql-server-performance.com/articles/dba/oracle_sql_server_comparison_p1.aspx
Ò» ......

½â³ýoracleÊý¾Ý¿âÖÐËùÓÐÍâ¼üÔ¼ÊøSQLÓï¾ä

begin
  for item in (select * from user_constraints a where a.constraint_type = 'R') loop
  execute immediate 'alter table ' || item.table_name || ' disable constraint ' || item.constraint_name;
  end loop;
end;
/ ......

jsp·ÖÒ³£¨oracle+jsp+apache£©

Ò» Ç°Ìá 
Ï£Íû×îеļͼÔÚ¿ªÍ·¸øÄãµÄ±í½¨Á¢²éѯ£º
±í£ºmytable 
²éѯ£ºcreate or replace view as mytable_view from mytable order by id desc ÆäÖУ¬×îºÃʹÓÃÐòÁкÅcreate sequence mytable_sequence À´×Ô¶¯Ôö¼ÓÄãµÄ¼ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ