Begin
Create table emp_dept(emp_code varchar2(10),dept_code varchar2(10));
End;
The code will raise a parsing error as the block has a DDL statement, which is not allowed directly within a PL/SQL block. The DBMS_SQL package should be used to use a DDL statement.
Create table emp_dept(emp_code varchar2(10),dept_code varchar2(10));
End;
The code will raise a parsing error as the block has a DDL statement, which is not allowed directly within a PL/SQL block. The DBMS_SQL package should be used to use a DDL statement.