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

Can Multiple instances be run on Single Machine???

3 Answers  


How do you bind variables in oracle?

0 Answers  


What is background process in Oracle?

0 Answers   MCN Solutions,


Can we call a trigger inside a function and function inside a trigger? Give example.

1 Answers   Metric Stream,


> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?

0 Answers  






SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?

1 Answers   ESS,


How can we find out the current date and time in oracle?

0 Answers  


How to grant create session privilege to a user in oracle?

0 Answers  


What is the difference between PFILE and SPFILE in Oracle?

0 Answers   MCN Solutions,


Please explain drop constraint oracle?

0 Answers  


how to find out largest value in a table

2 Answers  


What is a Shared SQL pool ?

2 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • 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)