SQL> connect
Enter user-name: SYSTEM
Enter password:
Connected.
SQL> create table student
2 (rno number(3),
3 sname varchar(10),
4 course varchar(5));
Table created.
SQL> desc student
Name Null? Type
----------------------------------------- -------- ----------------------------
RNO NUMBER(3)
SNAME VARCHAR2(10)
COURSE VARCHAR2(5)
SQL> insert into student values(111,'raman','bsc');
1 row created.
SQL> insert into student values(112, 'gopi','bcom');
1 row created.
SQL> insert into student values(113, 'john','bba');
1 row created.
SQL> select rno, sname,course from student;
RNO SNAME COURS
---------- ---------- -----
111 raman bsc
112 gopi bcom
113 john bba
SQL> select * from student;
RNO SNAME COURS
---------- ---------- -----
111 raman bsc
112 gopi bcom
113 john bba
SQL> update student set course = 'bsc' where rno = 113;
1 row updated.
SQL> select * from student;
RNO SNAME COURS
---------- ---------- -----
111 raman bsc
112 gopi bcom
113 john bsc
SQL> delete from student where rno = 111;
1 row deleted.
SQL> select * from student;
RNO SNAME COURS
---------- ---------- -----
112 gopi bcom
113 john bsc
SQL> alter table student
2 add (marks number(2));
Table altered.
SQL> desc student;
Name Null? Type
----------------------------------------- -------- ----------------------------
RNO NUMBER(3)
SNAME VARCHAR2(10)
COURSE VARCHAR2(5)
MARKS NUMBER(2)
SQL> select * from student;
RNO SNAME COURS MARKS
---------- ---------- ----- ----------
112 gopi bcom
113 john bsc
SQL> update student set marks=56 where rno = 112;
1 row updated.
SQL> update student set marks = 78 where rno = 113;
1 row updated.
SQL> select * from student;
RNO SNAME COURS MARKS
---------- ---------- ----- ----------
112 gopi bcom 56
113 john bsc 78
SQL> truncate table student;
Table truncated.
SQL> select * from student;
no rows selected
SQL> dest student;
SP2-0734: unknown command beginning "dest stude..." - rest of line ignored.
SQL> desc student;
Name Null? Type
----------------------------------------- -------- ----------------------------
RNO NUMBER(3)
SNAME VARCHAR2(10)
COURSE VARCHAR2(5)
MARKS NUMBER(2)
SQL> drop table student;
Table dropped.
SQL> desc student
ERROR:
ORA-04043: object student does not exist