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 integrity and what is constraint??Explain with example

1803


How to convert a string to a date in oracle database?

632


What is Undo Management Advisor in Oracle?

687


How to invoke the original export import utilities?

587


Explain the use of constraints option in exp command.

663






How do you find current date and time in oracle?

673


What is the use of aggregate functions in oracle?

670


how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

1949


what are actual and formal parameters?

669


What is truncate oracle?

608


How to connect the oracle server as sysdba?

705


while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

3998


What are temporal data types in oracle?

687


How to export several tables together?

657


What is the fastest query method to fetch data from the table?

958