ÎÒÒÔǰ¿ÉÒÔ´ò¿ªDatabase Configuration AssistantÒ²¿É´ò¿ªnet ManagerµÄ£¬ÏÖÔÚ²»ÖªµÀΪʲô¶¼´ò²»¿ªÁË¡£
µã»÷û·´Ó¦£¬²éµÄ˵ֱ½ÓÔËÐÐdbca.bat¡£½á¹ûÕâ¸ö˵ϵͳÕÒ²»µ½Â·¾¶.ÎÒÕûÀí¹ý¿Õ¼ä£¬ÊDz»ÊÇÒòΪÎÒ²»Ð¡ÐÄɾ´íÁËʲô¶«Î÷
Äã˵¶ÔÁËÎÒ°ÑC:\Program Files\OracleÕâ¸öÎļþ¼Ð¸øÉ¾ÁË ¶ødbcaÒªÀ´µ÷ÓÃÕâÀïµÄjarºÍjre
......
OracleÃüÁîÐÐÖÐÈÃËùÓÐÊôÐÔÔÚÒ»ÐÐÏÔʾ
id
-----------
name
-----------
1
nice
2
jack
id
-------
name
----------
3
maliy
ÈçºÎÈÃËùÓÐÊéÊôÐÔÔÚÒ»Áа¡
eg:
id name
-------------
1 nice
2 jack
3 maliy
select id,n ......
ÎÒÓÃsqlDataSource¿Ø¼þÅäÖÃÊý¾ÝÔ´£¬Êý¾Ý¿âÊÇOracleµÄ¡£Çë¿´ÏÂÃæ2ÌõÓï¾ä
1¡¢
SELECT DISTINCT B.YJDM from (SELECT ID from TBL_SHENHE WHERE SFSHWB='ÊÇ') A, TBL_DESIGN B WHERE A.ID = B.DESIGNID ORDER BY B.YJDM
2¡¢
SELECT DISTINCT B.YJDM from TBL_SHENHE A, TBL_DESIGN B WHERE A.SFSHWB=' ......
Çó¡¶ Oracle 9i DBA ÊֲᡷµÄÏÂÔØµØÖ·
»òÕß·¢µ½ÎÒÓÊÏäÒ²¿ÉÒÔ 051pan@163.com лл
Oracle 9i Êý¾Ý¿â²Î¿¼ÊÖ²á Ó¢Îİæ chm¸ñʽ. ÒÑ´«µ½csdnÏÂÔØÀ¸Ä¿..
˳±ã·¢µ½ÄãÓÊÏäÁË..
лл ÎÒÐèÒªµÄÊÇ < <oracle9i dbaÊÖ²á>>Ò»Êé »úе¹¤Òµ³ö°æÉçµÄ Óеĸø·¢Ò»·Ýµ½051pan@163.com ......
±í¸ñʽ£º
Col1 col2
A 11
B 33
* 22
Ä¿µÄ£ºµ±col1 Ϊ A ʱ µÃ³öCOL2ÏàÓ¦µÄÖµ11,µ±col1 Ϊ B ʱ µÃ³öCOL2ÏàÓ¦µÄÖµ33,µ±col2Ϊ D ʱ µÃ³öcol2µÄֵΪ 22£¬± ......
ÎÒÓÃoracle10g Á¬½Ó·þÎñÆ÷ûһµãÎÊÌ⣬µ«ÊÇÅäÖñ¾µØÁ¬½ÓµÄʱºòÀÏÁ¬½Ó²»ÉÏ£¿ÄÄλÓöµ½¹ý°ïÎÒ¿´Ï£¬ÓÉÓÚ²»ºÃ˵Çå³þ£¬¼ÓÎÒQQ»òMSN£¬ÅªºÃÁ˸ø·Ö£¡
ÓÐûÓÐ×°·À»ðǽ,
¿Í»§¶ËÓÐûÓа²×°?
ÒýÓÃ
ÎÒÓÃoracle10g Á¬½Ó·þÎñÆ÷ûһµãÎÊÌ⣬µ«ÊÇÅäÖñ¾µØÁ¬½ÓµÄʱºòÀÏÁ¬½Ó²»ÉÏ£¿
ÄÜ·ñÔÚÃèÊöµÄÏêϸµã£¿
ÎÒÔÚo ......