Syntax: INSERT INTO <Table-Name> ( Col1,Col2....) VALUES(Val1,Val2.

what is the syntax of INSERT command?

Question Posted / vara prasad vizag

7 Answers
10478 Views
I also Faced
E-Mail Answers

Answer Posted / vara prasad vizag

Syntax:
INSERT INTO <Table-Name> ( Col1,Col2....)
VALUES(Val1,Val2...);

Example:
INSERT INTO StudentInfo (Studno,Fname,Lname,DOB,DOJ, Gender)
VALUES(1234,'Varaprasad','Vizag','17-Nov-85','M');

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to use "for" statements in oracle?

1069

How to run the anonymous block again?

1121

What is an oracle data file?

1095

What is SQL access advisor in Oracle?

1182

What is MTTR advisor in Oracle?

1082

Difference between pre-select and pre-query

1096

Why is oracle used?

931

How do I limit the number of oracle database connections generated by weblogic server?

1059

Describe varray?

1052

Why do you create or replace procedures rather that drop and recreate.

997

How many memory layers are in the oracle shared pool?

1168

How many types of synonyms in Oracle?

1113

How to commit the current transaction in oracle?

1104

What is partitioned table in Oracle?

1180

How to select some columns from a table in oracle?

1075