How to Insert Record into Table

 How to Insert Record into Table

In the previous example i shown you how to create a table using Sql. in this page i will show you how to insert one value or more than one value in a table.

let's start

Answer:

SQL> Insert into stud values(&id,'&name','&branch);

Enter value for id: 237

Enter value for name: Bishakha

Enter value for branch:cse

old 1: insert into stud values(&id,'&name','&branch')

new 1: insert into stud values(237,'Bishakha','cse')

Enter value for id: 224

Enter value for name: Punam

Enter value for branch:cse

old 1: insert into stud values(&id,'&name','&branch')

new 1: insert into stud values(224,'Punam','cse')

1 row created.

Enter value for id: 228

Enter value for name: Owendrela

Enter value for branch:cse

old 1: insert into stud values(&id,'&name','&branch')

new 1: insert into stud values(228,'Owendrela','cse')

1 row created.

Enter value for id: 212

Enter value for name: Subham

Enter value for branch:cse

old 1: insert into stud values(&id,'&name','&branch')

new 1: insert into stud values(212,'Subham','cse')

1 row created.

Enter value for id: 214

Enter value for name: Shilpa

Enter value for branch:cse

old 1: insert into stud values(&id,'&name','&branch')

new 1: insert into stud values(214,'Shilpa','cse')

1 row created.

SQL>select * from stud;

ID     NAME           BRANCH

----------------------------------------------

237   Bishakha      cse

224   Punam          cse

228    Owendrela  cse

212   Subham        cse

214   Shilpa           cse

6 rows selected.