sql*plus¸ü¸ÄÓû§ - Oracle / »ù´¡ºÍ¹ÜÀí
¸ü¸ÄÓû§Ê± µÄ conn ºÍconnectÓÐÊ²Ã´Çø±ð£¿£¿
²»ÊǶ¼Ê±¸ü¸ÄÓû§Â£¿
ûÓÐÇø±ð£¬ conn ÊÇconnect µÄ¼òд..
conn¾ÍÊǵ÷ÓÃconnect
Ã»Çø±ðµÄ ¶¼Ò»Ñù
connÊÇconnectµÄËõд£¬Ã»ÓÐÇø±ð¡£
¾ÍÊÇÕâÑù£¡
+1
ÄÇ grant connect to cat with admin option ºÍ
grant conn to cat with admin option
ÓÐÇø±ðÂ£¿£¿£¿£¿£¿£¿
ÎÒÕâÀïûÓÐ×°oracle ±¾Ïë×Ô¼ºÈ¥ÇóöÀ´¿´¿´µÄ
µÚÒ»¾äÊÇÔÚcatȨÏÞ Ö»Óв鿴µÄȨÏÞ
µÚ¶þÄØ£¿£¿£¿ °ÑϵͳȨÏÞ¸øcat £¿£¿£¿ ¿Éconn²»ÊǸü¸ÄÓû§µÄÒâ˼Â£¿
Ïà¹ØÎÊ´ð£º
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......