ÇëÎÊÏÂѧϰoracleµÄ²½Ö裡
ÇëÎÊÏÂѧϰoracleµÄ²½Ö裬×îºÃÄܹ»ÍƼöϺõãµÄÊéŶ£¡£¡ÊDz»ÊÇÏȰÑlinuxѧºÃÔÙѧ£¿£¿Âé·³¸÷λ°ïÖúСµÜÒ»ÏÂŶ£¡Å¶£¡£¡Ð»Ð»ÁËŶ£¡
ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ£¨µÚËİ棩¡· Íõɺ ÈøÊ¦ìÓ ¸ßµÈ½ÌÓý³ö°æÉç (ÕÆÎÕ»ù´¡ÖªÊ¶ºÍ¸ÅÄî)
È»ºóÔÙ´ÖÂÔä¯ÀÀÒ»±éoracleµÄ¹Ù·½Êֲᡣ£¨·½±ãÒÔºó²éÕÒ£¬±ÜÃâÀàËÆÓÚ¿¼ÊÔµÄʱºò£¬¸øÄã±¾ÕþÖÎÊéÒ²²»ÖªµÀ´ð°¸ÔÚµÚ¼¸Õ£¬µÚ¼¸Ò³£©
¿ª·¢»¹ÊÇά»¤£¿
¿ª·¢µÄ»°£¬¿´µãSQL Ïà¹Ø´óµÄÊ飬¶à¶¯ÊÖʵ¼ù¡£
ά»¤µÄ»°£º
1. ²»Í¬Æ½Ì¨µÄ°²×°£¬Éý¼¶
2. ±¸·ÝÓë»Ö¸´£¬Âß¼±¸·Ý£¬ÎïÀí±¸·Ý£¬RMAN±¸·Ý£¬Êý¾Ý°áǨ
3. Êý¾Ý¿âµÄһЩ»ù±¾²Ù×÷£¬±í£¬±í¿Õ¼ä£¬Êý¾ÝÎļþ£¬¿ØÖÆÎļþ
4. ¸ß¿ÉÓÃÐÔ£¬Data Gurad£¬RAC
4. ÐÔÄܵ÷ÓÅ
¿ÉÒԲο¼ÎÒµÄblog, ÊÇÎÒѧϰOracle һ·×ܽá³öÀ´µÄ¹ý³Ì¡£
------------------------------------------------------------------------------
Blog£º http://blog.csdn.net/tianlesoftware
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net
Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q Ⱥ£º62697716
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É
SQL> select name from v$database;
NAME
---------
ORCL
......
´ó¼ÒºÃ£¬ÎÒ×î½üά»¤Ò»¸öÏîÄ¿£¬100¶à¸ö±í
Ö»ÄÜÓÃjdbcÖ±Á¬
Óöµ½Á˶à¸ö±í ¹ØÁª ²éѯµÄÇé¿ö Çë´ó¼ÒÖ¸½Ì
±ÈÈç
student(studentid,classid)
class(classid,classname)
class_teacher(classid,teacherid)Õâ¸öÊÇÖмä±í ......
ÈçÏÂVC6²Ù×÷ORACLEÁ¬½Ó·½·¨Îª¿É±¨´í£º
_bstr_t connStr£»
connStr="Provider=OraOLEDB.Oracle;User ID=scott;Password=tiger;Data Source=192.168.0.120;";
m_SqlConn->Open(_bstr_t(connStr),(_b ......