INSERT INTO table_name (Col_name1,Col_name2,Col_name3...) VALUES (Col

what is the syntax of INSERT command?

Question Posted / shree

Answer Posted / shree

INSERT INTO table_name (Col_name1,Col_name2,Col_name3...)
VALUES (Col_value1,Col_value2,Col_value3...)

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to rename an existing table?

1207

What is a private synonym?

1642

What is Reduced List of Values?

2240

What is where clause in oracle?

1074

Where do we use decode and case statements?

1058

What privilege is needed for a user to create views in oracle?

1091

What is ceil and floor in oracle?

1118

What are the different types of failures that occur in Oracle database?

1116

Does oracle database need java?

1064

What do you mean by merge in oracle and how can you merge two tables?

1001

How many types of table in Oracle?

1169

How to create a table index?

1221

How to run queries on external tables?

1083

What is the difference between formal parameters and actual parameters?

1149

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4676