ASP中的Oracle的SQL语句问题

Question

SELECT COUNT(*) INTO COCount FROM TXTC_DBA.T_MANAGE_PHONENUMBER,TXTC_DBA.T_MAINTAIN_PHONETYPE,TXTC_DBA.T_OP_USERS,TXTC_DBA.T_GK_ACCOUNT

Answer 1

先不要执行 先用response.write把SQL语句输出再贴出来

Answer 2

SELECT COUNT(*)  FROM TXTC_DBA.T_MANAGE_PHONENUMBER,TXTC_DBA.T_MAINTAIN_PHONETYPE,TXTC_DBA.T_OP_USERS,TXTC_DBA.T_GK_ACCOUNT

Answer 3

SELECT COUNT(*) INTO COCount FROM TXTC_DBA.T_MANAGE_PHONENUMBER,TXTC_DBA.T_MAINTAIN_PHONETYPE,TXTC_DBA.T_OP_USERS,TXTC_DBA.T_GK_ACCOUNT
中的INTO CoCount 是将值给CoCount?如果CoCount是游标吗?怎么没有定义?先按SELECT COUNT(*)  FROM TXTC_DBA.T_MANAGE_PHONENUMBER,TXTC_DBA.T_MAINTAIN_PHONETYPE,TXTC_DBA.T_OP_USERS,TXTC_DBA.T_GK_ACCOUNT
执行看看?