what is the syntax of INSERT command?

Answers were Sorted based on User's Feedback



what is the syntax of INSERT command?..

Answer / 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

what is the syntax of INSERT command?..

Answer / raja

WE HAVE USE EMP TABLE INSERT COMMAND
1.INSERT INTO EMP(EMPNO,ENAME...)
VALUES(7839,'RAM')
2.INSERT INTO EMP VALUES(&EMPNO,'&ENAME',....)
3.INSERT INTO EMP (EMPNO)
VALUES(7900)

Is This Answer Correct ?    3 Yes 0 No

what is the syntax of INSERT command?..

Answer / shree

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

Is This Answer Correct ?    3 Yes 1 No

what is the syntax of INSERT command?..

Answer / 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

what is the syntax of INSERT command?..

Answer / arkchowdary

we use Dept table or Any table Insert Command

Insert into dept(Dname,deptno,location.....)values
('Darway',30,'Sweadon');

Or

Insert into dept values('&dname',deptno,'&location'....)

Is This Answer Correct ?    2 Yes 0 No

what is the syntax of INSERT command?..

Answer / vara prasad vizag

Syntax:
INSERT INTO <Table-Name> ( Col1,Col2....)
VALUES(Val1,Val2...);

Example:
INSERT INTO StudentInfo (Studno,Fname,Lname,DOB,DOJ, Gender)
VALUES(1234,'Varaprasad','Vizag','17-Nov-85','M');

Is This Answer Correct ?    0 Yes 0 No

what is the syntax of INSERT command?..

Answer / 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

More Oracle General Interview Questions

Explain the use of Merge statement in oracle 11g

0 Answers   Infosys,


How can I combine multiple rows into a comma-delimited list in oracle?

0 Answers  


What is a trigger and what are its types in oracle?

0 Answers  


We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.

0 Answers  


How to create a new tablespace in oracle?

0 Answers  


How remove data files before opening a database?

0 Answers  


How different is ms access and oracle?

0 Answers  


What is the difference between implicit index and explicit index?

2 Answers   TCS,


How to calculate date and time differences in oracle?

0 Answers  


9. Display the client name and order date for all orders using the JOIN . . . USING method.

2 Answers   Wipro,


What does ROLLBACK do ?

1 Answers  


how table is defined in plsql table? how can i select column from plsql table? can i use select * from plsql table type?

1 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)