Answer / mahaveer kumar h.v.

INSERT INTO table_name (Col_name1,Col_name2,Col_name3...)
VALUES (Col_value1,Col_value2,Col_value3...);

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)

Answer / shree

INSERT INTO table_name (Col_name1,Col_name2,Col_name3...)
VALUES (Col_value1,Col_value2,Col_value3...)

Answer / subba rao

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>)

Answer / arkchowdary

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'....)

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');

Answer / pushkar

INSERT INTO TABLE
VALUES (VAL1,VAL2,VAL3,...)

Note: SPECIFY THE RIGHT NUMBER OF COLUMNS AND THE
appropriate null values by writing "NULL" .

Explain database link?

0 Answers  

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

0 Answers  

What is the difference between SQL and SQL Server?

2 Answers   CTS, TCS,

What is a cursor and what are the steps need to be taken?

0 Answers  

what is the syntax of UPDATE command?

8 Answers  

what is the syntax of DROP command?

10 Answers  

What is the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN?

1 Answers  

Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?

6 Answers   IBM,

what are the database links ?

2 Answers  

How do we display rows from the table without duplicates?

0 Answers  

What is a Schema ?

6 Answers  

Explain the use of indexes option in exp command.

0 Answers