Answer Posted / saraswathi muthuraman

Oracle will have a default table called 'DUAL'.
Dual table will have only one column "DUMMY". U cann't
insert values into dual table. By default, a row will
existing in dual table.

SQL> desc dual;
DUMMY varchar2(1)

SQL> select * from dual;

X

1 row selected.

SQL> insert into dual values (10);
insert into dual values (10)
*
ERROR at line 1:
ORA-01031: insufficient privileges


U can create you own table with the name of dual.

SQL> create table dual(xy number,zz number);

Table created.

SQL> desc dual;
xy number
zz number

u can insert values in you own dual table.

What is a dynamic performance view in oracle?

602

---

What is the difference between $oracle_base and $oracle_home?

579

---

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2502

---

what is port in oracle? how is it related to database application.

1434

---

Explain the use of grant option in exp command.

578

---

---

What is transaction control statement and how many types of transaction control statement in Oracle?

562

---

State all possible different index configurations a table can possibly have?

562

---

What is an oracle database?

609

---

Explain user account with reference to oracle.

526

---

How to define default values for formal parameters?

590

---

How to use "startup" command to start default instance?

541

---

How to drop an index?

539

---

what are actual and formal parameters?

596

---

Is there any function in oracle similar like group_concat of mysql?

537

---

How to execute a stored procedure in oracle?

616

---