ÏÖÓÐÒ»¸ö´æ·ÅÁ˿ռäÊý¾ÝµÄ±í£¬ÎÒÏëͨ¹ýsql³ÌÐò£¬°ÑÀïÃæµÄ×ø±êÐÅÏ¢¶Á³öÀ´£¬ÄÄλ°ïæ¸øÐ´¶Î³ÌÐò°É¡£
Çë°ÑÄãµÄ ±í½á¹¹¡¢²âÊÔÊý¾Ý¡¢ºÍ×îÖյĽá¹û Ìù³öÀ´£¬ÕâÑùÁýͳ£¬Ôõô°ïÄã¡£¡£¡£¡£
ÌùÊý¾ÝÉÏÀ´!
ÒýÓÃ
ÌùÊý¾ÝÉÏÀ´!
ͬÒå
......
ĿǰÎÒÐèÒª½«¹«Ë¾ÀïÃæ·þÎñÆ÷µÄÊý¾Ý¿âÕû¸öµ¼³ö,È»ºóÄõ½¿Í»§ÄÇÀïµ¼Èë½øÈ¥ÓÃ,ÔÚ¹«Ë¾²âÊÔ½×¶ÎÖÐ,³öÏÖµ¼³öÀ´µÄÊý¾Ý¿âDMPÎļþÔÙÖØÐµ¼ÈëÊý¾Ý¿âÒÔºó,Êý¾Ý¿âµÄÆóÒµ¹ÜÀíÆ÷ûÓÐÁË,ÔÚ·þÎñÖÐҲûÓÐCONSOLEÄÇÏî·þÎñÁË,¾¿¾¹ÊÇʲôÔÒòÄØ?Çë¸ßÊÖ½â´ð.Ïêϸµã×îºÃ..Ê®·Ö¸Ðл
consoleûÓÐß·£¿
ÄãµÄµ¼³öºÍµ¼ÈëµÄÊý¾Ý¿â°æ±¾ÊÇÒ»Öµ ......
ÓÐÈýÕűí
tableA ×Ö¶Î aid,aname
tableB ×Ö¶Î aid,bid
tableC ×Ö¶Î cid,cname,aid
ÎÒÒª²é³ö tableA µÄaid,aname ºÍtableBÖÐaidÏà¶ÔÓ¦µÄbid ºÍ tableCÖÐaidÏà¶ÔÓ¦µÄ×ÜÊý
ÎÒÔÀ´µÄ˼·ÊÇ
1¡¢select ta.aid,ta.aname,tb.bid from tableA ta,tableB b where ta.aid = tb.aid;
2¡¢±éÀúÉÏÃæ²é³öµÄList£¬ ......
1>select "aa" || "bb" from dual; //´íÎ󣬵¥ÒýºÅ¾Í¿ÉÒÔ
2>select a.name as 'Ãû×Ö' from a; //´íÎó£¬Ë«ÒýºÅ¿ÉÒÔ
ÎÒÓеã»ìÏý£¬ÇëÖ¸½Ì
×Ö·û´®µÄÄÚÈÝÓõ¥ÒýºÅÀ´ÏÞ¶¨£»
×ֶεıðÃûÊÇÒªÓÃË«ÒýºÅÀ´ÏÞ¶¨µÄ
1>select & ......
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿
ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..
ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿
ÄãÔÙÖØÐ°²×°ÊÔÊÔ ±¨µÄÊÇʲô´íÎó£¿ ÊDz»ÊÇ֮ǰװ¹ý£¿
http://topic.csdn.net/ ......
ͨ¹ýä¯ÀÀÆ÷·ÃÎÊÆóÒµ¹ÜÀíÆ÷£¬Ò³Ãæ¿Õ°×£¬Ö»ÓÐ×óÉϽÇÓÐÆæ¹ÖµÄͼ°´£¬ÓеãÏñÂÒÂëÄÇÖֵģ¬ÎªÊ²Ã´»áÕâÑù£¿ÎҶ˿ڶ¼Ð´¶ÔµÄ
ÊÇ·ÃÎÊemô¡£
¿ÉÒÔhttp:\\host:1158\em
¶Ë¿ÚÒ²ÓпÉÄÜÖ¸¶¨ÆäËûµÄ¶Ë¿ÚÁË
¿ÉÒÔÔÚ%ORACLE_HOME%\install\portlist.iniÖп´¿´
ÕâÖÖÇé¿öÎÒÒ²Óöµ½¹ý,µ±Ê±ÊǶ˿ÚÕÒ´íÁ˵¼ÖµÄ.
grid cont ......