what is the syntax of INSERT command?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to write a query with an inner join in oracle?

636


What happens to the indexes if a table is recovered?

652


How to start your 10g xe server from command line?

648


How to export your own schema?

659


How to get a list of all user accounts in the database?

712






Is a rollback possible to any savepoint?

637


How to build data dictionary view an new database?

641


what is the scripts in data base?

1693


What is hot backup and logical backup?

698


What happens in oracle commit?

662


How to start instance with a minimal initialization parameter file?

617


How to change system global area (sga) in oracle?

667


defination of bitmap index

1715


How to pass parameters to procedures?

637


Can we call procedure inside function in oracle?

687