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

what is the syntax of INSERT command?

Question Posted / vara prasad vizag

7 Answers
10539 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

What is catalog in Oracle?

1367

Explain an extent?

1109

Explain a segment?

1093

Explain the use of indexes option in imp command.

1181

How do I limit the number of rows returned by an oracle query after ordering?

1170

various types of hints and their usage

2699

How do I reset a sequence in oracle?

1102

How to revoke create session privilege from a user in oracle?

1018

How would you best determine why your MVIEW couldnt FAST REFRESH?

1889

What are the attributes that are found in a cursor?

1078

Explain the difference between a procedure and a function? What do you understand by those terms?

1090

What is Trigger in Oracle?

1176

What is primefaces used for?

1049

What are the four Oracle system processes that must always be up and running for the database to be useable?

1019

Why use resource manager in Oracle?

1109