SQL> create table dept(deptcode varchar2(4) primary key, deptname varchar2(20));

Table created.

SQL> insert into dept values('&deptcode', '&deptname');
Enter value for deptcode: D301
Enter value for deptname: Sales
old   1: insert into dept values('&deptcode', '&deptname')
new   1: insert into dept values('D301', 'Sales')

1 row created.

SQL> /
Enter value for deptcode: D302
Enter value for deptname: Account
old   1: insert into dept values('&deptcode', '&deptname')
new   1: insert into dept values('D302', 'Account')

1 row created.

SQL> /
Enter value for deptcode: D707
Enter value for deptname: Research
old   1: insert into dept values('&deptcode', '&deptname')
new   1: insert into dept values('D707', 'Research')

1 row created.

SQL> /
Enter value for deptcode: D909
Enter value for deptname: Advertising
old   1: insert into dept values('&deptcode', '&deptname')
new   1: insert into dept values('D909', 'Advertising')

1 row created.

SQL> /
Enter value for deptcode: D202
Enter value for deptname: Stock
old   1: insert into dept values('&deptcode', '&deptname')
new   1: insert into dept values('D202', 'Stock')

1 row created.

SQL> /
Enter value for deptcode: D110
Enter value for deptname: Computer
old   1: insert into dept values('&deptcode', '&deptname')
new   1: insert into dept values('D110', 'Computer')

1 row created.

SQL> /
Enter value for deptcode: D305
Enter value for deptname: Marketing
old   1: insert into dept values('&deptcode', '&deptname')
new   1: insert into dept values('D305', 'Marketing')

1 row created.

SQL> select * from dept;

DEPT DEPTNAME
---- --------------------
D301 Sales
D302 Account
D707 Research
D909 Advertising
D202 Stock
D110 Computer
D305 Marketing

7 rows selected.