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

What are group functions in oracle?

655


Explain what are synonyms used for?

698


How to use subqueries with the in operator using oracle?

691


List the types of joins used in writing subqueries?

662


What is save point in oracle database?

838






Explain oracle 12c new features for developers?

630


What is oracle rowcount?

681


How to list all user accounts in oracle?

716


What are the ansi data types supported in oracle?

591


How to use "in out" parameter properly?

694


What are the different types of synonyms?

678


How many types of auditing in Oracle?

657


Explain the blob datatype?

697


How to create an oracle database manually?

666


What are the components of logical database structure in oracle database?

687