oracle³£ÓÃÊý¾ÝÀàÐÍ
oracle³£ÓÃÊý¾ÝÀàÐÍ
½ñÌìͬÊÂÎÊЩÊý¾ÝÀàÐ͵ÄÎÊÌ⣬ÓеĻ¹ÕæÓеã¼Ç²»ÇåÁË£¬ÓÚÊǾͼòµ¥×ܽáϳ£ÓõÄÊý¾ÝÀàÐÍÒÔ±¸ÈÕºó²éÓÃ
1¡¢Char
¶¨³¤¸ñʽ×Ö·û´®£¬ÔÚÊý¾Ý¿âÖд洢ʱ²»×ãλÊýÌî²¹¿Õ¸ñ£¬ËüµÄÉùÃ÷·½Ê½ÈçÏÂCHAR(L)£¬LΪ×Ö·û´®³¤¶È£¬
ȱʡΪ1£¬×÷Ϊ±äÁ¿×î´ó32767¸ö×Ö·û£¬×÷ΪÊý¾Ý´æ´¢ÔÚORACLE8ÖÐ×î´óΪ2000¡£²»½¨ÒéʹÓ㬻á´øÀ´²»
±ØÒªµÄÂé·³
a¡¢×Ö·û´®±È½ÏµÄʱºò£¬Èç¹û²»×¢Ò⣨char²»×ãλ²¹¿Õ¸ñ£©»á´øÀ´´íÎó
b¡¢×Ö·û´®±È½ÏµÄʱºò£¬Èç¹ûÓÃtrimº¯Êý£¬ÕâÑù¸Ã×Ö¶ÎÉϵÄË÷Òý¾ÍʧЧ£¨ÓÐʱºò»á´øÀ´ÑÏÖØÐÔÄÜÎÊÌ⣩
c¡¢ÀË·Ñ´æ´¢¿Õ¼ä(ÎÞ·¨¾«×¼¼ÆËãδÀ´´æ´¢´óС£¬Ö»ÄÜÁôÓÐ×ã¹»µÄ¿Õ¼ä£»×Ö·û´®µÄ³¤¶È¾ÍÊÇÆäËùÕ¼ÓÿռäµÄ´óС)
2¡¢Varchar2/varchar
Ä¿Ç°VARCHARÊÇVARCHAR2µÄͬÒå´Ê¡£¹¤Òµ±ê×¼µÄVARCHARÀàÐÍ¿ÉÒÔ´æ´¢¿Õ×Ö·û´®£¬µ«ÊÇoracle²»ÕâÑù×ö£¬¾¡¹ÜËü±£Áô
ÒÔºóÕâÑù×öµÄȨÀû¡£Oracle×Ô¼º¿ª·¢ÁËÒ»¸öÊý¾ÝÀàÐÍVARCHAR2£¬Õâ¸öÀàÐͲ»ÊÇÒ»¸ö±ê×¼µÄVARCHAR£¬Ëü½«ÔÚÊý¾Ý¿âÖÐ
varcharÁпÉÒÔ´æ´¢¿Õ×Ö·û´®µÄÌØÐÔ¸ÄΪ´æ´¢NULLÖµ¡£Èç¹ûÄãÏëÓÐÏòºó¼æÈݵÄÄÜÁ¦£¬Oracle½¨ÒéʹÓÃVARCHAR2¶ø²»ÊÇVARCHAR¡£
²»¶¨³¤¸ñʽ×Ö·û´®£¬ËüµÄÉùÃ÷·½Ê½ÈçÏÂVARCHAR2(L)£¬LΪ×Ö·û´®³¤¶È£¬Ã»ÓÐȱʡֵ£¬×÷Ϊ±äÁ¿×î´ó32767¸ö×Ö½Ú£¬
×÷ΪÊý¾Ý´æ´¢ÔÚORACLE8ÖÐ×î´óΪ4000¡£ÔÚ¶à×Ö½ÚÓïÑÔ»·¾³ÖУ¬Êµ¼Ê´æ´¢µÄ×Ö·û¸öÊý¿ÉÄÜСÓÚLÖµ£¬ÀýÈ磺µ±ÓïÑÔ
»·¾³ÎªÖÐÎÄ(SIMPLIFIED CHINESE_CHINA.ZHS16GBK)ʱ£¬Ò»¸öVARCHAR2(200)µÄÊý¾ÝÁпÉÒÔ±£´æ200¸öÓ¢ÎÄ×Ö·û»òÕß
100¸öºº×Ö×Ö·û£»¶ÔÓÚ4000×Ö½ÚÒÔÄÚµÄ×Ö·û´®£¬½¨Ò鶼ÓøÃÀàÐÍ
a¡£VARCHAR2±ÈCHAR½ÚÊ¡¿Õ¼ä£¬ÔÚЧÂÊÉϱÈCHAR»áÉÔ΢²îһЩ£¬¼´ÒªÏë»ñµÃЧÂÊ£¬¾Í±ØÐëÎþÉüÒ»¶¨µÄ¿Õ¼ä£¬ÕâÒ²¾ÍÊÇÎÒÃÇÔÚÊý¾Ý¿âÉè¼ÆÉϳ£ËµµÄ‘ÒԿռ任ЧÂÊ’¡£
b¡£VARCHAR2ËäÈ»±ÈCHAR½ÚÊ¡¿Õ¼ä£¬µ«ÊÇÈç¹ûÒ»¸öVARCHAR2Áо³£±»Ð޸ģ¬¶øÇÒÿ´Î±»Ð޸ĵÄÊý¾ÝµÄ³¤¶È²»Í¬£¬Õâ»áÒýÆð‘ÐÐǨÒÆ’(Row Migration)ÏÖÏ󣬶øÕâÔì³É¶àÓàµÄI/O£¬ÊÇÊý¾Ý¿âÉè¼ÆºÍµ÷ÕûÖÐÒª¾¡Á¦±ÜÃâµÄ£¬ÔÚÕâÖÖÇé¿öÏÂÓÃCHAR´úÌæVARCHAR2»á¸üºÃһЩ¡£²»¹ýÇø±ðÒ²²»ÊÇÌ«´ó£¬Èç¹û¾ÍÊÇÏëÓÃvarchar2£¬ÄÇôÔÚ·¢ÉúÐÐǨÒÆ£¬¿ÉÒÔͨ¹ýpctfreeÀ´µ÷Õû£¬È»ºó¶Ô±íµÄÊý¾Ý½øÐÐÖØ×é
nchar,nvarchar/nvarchar2¹ú¼Ò×Ö·û¼¯£¬Óë»·¾³±äÁ¿NLSÖ¸¶¨µÄÓïÑÔ¼¯ÃÜÇÐÏà¹Ø
Ö»ÓÐÒªÓõ½unicodeʱ²Å»áÓõ½ÕâЩ¹ú¼Ò×Ö·û¼¯£¬ncharºÍnvarchar2ÒÀ¾ÝËùÑ¡µÄ×Ö·û¼¯À´´æ´¢Êý¾Ý£¬¿ÉÄÜÒ»¸ö×Ö·ûÕ¼Á½¸ö»ò¶à¸ö×Ö½Ú,·ÀÖ¹ÂÒÂë
3¡¢Long/long raw
OracleÒÑ
Ïà¹ØÎĵµ£º
¶ÔÓÚ Oracle µÄ rownum ÎÊÌ⣬ºÜ¶à×ÊÁ϶¼Ëµ²»Ö§³Ö>,>=,=,between...and£¬Ö»ÄÜÓÃÒÔÉÏ·ûºÅ(<¡¢<=¡¢!=)£¬²¢·Ç˵ÓÃ>,>=,=,between..and ʱ»áÌáʾSQLÓï·¨´íÎ󣬶øÊǾ³£ÊDz鲻³öÒ»Ìõ¼Ç¼À´£¬»¹»á³öÏÖËƺõÊÇĪÃûÆäÃîµÄ½á¹ûÀ´£¬ÆäʵÄúÖ»ÒªÀí½âºÃÁËÕâ¸ö rownum αÁеÄÒâÒå¾Í²»Ó¦¸Ã¸Ðµ½¾ªÆ棬ͬÑùÊÇαÁУ¬r ......
ÔÚSQL SERVER 20000ÖзÃÎÊOracleÊý¾Ý¿â·þÎñÆ÷µÄ¼¸ÖÖ·½·¨
1.ͨ¹ýÐм¯º¯Êýopendatasource
ÒªÇó:±¾µØ°²×°Oracle¿Í»§¶Ë
select * from opendatasource('MSDAORA', 'Data Source=XST4;User ID=manager;Password=sjpsjsjs')..MISD.PBCATCOL
ÆäÖУ¬MSDAORAÊÇOLEDB FOR 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] ......
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²éѯµÄ½á¹û´æÈëµ½±äÁ¿ÖУ¬¿ÉÒÔͬʱ½«¶à¸öÁд洢¶à¸ö±äÁ¿ÖУ¬±ØÐëÓÐÒ»Ì ......