oracle adoÁ¬½ÓÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí
ÔÚÁ¬½ÓÊý¾ÝԴʱ£¬Êý¾ÝÁ¬½ÓÊôÐÔÖÐÑ¡Ôñoracle provider for ole db
µ¥»÷ÏÂÒ»²½Ê±±¨´í ¡°Ìṩ³ÌÐò²»ÔÙ¿ÉÓã¬ÇëÈ·¶¨Ìṩ³ÌÐò±»ÕýÈ·°²×°¡£¡±
ÎÒÓõÄÊÇoracle 8£¬ÏÈǰÓõÄ10gÒ²Óöµ½ÀàËÆµÄÎÊÌâ
ʹÓÃmicrosoft ole db provider for oracleʱÏÔʾµÄ·þÎñÆ÷Ãû³ÆÊÇ×Ô¶¨ÒåµÄÂð£¿ÎªÊ²Ã´ÎҵϹÊDZ¨´í
Çë´ó¼Ò°ï°ïæлл
°ï¶¥£¡
Ö±½Ó´úÂëÖÐд#import ¡£¡£¡£¡£¡£¡£
ÎÒµÄÁ¬½ÓÊÇн¨Ò»¸öÎı¾Îĵµ£¬È»ºóÐ޸ĺó׺ÃûΪ¡°.uld ¡±
½¨Á¢µÄÊý¾ÝÔ´
ÄÜÔÚ¾ßÌåÒ»µãÂ𣿣¿£¿
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......
ÎÒÒª¸ñʽ»¯Êý×Ö1£¬ÎÒµÄλÊýÊÇÒ»¸ö±äÁ¿n£¬
ÀýÈçn=3ʱ to_char(1,'FM099') ÎÒ²»ÖªµÀÔõôÓÃÄǸö±äÁ¿nÈ¥Ìæ»»ÄǼ¸¸ö9
û¿´¶® replaceô
ÊǵÄÒýÓÃ
û¿´¶® replaceô
replace('FM099','9','ÏëÌæ»»³Éµ ......