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'
Ïà¹ØÎĵµ£º
£¨1£©oracleÊý¾Ý¿â±¸·ÝµÄµ¼Èë¶ÔÊý¾Ý¿âµÄ°æ±¾ÓÐÒªÇó£¬Ò²¼´Ô´Êý¾Ý¿â£¨µ¼³ö²úÉú±¸·ÝµÄÊý¾Ý¿â£©µÄ°æ±¾ÒªºÍÄ¿±êÊý¾Ý¿â£¨µ¼ÈëÊý¾Ý¿â£©µÄ°æ±¾Ò»Ö£¬·ñÔò¿ÉÄܵ¼Öµ¼Èëʧ°Ü¡£
£¨2£©±¸·ÝÖеÄÓû§Ãû£¨Êý¾Ý¿âµ¼³öʱËùʹÓõÄÓû§£©ºÍµ¼ÈëÊý¾Ý¿âµÄÓû§Ãû×îºÃÒ»Ñù£¬ÒòΪÓû§ÃûºÍ±í¿Õ¼äÃüÃûÓйØÏµ£¬Èç¹û²»Ò»Ñù£¬µ¼Èë¾Í²»ÄÜÒ»´ÎÍê³É¡£Ò²¾ÍÊÇ ......
×î½üÔÚÒ»¸öÂÛ̳ÖкÍÈËÌÖÂÛÁËһͨ¹ØÓÚORACLEѧϰµÄÎÊÌ⣬½áºÏÎÒÒ²ËãÓÐ10ÄêµÄORALCE ʹÓÃѧϰµÄ¾Àú¸ø´ó¼ÒÒ»µã½¨Òé°É¡£
1¡¢ORACLEÊý¾Ý¿âÊÇÒ»¸ö·Ç³£ÅӴ󣬷dz£¾«ÉîµÄϵͳ£¬ÒªÓг¤ÆÚ¿¹Õ½µÄ×¼±¸£¬ÄãÖ¸ÍûÄÜÔÚÒ»¸öÔÂÄÚѧ»áÈëÃÅÄÇÊÇ¿ÉÒԵ쬵«ÊÇÄãÒªÂò±¾24Ì쾫ͨORACLEÊý¾Ý¿âÕâÑù²»¸ºÔðÔðÈεÄÊ飬²¢Ïëͨ¹ýËûÀ´ÕÆÎÕORACLE£¬Ö»ÄÜÊÇ³Õ ......
OracleÓëMySQLÖГ¿É´®Ðл¯”µÄ¶Ô±È²âÊÔ
Thomas Kyte ÔÚ“Oracle 9i&10g±à³ÌÒÕÊõ”Ò»ÊéÖÐΪÁË˵Ã÷ÊÂÎñµÄ¸ôÀë¼¶±ð£¬ÌṩÁËһЩÀý×Ó¡£ÕâÀïÎÒÃÇÀ´¿´¿´“¿É´®Ðл¯”¼¶±ðϵıíÏÖ¡£
ÒÔÆÕͨÓû§µÇ¼ϵͳ£¬²¢´´½¨²âÊÔÓÃµÄ±í¡£
idle> connect scott/tiger
......
ÏîÄ¿ÖÐÓÐÉæ¼°´æ´¢¹ý³Ì¶Ô×Ö·û´®µÄ´¦Àí£¬ËùÒԾͽ«ÔÚÍøÉϲéÕÒµ½µÄ×ÊÁÏ»ã×Ü£¬×öÒ»¸öÐÅϢƴ½ÓʽµÄ×ܽᡣ
ÒÔÏÂÐÅÏ¢¾ùÀ´×Ô»¥ÁªÍø£¬Ìù³öÀ´Ò»Ôò×Ô¼º±£´æÒÔ´ýÒÔºóʹÓã¬Ò»Ôò¹©´ó¼Ò·ÖÏí¡£
×Ö·ûº¯Êý——·µ»Ø×Ö·ûÖµ
ÕâЩº¯ÊýÈ«¶¼½ÓÊÕµÄÊÇ×Ö·û×åÀàÐ͵IJÎÊý(CHR³ýÍâ)²¢ÇÒ·µ»Ø×Ö·ûÖµ.
³ýÁËÌØ±ð˵Ã÷µÄÖ®Íâ,ÕâЩº¯Êý´ó²¿·Ö·µ» ......