CREATE OR REPLACE PROCEDURE SP_SelectEvnent
(
BeginDate Date,
EndDate Date
)
is
BEGIN
select * from systemeventtable where eventcontent like 'TW-1:%' and eventtime>= to_date(BeginDate,'yyyy-mm-dd hh24:mi:ss') and eventtime<=to_date(EndDate,'yyyy-mm-dd hh24:mi:ss');
End;
报错 说是Select 缺少Into
初学Oracle 公司要改用Oracle了
(
BeginDate Date,
EndDate Date
)
is
BEGIN
select * from systemeventtable where eventcontent like 'TW-1:%' and eventtime>= to_date(BeginDate,'yyyy-mm-dd hh24:mi:ss') and eventtime<=to_date(EndDate,'yyyy-mm-dd hh24:mi:ss');
End;
报错 说是Select 缺少Into
初学Oracle 公司要改用Oracle了
格式为:
SELECT A.A INTO V_A FROM ABC A
oracle的procedure中select 必须与into 一起使用。
CREATE OR REPLACE PROCEDURE SP_SELECTEVNENT(BEGINDATE DATE, ENDDATE DATE) IS IDN NUMBER;
BEGIN
SELECT ID
INTO IDN
FROM SYSTEMEVENTTABLE WHERE EVENTCONTENT LIKE 'TW-1:%'
AND EVENTTIME >= TO_DATE(BEGINDATE, 'yyyy-mm-dd hh24:mi:ss')
AND EVENTTIME <= TO_DATE(ENDDATE, 'yyyy-mm-dd hh24:mi:ss');
END;