Interested to Buy Any Domain ? << Click Here >> for more details...
what is the syntax of INSERT command?
- 7 Answers
- 10496 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 |
Explain rename?
How to get execution statistics reports on query statements?
How to insert a record into a table?
How to change user password in oracle?
What is meant by recursive hints in oracle?
How to define default values for formal parameters?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
how the indexes are stored in the Oracle Database?
what are corelated subqueries
Explain integrity constraint?
What is index-organized table in Oracle?
What are triggers in oracle?
Oracle General 
