|
SQL>
SQL> CREATE TABLE department (
2 dept_id INTEGER,
3 dept_name VARCHAR2(32));
Table created.
SQL>
SQL>
SQL> BEGIN
2 INSERT into department (dept_id, dept_name)values (1,'dept_name');
3 END;
4 /
PL/SQL procedure successfully completed.
SQL>
SQL> select * from department;
DEPT_ID DEPT_NAME
---------- --------------------------------
1 dept_name
SQL> drop table department;
Table dropped.
SQL>
SQL>
|