Interested to Buy Any Domain ? << Click Here >> for more details...
what is the syntax of INSERT command?
- 7 Answers
- 10721 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 |
State all possible different index configurations a table can possibly have?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
Does oracle partitioning improve performance?
What is a tns service name?
What is the usage of save points in oracle database?
Explain the truncate in oracle?
Difference between sub query and nested query ?
19 Answers Keane India Ltd, TCS,
How to use group functions in the select clause using oracle?
How would you begin to troubleshoot an ORA-3113 error?
How to retrieve data from an cursor to a record?
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
What is the difference between RBBMS & DBMS?
Oracle General 
