INSERT COMMAND CAN BE USED IN TWO WAYS 1.TO INSERT ALL VALUES INTO TABL

what is the syntax of INSERT command?

Question Posted / subba rao

7 Answers
10273 Views
I also Faced
E-Mail Answers

Answer Posted / subba rao

INSERT COMMAND CAN BE USED IN TWO WAYS

1.TO INSERT ALL VALUES INTO TABLE : VALUES INSERT INTO
<TABLE NAME> VALUES
(<COL_VALUE1>,<COL_VALUE2>...<COL_VALUEN>)

2.TO INSERT INTO SPECIFIED VALUES : INSERT INTO <TABLE
NAME> (<COL_NAME1>,<COL_NAME2>...<COL_NAMEN>)VALUES
(<COL_VALUE1>,<COL_VALUE2>...<COL_VALUEN>)

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is analyze command used for?

1019

How much memory your 10g xe server is using?

1059

How to concatenate two text values in oracle?

1062

Difference between varchar and varchar2 data types?

1131

What is the parameter mode that can be passed to a procedure?

991

Explain what are the advantages of views?

1021

What is a proxy class?

980

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2002

How to count duplicated values in a column in oracle?

997

What is redo log?

1012

What are the different types of partitions in oracle?

921

Explain integrity constraint?

1118

What is meant by joins?

1023

What is pragma autonomous transaction in oracle?

1005

What is Library Cache in Oracle?

1090