DBMS PRACTICLE 2:- DATA MANIPULATION LANGUAGE

PRACTICLE 2:- DATA MANIPULATION LANGUAGE


SQL> create table practicle265(emp_id int primary key,name varchar(20) not null,address varchar(
salary decimal(10,2));

Table created


SQL> insert into practicle265 values(01,'mayank sharma','bhayandar',100000);

1 row created.

SQL> insert into practicle265 values(02,'bhushan talekar','vasai',100000);

1 row created.

SQL> insert into practicle265 values(03,'saurabh shetty','dahisar',100000);

1 row created.

SQL> insert into practicle265 values(04,'khyati vashi','bhayandar',100000);

1 row created.

SQL> insert into practicle265 values(05,'aditya lohia','vasai',100000);

1 row created.

SQL> select * from practicle265;

EMP_ID NAME ADDRESS SALARY
---------- -------------------- -------------------- ----------
1 mayank sharma bhayandar 100000
2 bhushan talekar vasai 100000
3 saurabh shetty dahisar 100000
4 khyati vashi bhayandar 100000
5 aditya lohia vasai 100000

SQL>

SQL>
SQL> select emp_id from practicle265;

EMP_ID
----------
1
2
3
4
5



SQL> select emp_id from practicle265 where emp_id=1;

EMP_ID
----------
1

SQL> select * from practicle265 where name='mayank sharma';

EMP_ID NAME ADDRESS SALARY
---------- ------------------- -------------------- ----------
1 mayank sharma bhayandar 100000

SQL> select * from practicle265 where name<>'mayank sharma';

EMP_ID NAME ADDRESS SALARY
---------- -------------------- -------------------- ----------
2 bhushan talekar vasai 100000
3 saurabh shetty dahisar 100000
4 khyati vashi bhayandar 100000
5 aditya lohia vasai 100000

SQL> select * from practicle265 where salary>10000;

EMP_ID NAME ADDRESS SALARY
---------- -------------------- -------------------- ----------
1 mayank sharma bhayandar 100000
2 bhushan talekar vasai 100000
3 saurabh shetty dahisar 100000
4 khyati vashi bhayandar 100000
5 aditya lohia vasai 100000


SQL> select * from practicle265 where emp_id=2 or name='mayank sharma';

EMP_ID NAME ADDRESS SALARY
---------- -------------------- -------------------- ----------
1 mayank sharma bhayandar 100000
2 bhushan talekar vasai 100000

SQL> select * from practicle265 where emp_id=2 and name='mayank sharma';

no rows selected

SQL> insert into practicle265(emp_id,name) values(6,'akshay mahtre');

1 row created.

SQL> select * from practicle265;

EMP_ID NAME ADDRESS SALARY
---------- -------------------- -------------------- ----------
1 mayank sharma bhayandar 100000
2 bhushan talekar vasai 100000
3 saurabh shetty dahisar 100000
4 khyati vashi bhayandar 100000
5 aditya lohia vasai 100000
6 akshay mahtre

6 rows selected.

SQL> update practicle265 set address='poisar',salary=10205 where emp_id=6;

1 row updated.

SQL> select * from practicle265;

EMP_ID NAME ADDRESS SALARY
---------- -------------------- -------------------- ----------
1 mayank sharma bhayandar 100000
2 bhushan talekar vasai 100000
3 saurabh shetty dahisar 100000
4 khyati vashi bhayandar 100000
5 aditya lohia vasai 100000
6 akshay mahtre poisar 10205

6 rows selected.

SQL> update practicle265 set address='bhayandar' where emp_id=5;

1 row updated.

SQL> select * from practicle265;

EMP_ID NAME ADDRESS SALARY
---------- -------------------- -------------------- ----------
1 mayank sharma bhayandar 100000
2 bhushan talekar vasai 100000
3 saurabh shetty dahisar 100000
4 khyati vashi bhayandar 100000
5 aditya lohia bhayandar 100000
6 akshay mahtre poisar 10205

6 rows selected.

SQL> select * from practicle265;

EMP_ID NAME ADDRESS SALARY
---------- -------------------- -------------------- ----------
1 mayank sharma bhayandar 10000
2 bhushan talekar vasai 10000
3 saurabh shetty dahisar 10000
4 khyati vashi bhayandar 10000
5 aditya lohia bhayandar 10000
6 akshay mahtr poisar 10000

6 rows selected.

SQL> update practicle265 set salary=15000 where emp_id>4;

2 rows updated.

SQL> select * from practicle265;

EMP_ID NAME ADDRESS SALARY
---------- -------------------- -------------------- ----------
1 mayank sharma bhayandar 10000
2 bhushan talekar vasai 10000
3 saurabh shetty dahisar 10000
4 khyati vashi bhayandar 10000
5 aditya lohia bhayandar 15000
6 akshay mahtr poisar 15000



6 rows selected.

SQL> select * from practicle265;

EMP_ID NAME ADDRESS SALARY
---------- -------------------- -------------------- ----------
1 mayank sharma bhayandar 10000
2 bhushan talekar vasai 10000
3 saurabh shetty dahisar 10000
4 khyati vashi bhayand 10000


SQL> delete from practicle265 where emp_id>2;

2 rows deleted.

SQL> select * from practicle265;

EMP_ID NAME ADDRESS SALARY
---------- -------------------- -------------------- ----------
1 mayank sharma bhayandar 10000
2 bhushan talekar vasai 10000

SQL> delete from practicle265;

2 rows deleted.

SQL> select * from practicle265;

no rows selected