SQL> create table emp(id number(20),name varchar2(20), salary number(20), dept
varchar(20));
Table created.
SQL> insert into emp values(&id,'&name',&salary,'&dept');
Enter value for id: 101
Enter value for name: Ravi
Enter value for salary: 90000
Enter value for dept: CSE
old 1: insert into emp values(&id,'&name',&salary,'&dept')
new 1: insert into emp values(101,'Ravi',90000,'CSE')
1 row created.
SQL> /
Enter value for id: 102
Enter value for name: Rakesh
Enter value for salary: 80000
Enter value for dept: IT
old 1: insert into emp values(&id,'&name',&salary,'&dept')
new 1: insert into emp values(102,'Rakesh',80000,'IT')
1 row created.
SQL> /
Enter value for id: 103
Enter value for name: Rajesh
Enter value for salary: 70000
Enter value for dept: EEE
old 1: insert into emp values(&id,'&name',&salary,'&dept')
new 1: insert into emp values(103,'Rajesh',70000,'EEE')
1 row created.
SQL> /
Enter value for id: 104
Enter value for name: Ramya
Enter value for salary: 120000
Enter value for dept: CST
old 1: insert into emp values(&id,'&name',&salary,'&dept')
new 1: insert into emp values(104,'Ramya',120000,'CST')
1 row created.
SQL> /
Enter value for id: 105
Enter value for name: Rupa
Enter value for salary: 60000
Enter value for dept: ETE
old 1: insert into emp values(&id,'&name',&salary,'&dept')
new 1: insert into emp values(105,'Rupa',60000,'ETE')
1 row created.
SQL> desc emp;
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NUMBER(20)
NAME VARCHAR2(20)
SALARY NUMBER(20)
DEPT VARCHAR2(20)
SQL> alter table emp rename column name to empname;
Table altered.
SQL> update emp set empname='Ramesh' where id=101;
1 row updated.
SQL> desc emp;
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NUMBER(20)
EMPNAME VARCHAR2(20)
SALARY NUMBER(20)
DEPT VARCHAR2(20)
SQL> delete from emp where id=105;
1 row deleted.
SQL> select distinct dept from emp;
DEPT
--------------------
IT
EEE
CSE
CST
SQL> select dept from emp;
DEPT
--------------------
CSE
IT
EEE
CST
SQL> select * from emp where dept='CST';
ID EMPNAME SALARY DEPT
---------- -------------------- ---------- --------------------
104 Ramya 120000 CST
SQL> select * from emp where salary>60000;
ID EMPNAME SALARY DEPT
---------- -------------------- ---------- --------------------
101 Ramesh 90000 CSE
102 Rakesh 80000 IT
103 Rajesh 70000 EEE
104 Ramya 120000 CST
SQL> select salary from emp where salary>60000;
SALARY
----------
90000
80000
70000
120000
SQL> select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
SAILORS TABLE
EMP TABLE
RESERVES TABLE
COURSE TABLE
SECTION TABLE
TAKES TABLE
TEACHES TABLE
BOATSRELATION TABLE
CUSTOMER TABLE
BRANCH TABLE
ACCOUNT TABLE
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
DEPOSITOR TABLE
LOAN TABLE
BORROWER TABLE
STUDENT TABLE
INSTRUCTOR TABLE
DEPARTMENT TABLE
TIME_SLOT TABLE
ADVISOR TABLE
CLASSROOM TABLE
PREREQ TABLE
21 rows selected.
SQL> alter table boatsrelation rename to boats;
Table altered.
SQL> select * from sailors;
SID SNAME RATING AGE
---------- -------------------- ---------- ----------
22 Dustin 7 45
29 Brutus 1 33
31 Lubber 8 55.5
32 Andy 8 25.5
58 Rusty 10 35
64 Horatio 7 35
71 Zorba 10 16
74 Horatio 9 35
85 Art 3 25.5
95 Bob 3 63.5
10 rows selected.
SQL> select * from boats;
BID BNAME COLOR
---------- -------------------- ---------------
101 Interlake blue
102 Interlake red
103 Clipper green
104 Marine red
SQL> select * from reserves;
SID BID DATE1
---------- ---------- ---------
22 101 10-OCT-98
22 102 10-OCT-98
22 103 08-OCT-98
22 104 07-OCT-98
31 102 10-NOV-98
31 103 06-NOV-98
31 104 12-NOV-98
64 101 05-SEP-98
64 102 08-SEP-98
74 103 08-SEP-98
10 rows selected.
SQL> select sid from sailors where rating>9;
SID
----------
58
71
SQL> select sid from sailors where rating>9;
SID
----------
58
71
SQL> select sname from sailors where age<30;
SNAME
--------------------
Andy
Zorba
Art
SQL> select sname from sailors where age<30;
SNAME
--------------------
Andy
Zorba
Art
SQL> select sname from sailors s,reserves r where bid=104 and s.sid=r.sid;
SNAME
--------------------
Dustin
Lubber
ORA-00918: column ambiguously defined
SQL> select s.sid from sailors s,reserves r,boats b where color='blue' and
s.sid=r.sid and r.bid=b.bid;
SID
----------
22
64
SQL> select s.sid from sailors s,reserves r,boats b where color='blue' and
s.sid=r.sid and r.bid=b.bid;
SID
----------
22
64
SQL> spool off;
