oracle ±í½á¹¹µÄÐÞ¸Ä
¸ü¸Ä±íµÄ½á¹¹
1.±à¼±íµÄ×Ö¶Î
ÐÞ¸ÄÒ»¸öÁеÄÊý¾ÝÀàÐÍ(Ò»°ãÏÞÓÚÐ޸ij¤¶È£¬ÐÞ¸ÄΪһ¸ö²»Í¬ÀàÐÍʱÓÐÖî¶àÏÞÖÆ):
Óï·¨:
ALTER TABLE ±íÃû MODIFY(ÁÐÃû Êý¾ÝÀàÐÍ);
eg1:
alter table skate_test modify (author number(10,0) )
ÔÚÐÞ¸ÄÁеij¤¶Èʱºò,Ö»Äܱ༱ÈÏÖÓÐ×Ö¶Îʵ¼Ê´æµÄ³¤¶È»¹Òª´ó,·ñÔòÌáʾÏÂÃæµÄ´íÎó:
ORA-01441: ÎÞ·¨¼õСÁ㤶È, ÒòΪһЩֵ¹ý´ó
eg2:
alter table skate_test modify (author varchar2(10) )
ÔÚÐÞ¸ÄÁеÄÊý¾ÝÀàÐ͵Äʱºò,ËùÐ޸ĵÄÁбØÐëΪ¿Õ,·ñÔòÌáʾÏÂÃæµÄ´íÎó:
ORA-01439: Òª¸ü¸ÄÊý¾ÝÀàÐÍ, ÔòÒªÐ޸ĵÄÁбØÐëΪ¿Õ
2.Ôö¼ÓÒ»¸öÁÐ
Óï·¨:
ALTER TABLE ±íÃû ADD(ÁÐÃû Êý¾ÝÀàÐÍ);
eg1£º
ALTER TABLE skate_test ADD(author NUMBER(38,0) not null);
3.¸øÁиÄÃû£º
Óï·¨:
ALTER TABLE ±íÃû RENAME COLUMN µ±Ç°ÁÐÃû TO ÐÂÁÐÃû;
eg1£º
ALTER TABLE skate_test RENAME COLUMN author TO authorer_new
4.ɾ³ýÒ»¸öÁÐ
Óï·¨:
ALTER TABLE ±íÃû DROP COLUMN ÁÐÃû;
eg1£º
alter table skate_test drop column author
5.½«Ò»¸ö±í¸ÄÃû
Óï·¨:
ALTER TABLE µ±Ç°±íÃû RENAME TO бíÃû;
eg1£º
alter table skate_test rename to test_sakte
5.¸ø±í¼Ó×¢ÊÍ
comment column on ±íÃû.ÁÐÃû is '×¢ÊÍÄÚÈÝ'; //Ð޸ıíµÄÁеÄ×¢ÊÍ
COMMENT ON TABLE MOVO_NEW.TEST_SAKTE IS '×¢ÊÍÄÚÈÝ'; //Ð޸ıíµÄ×¢ÊÍ
--- ´ýÐø---
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
SQLÊÇÓÃÓÚ·ÃÎÊORACLEÊý¾Ý¿âµÄÓïÑÔ£¬PL/SQLÀ©Õ¹ºÍ¼ÓÇ¿ÁËSQLµÄ¹¦ÄÜ£¬Ëü ͬʱÒýÈëÁ˸üÇ¿µÄ³ÌÐòÂß¼¡£ PL/SQLÖ§³ÖDMLÃüÁîºÍSQLµÄÊÂÎñ¿ØÖÆÓï¾ä¡£DDLÔÚPL/SQLÖв»±»Ö§³Ö£¬Õâ¾ÍÒâζ×÷ÔÚPL/SQL³ÌÐò¿éÖв»ÄÜ´´½¨±í»òÆäËûÈκζÔÏ󡣽Ϻà µÄPL/SQL³ÌÐòÉè¼ÆÊÇÔÚPL/SQL¿éÖÐʹÓÃÏóDBMS_SQLÕâÑùµÄÄÚ½¨°ü»òÖ´ÐÐEXECUTE IMMEDIATEÃüÁÁ¢¶¯Ì ......
1.¿Í»§¶ËÁ¬½ÓÖÁoralce:
Ê×Ïȿͻ§¶ËÁ¬½ÓÖÁoracleµÄ¼àÌýÆ÷,È»ºó¼àÌýÆ÷·ÖÅäÒ»¸öÊý¾Ý¿âʵÀý(ÕâÀïµÄÊÇʵÀý)¸ø¿Í»§¶Ë,È»ºó¿Í»§¶ËÒÔºó¾ÍÖ±½ÓÓëÕâ¸öÊý¾Ý¿âʵÀý½øÐÐÁ¬½Ó,Ö±ÖÁ¶Ï¿ªÓëoracleµÄÁ¬½Ó.
2.Ìá½»sql:
(1)¿Í»§¶ËÓû§Ìá½»Ò»¸ösql ......
¡¡¡¡OracleÊý¾Ý¿âÖУ¬±íÊÇ×î»ù±¾µÄÄÚÈÝ¡£¿ÉÒÔ˵£¬±íÉè¼ÆµÄºÃ»µÖ±½Ó¸úÊý¾Ý¿âµÄÐÔÄÜÏà¹Ø¡£ËùÒÔ£¬ÔÚÉè¼Æ±íµÄʱºò£¬³ýÁËÒª×ñÑÆä¹ÌÓеÄÊý¾Ý¿â×¼ÔòÖ®Í⣬»¹ÐèÒª¿´¸öÈ˵ÄÊý¾Ý¿â¹ÜÀí¾Ñé¡£ÏÂÃæÎҾͰÑÕâЩ¾Ñé·ÖÏíһϣ¬»òÐí¶Ô´ó¼ÒÓÐËù°ïÖú¡£
¡¡¡¡Ò»¡¢ ±í¸Ã´æ·ÅÔÚÄÄÀï?
¡¡¡¡ÎÒÃǶ¼ÖªµÀ£¬ÔÚOracleÊý¾Ý¿âÖУ¬Ê¹ÀûÓÿռäÕâ¸ö¸ÅÄîÀ´¹Ü ......