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

oracle ±í½á¹¹µÄÐÞ¸Ä

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 '×¢ÊÍÄÚÈÝ';  //Ð޸ıíµÄ×¢ÊÍ
±¾ÎÄÀ´×ÔCSDN²©¿Í£¬×ªÔØÇë±êÃ÷³ö´¦£ºhttp://blog.csdn.net/wyzxg/archive/2008/02/28/2129166.aspx


Ïà¹ØÎĵµ£º

´«ÖDz¥¿Í——Êý¾Ý¿âÖ®ORACLE£¨Ò»£©


Ò» Oracle¹«Ë¾¼ò½é 
OracleÊÇÒóÐæ³öÍÁµÄ¼×¹ÇÎÄ(oracle bone inscriptions)µÄÓ¢ÎÄ·­ÒëµÄµÚÒ»¸öµ¥´Ê
Oracle¹«Ë¾ÊÇÈ«Çò×î´óµÄÐÅÏ¢¹ÜÀíÈí¼þ¼°·þÎñ¹©Ó¦ÉÌ£¬³ÉÁ¢ÓÚ1977Ä꣬×ܲ¿Î»ÓÚÃÀ¹ú¼ÓÖÝ Redwood shore
Oracle¹«Ë¾ÒòÆ临ÔӵĹØϵÊý¾Ý¿â²úÆ·¶øÎÅÃû¡£OracleµÄ¹ØϵÊý¾Ý¿âÊÇÊÀ½çµÚÒ»¸öÖ§³ÖSQLÓïÑÔµÄÊý¾Ý¿â
OracleÔÚ³¬¹ý ......

JavaÓïÑÔÈçºÎ·ÃÎʲ»Í¬×Ö·û¼¯µÄOracleÊý¾Ý

Ò»¡¢java·ÃÎÊÖÐÎÄOracleÊý¾Ý¿âÉÏÁ¬½ÓµÄUS7ASCIIÊý¾Ý¿â
1¡¢¶Á·½·¨
public String convertLink_DB(String s) {
  if(s != null){
   try{
    byte[] b = s.getBytes();
    for(int i=0; i<b.length; i++){
     b[i] ......

oracle ´æ´¢¹ý³ÌµÄ»ù±¾Óï·¨

1.»ù±¾½á¹¹
CREATE OR REPLACE PROCEDURE ´æ´¢¹ý³ÌÃû×Ö
(
    ²ÎÊý1 IN NUMBER,
    ²ÎÊý2 IN NUMBER
) IS
±äÁ¿1 INTEGER :=0;
±äÁ¿2 DATE;
BEGIN
END ´æ´¢¹ý³ÌÃû×Ö
2.SELECT INTO STATEMENT
  ½«select²éѯµÄ½á¹û´æÈëµ½±äÁ¿ÖУ¬¿ÉÒÔͬʱ½«¶à¸öÁд洢¶à¸ö±äÁ¿ÖУ¬±ØÐëÓÐÒ»Ì ......

¸¶Ê×ê¿ ORACLE 10 ѧϰ±Ê¼Ç µÚ3¿Î ÃüÁî¡£

ORACLE 10 ѧϰ±Ê¼Ç-µÚ3¿Î-ÃüÁî¡£
1.view ÏÞÖÆ
create or replace view my_view01
as select * from emp
with check option
/
2.synonym ͬÒå´Ê
create synonym dept for scott.dept;
select * from dept;
3.sysdba ¹«¹²
drop synonym dept;
create public synonym dept for scott.dept;
desc dba_synonyms
......

¡¾×ª¡¿ ORACLE ·ÖÇø±í PARTITION table

ORACLE ·ÖÇø±í PARTITION table
http://blog.chinaunix.net/u/6889/showart_315897.html
1.1 ·ÖÇø±íPARTITION table
ÔÚORACLEÀïÈç¹ûÓöµ½Ìرð´óµÄ±í£¬¿ÉÒÔʹÓ÷ÖÇøµÄ±íÀ´¸Ä±äÆäÓ¦ÓóÌÐòµÄÐÔÄÜ¡£
1.1.1 ·ÖÇø±íµÄ½¨Á¢£º
ij¹«Ë¾µÄÿÄê²úÉú¾Þ´óµÄÏúÊۼǼ£¬DBAÏò¹«Ë¾½¨Òéÿ¼¾¶ÈµÄÊý¾Ý·ÅÔÚÒ»¸ö·ÖÇøÄÚ£¬ÒÔÏÂʾ·¶µÄÊǸù«Ë¾1 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ