hi guys
how are you??
i am coding for project and i got errors but i don't know what is the wrong??
here is the code
set serveroutput on
declare
h00019852_depid :=departments.department_id%type;
begin
select max(h00019852_depid) into department_id
from departments
group by department_id;
dbms_output.put_line('The maximum department id is: '||h00019852_depid);
end;
this is the error:
(h00019852_depid :=departments.department_id%type;
*
ERROR at line 2:
ORA-06550: line 2, column 17:
PLS-00103: Encountered the symbol "=" when expecting one of the following:
constant exception <an identifier>
<a double-quoted delimited-identifier> table LONG_ double ref
char time timestamp interval date binary national character
nchar
The symbol "<an identifier>" was substituted for "=" to continue. )
==========================================================
and this too
set serveroutput on
accept h00019852_depid prompt'Enter department id:'
declare
h00019852_depid Number:= employees.department_id%type;
h00019852_empid employees.employee_id%type;
begin
select (count(h00019852_empid)) into employee_id
from employees
where departments.department_id=employees.department_id;
dbms_output.put_line(h00019852_empid||'employee(s) work for department number'||depid);
end;
and this is the error for code
(h00019852_depid Number:= employees.department_id%type;
*
ERROR at line 2:
ORA-06550: line 2, column 50:
PLS-00208: identifier 'TYPE' is not a legal cursor attribute
ORA-06550: line 2, column 17:
PL/SQL: Item ignored
ORA-06550: line 8, column 7:
PL/SQL: ORA-00904: "DEPARTMENTS"."DEPARTMENT_ID": invalid identifier
ORA-06550: line 6, column 1:
PL/SQL: SQL Statement ignored
ORA-06550: line 10, column 81:
PLS-00201: identifier 'DEPID' must be declared
ORA-06550: line 10, column 1:
PL/SQL: Statement ignored )
could you help me, please?!