oracle¿ª·¢µÄÏà¹ØÎÊÌâ - Oracle / ¿ª·¢
×öOracleÊý¾Ý¿â¿ª·¢µÄ´óÏÀÄÜ˵˵Oracle¿ª·¢µÄÖ÷Òª¹¤×÷ÒÔ¼°Ïà¹Ø¹¤¾ßÂð£¿
ÒªÊÇÏë×öºÃOracle¿ª·¢Ó¦¸Ã¾ß±¸Ê²Ã´ÄÜÁ¦ÄØ£¿
лл£¬Ï£Íû´ó¼ÒÓ»Ô¾ÌÖÂÛ£¡
Õâ¸öÎÊÌâºÃÏñÖ»ÄÜ×öÕâ¸öµÄ²ÅÖªµÀÁË¡£¡£¡£°ïlz¶¥¡£¡£¡£ºÙºÙ¡£¡£
˳±ãת¸öÐÁ¿à·Ö¡£¡£¡£¡£ºÇºÇ¡£¡£
ÓëÊý¾Ý¿âÏà¹ØµÄ¹¤×÷£º³ÌÐòÔ±¡¢dbaµÈ
Ïà¹Ø¹¤¾ß£ºsqlplus¡¢pl/sql developer¡¢toad¡¢powerdesigner......
ÄÜÁ¦£ºÐèÒªÒ»¶¨µÄ×ÔѧÄÜÁ¦£¬¼á³Ö²»Ð¸
ÎҵŤ×÷Ò»°ã¾ÍÊÇд´æ´¢¹ý³Ì£¬ÓÅ»¯SQL£¬ºÍÊý¾ÝЧÑéÖ®ÀàµÄ¡£
ÎÒÓõÄÊÇPL/SQL DEV£¬ÓÐЩÈËϲ»¶ÓÃTOAD¡£
Òª»ù±¾¾ß±¸µÄÄÜÁ¦¾ÍÊÇÄÜдƯÁÁµÄSQLÓï¾ä£¬»¹Òª»á¿´Ö´Ðмƻ®µÈµÈ¡£
ÔÚÉϰ࣬û¶àÏ룬ÏÂÃæ¼ÌÐø²¹³ä
Ïà¹ØÎÊ´ð£º
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......
ÎÒ°²×°ÁËoracle 10g¾¹ýÒ»·¬Å¬Á¦Äܹ»Ë³ÀûµÄÁ¬½ÓÉÏÁË£¬
µ«ÊÇÎÒÒÔǰÓõÄÊÇsql server ËûµÄÆóÒµ¹ÜÀíÆ÷ÖÐÄÜ¶Ô±í½øÐпÉÊÓ»¯¹ÜÀí
ÔÚoracleÖÐÎÒÒ²¿´µ½ÁËÓпÉÊÓ»¯µÄem
µ«ÊÇÎÒ¾ÍÊÇ¿´²»µ½±íµÄÄÚÈÝÀ´
ÇëÎÊÓÐûÓдóϺÄܰï°ïà ......
¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......
java.sql.SQLException: Io Òì³£: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186646784)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBErro ......