declarevcntNumber;beginSELECTcount(*)FROMUSERTABCOLUMNSWHERETABLENAME='USERINFO'ANDCOLUMNNAMEin(upper('userid'),'UNAME','UAGE','UBIRTHDAY','UREMARK');ifvcnt

Question

declare v_cnt Number;
begin
SELECT count(*) FROM USER_TAB_COLUMNS
WHERE TABLE_NAME = 'USERINFO' AND COLUMN_NAME in (upper('userid'),'UNAME','UAGE','UBIRTHDAY','UREMARK');
if v_cnt

Answer 1

结尾end后要分号,你没写
begin后那句,select count(*) into v_cnt..