Interested to Buy Any Domain ? << Click Here >> for more details...
what is the syntax of INSERT command?
- 7 Answers
- 10742 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 is the usage of analyze command in oracle?
What are temporal data types in oracle?
What happens if recursive calls get out of control?
how to find the n'th highest salary from emp ?
What is the quickest way to export a table to a flat file?
26. Display the earliest shipping date in the format: DD/MON/YYYY
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 are the uses of linked server and explain it in detail?
How to insert a new row into a table in oracle?
i have a table and it has constraints and i want to get "ALTER TABLE table_name ADD CONSTRAINT constraint_name constraint type" this code must be in string type please help me if you want, i can give more explainings
Can you use a commit statement within a database trigger?
What are oracle functions?
Oracle General 
