what is the syntax of INSERT command?

Answer Posted / pushkar

INSERT INTO TABLE
VALUES (VAL1,VAL2,VAL3,...)

Note: SPECIFY THE RIGHT NUMBER OF COLUMNS AND THE
appropriate null values by writing "NULL" .

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How will you identify oracle database software release?

748


Explain the use of record option in exp command.

742


What is archive log in Oracle?

826


What are the differences between number and binary_float in oracle?

816


Is java required for oracle client?

721


Explain about your project and its relation to the current job position you are applying to?

757


How to convert times to characters in oracle?

793


How can we force the database to use the user specified rollback segment?

812


i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1701


How to run create database statement?

761


What is the difference between alert log file and tarce file ?

1848


How do I manually create a database in oracle?

736


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

866


6. Display the client name and order date for all orders using the traditional method.

1997


How will you differentiate between varchar & varchar2?

797