1. INSERT
=========
IT CAN BE USED INH 3 WAYS
1. to insert single row
=======================
syntax:
======
insert into tablename values(val1,...);
to insert student details
========================
insert into student values(101,'raju','oracle',1200,'12-jan-2008');
2. to insert particular colunm values
=====================================
syntax:
======
insert into tablename(col1,,...)
values(val1....);
to insert sno,sname,course
=========================
insert into student(sno,sname,course)
values(102,'rajesh','vb');
3. to insert multiple rows
=========================
syntax:
======
insert into student values
(&colname,.........);
insert into student values(&sno,'&sname','&course',&fees,'&dop');
UPDATE COMMAND
==============
1.To chage data by condition
==========================
update tablename set colname=value
to increase fees by 200rs for oracle course
=-==========================================
update student set fees=fees+200 where course like 'oracle';
2. to change multiple values in a table
======================================
update tablename set colname=value;
ex:
increase all student fees by 1000;
===================================
update student set fees=fees+1000;
3. delete
1. to delete 101 record from student table
==========================================
delete from student where sno=101;
2. to delete all records from student table
===========================================
delete from student;
No comments:
Post a Comment