what is the syntax of INSERT command?
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 |
Which is better Oracle or MS SQL? Why?
how to store only time in a data base table
What is a read only transaction in oracle?
How to rename a tablespace in oracle?
What is the difference between sharding and partitioning?
There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees who doesn't belong to any dep
What is Database Trigger ?
Which environment variables are absolutely critical in order to run the OUI?
What is Virtual Private Database in Oracle?
How to add a new column to an existing table with a default value?
What is truncate oracle?
Display those managers salary greater than the average salary of his employees?(Based on oracle standard Emp table)