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
Ïà¹ØÎĵµ£º
decodeº¯Êý
Óï·¨£º
decode(expr,search,result[,search,result]..[,search,result][,default])
½âÊÍ£º
±È½ÏexprÓëÿ¸ösearchµÄÖµ£¬Èç¹ûexprµÈÓÚij¸ösearch£¬Ôò·µ»ØÏàÓ¦µÄresult£»Èç¹ûûÓÐÆ¥ÅäµÄÖµ£¬Ôò·µ»ØdefaultÖµ£»Èç¹ûûÓÐÖ¸¶¨defaultÖµ£¬Ôò·µ»Ønull
×¢Ò⣺
±È½ÏÇ°£¬Oracle×Ô¶¯½«exprµÄÊý¾ÝÀàÐÍת»»³ÉµÚÒ»¸ösear ......
Ò»¡¢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] ......
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 ......
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 ......
1.»ù±¾½á¹¹
CREATE OR REPLACE PROCEDURE ´æ´¢¹ý³ÌÃû×Ö
(
²ÎÊý1 IN NUMBER,
²ÎÊý2 IN NUMBER
) IS
±äÁ¿1 INTEGER :=0;
±äÁ¿2 DATE;
BEGIN
END ´æ´¢¹ý³ÌÃû×Ö
2.SELECT INTO STATEMENT
½«select²éѯµÄ½á¹û´æÈëµ½±äÁ¿ÖУ¬¿ÉÒÔͬʱ½«¶à¸öÁд洢¶à¸ö±äÁ¿ÖУ¬±ØÐëÓÐÒ»Ì ......