Oracle SQL problem with declare variable from table

Question

I have problem with make variable from table.

DECLARE
 liczba1 PLS_INTEGER;
 
 BEGIN
Select liczba1 := MAX(EMPLOYEE_ID) FROM PRACOWNICY;
 
 END;

That is the problem

ORA-00923: FROM keyword not found where expected

I don't have any idea why it's not working

Gordon Linoff · Accepted Answer · 2021-01-26 19:00:58Z

1

I think you want into:

SELECT MAX(EMPLOYEE_ID) INTO liczba1 FROM PRACOWNICY

answered Jan 26, 2021 at 19:00

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1