what is the syntax of INSERT command?
- 7 Answers
- 9292 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
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 |
What does COMMIT do ?
How to call a trigger inside a stored procedure?Give an example.
How to work with data objects interactively?
what is dynamic SGA and static SGA
How to apply filtering criteria at group level in oracle?
what is Table ?
We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.
What is meant by raw datatype?
6. Display the client name and order date for all orders using the traditional method.
How would you extract DDL of a table without using a GUI tool?
ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?
What is SQL Tuning Advisor in Oracle?
Oracle General 
