Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

Oracle Decodeº¯ÊýʹÓü¼ÇÉ


decodeº¯Êý
Óï·¨£º
decode(expr,search,result[,search,result]..[,search,result][,default])
½âÊÍ£º
±È½ÏexprÓëÿ¸ösearchµÄÖµ£¬Èç¹ûexprµÈÓÚij¸ösearch£¬Ôò·µ»ØÏàÓ¦µÄresult£»Èç¹ûûÓÐÆ¥ÅäµÄÖµ£¬Ôò·µ»ØdefaultÖµ£»Èç¹ûûÓÐÖ¸¶¨defaultÖµ£¬Ôò·µ»Ønull
×¢Ò⣺
±È½ÏÇ°£¬Oracle×Ô¶¯½«exprµÄÊý¾ÝÀàÐÍת»»³ÉµÚÒ»¸ösear ......

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] ......

SQLServerºÍOracleµÄ³£Óú¯Êý¶Ô±È

1.¾ø¶ÔÖµ
S:select abs(-1) value
O:select abs(-1) value from dual
2.È¡Õû(´ó)
S:select ceiling(-1.001) value
O:select ceil(-1.001) value from dual
3.È¡Õû£¨Ð¡£©
S:select floor(-1.001) value
O:select floor(-1.001) value from dual
4.È¡Õû£¨½ØÈ¡£©
S:select cast(-1.002 as int) value
O:selec ......

¶ÔoracleÊý¾Ý¿âÖÐCLOB×ֶεÄÏà¹Ø²Ù×÷


import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
 * ´Ë´¦²åÈëÀàÐÍ˵Ã÷¡£
 * ´´½¨ÈÕÆÚ£º(2001/11/30 14:55 ......

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²éѯµÄ½á¹û´æÈëµ½±äÁ¿ÖУ¬¿ÉÒÔͬʱ½«¶à¸öÁд洢¶à¸ö±äÁ¿ÖУ¬±ØÐëÓÐÒ»Ì ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ