Akshat Tias.docx

SQL> show tables; SP2-0158: unknown SHOW option "tables" SQL> show databases; SP2-0158: unknown SHOW option "databases" SQL> show table; SP2-0158: unknown SHOW option "table" SQL> create table emp_1(empno int, 2 empname varchar(20), 3 deptno int);

Table created.

SQL> insert into emp values (001,'akshat jain',10); insert into emp values (001,'akshat jain',10) * ERROR at line 1: ORA-00947: not enough values

SQL> insert into emp_1 values(001,'akshat jain',10);

1 row created.

SQL> insert into emp_1 values (002,'joshua',40);

1 row created.

SQL> select *from emp_1;

EMPNO EMPNAME

DEPTNO

---------- -------------------- ---------1 akshat jain 2 joshua

SQL>

10 40