WE HAVE USE EMP TABLE INSERT COMMAND 1.INSERT INTO EMP(EMPNO,ENAME...)

what is the syntax of INSERT command?

Question Posted / raja

7 Answers
10543 Views
I also Faced
E-Mail Answers

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

What do you understand by a database object? Can you list a few of them?

1018

How to use existing values in update statements using oracle?

1069

definition of cluster and non-clustered index?

3035

What is a table in oracle?

982

Is oracle an open source?

1083

How to drop an index?

962

Explain what are the advantages of views?

1069

Explain rename?

986

Why is oracle so popular?

999

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1384

what is the difference between data migration and production migration.

2347

What is set operator oracle?

984

Why is oracle used?

944

What is the usage of analyze command in oracle?

1095

Does oracle partitioning improve performance?

1000