DECLAREV_TABLE_NAME VARCHAR2(50);-- 表名
V_TABLE_WORD VARCHAR2(20); -- 字轨
V_ABOVE_TIME DATE; --上次访问日期
V_MAKE_NUMBER VARCHAR2(10); --序号
V_HISTORY_MAXNUMBER NUMBER ; --历史最大号
V_SYSTEMDATE varchar2(20) ; --系统当前时间
BEGIN
SELECT PK.TABLE_NAME
INTO V_TABLE_NAME, PK.MAKE_NUMBER INTO V_MAKE_NUMBER
FROM PK_MAKE PK;
END ;错误原因:
ORA-06550: line 13, column 47:
PL/SQL: ORA-00923: FROM keyword not found where expected
ORA-06550: line 12, column 6:
PL/SQL: SQL Statement ignored
V_TABLE_WORD VARCHAR2(20); -- 字轨
V_ABOVE_TIME DATE; --上次访问日期
V_MAKE_NUMBER VARCHAR2(10); --序号
V_HISTORY_MAXNUMBER NUMBER ; --历史最大号
V_SYSTEMDATE varchar2(20) ; --系统当前时间
BEGIN
SELECT PK.TABLE_NAME
INTO V_TABLE_NAME, PK.MAKE_NUMBER INTO V_MAKE_NUMBER
FROM PK_MAKE PK;
END ;错误原因:
ORA-06550: line 13, column 47:
PL/SQL: ORA-00923: FROM keyword not found where expected
ORA-06550: line 12, column 6:
PL/SQL: SQL Statement ignored
INTO V_TABLE_NAME, PK.MAKE_NUMBER INTO V_MAKE_NUMBER
FROM PK_MAKE PK;
这条语句错了,应该这样写:
SELECT PK.TABLE_NAME, PK.MAKE_NUMBER
INTO V_TABLE_NAME,V_MAKE_NUMBER
FROM PK_MAKE PK;
, PK.MAKE_NUMBER INTO V_TABLE_NAME,V_MAKE_NUMBER
FROM PK_MAKE PK;