ÄÄλÓùýoracle apex£¬ÖªµÀ±¨±íµÄ¸ßÁÁÏÔʾ
ÄÄλÐǪ̈Óùýoracle apex.ÎÒÓÐÒ»¸ö±¨±í£¬ÆäÖÐһЩÐÅÏ¢ÐÐÐèÒª¸ßÁÁÍ»³öÏÔʾ£¬²»Öª
ÈçºÎ²Ù×÷£¬ÖªµÀµÄÖ¸µãϹþ
ûÈËÓùýapexô£¬ÄÇôÓÐûÓÐʲô·½·¨¿ÉÒÔ´Óselect²éѯ³öµÄ½á¹ûÖУ¬½«ÎÒÏ£ÍûÍ»³öÏÔʾµÄÐÅÏ¢¸ßÁÁÏÔʾ
¹ýÍêÄêÀ¡£À´¸ö¸ßÈ˰É
HELP
Í·Í´
Ïà¹ØÎÊ´ð£º
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ
ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......