what is the syntax of INSERT command?

Answer Posted / mahaveer kumar h.v.

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

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is oracle update statement with inner join ?

806


How to view the tablespaces in the current database?

772


What are the different types of trigger and explain its various uses and functions?

765


How do I find the database name in oracle?

796


How oracle handles dead locks?

838


what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2058


How to assign a table row to a record variable?

783


Whether any commands are used for months calculation? If so, what are they?

866


Will you be able to store pictures in the database?

915


How to insert multiple rows with one insert statement in oracle?

815


What do you understand by a database object?

818


Point the difference between translate and replace?

855


How to delete multiple rows from a table in oracle?

826


Explain a synonym?

809


What do you mean by group by clause?

804