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

Answer / eshwari

Dual table is a sample permanent table which come along with
oracle.
for example if u want to knw the sin(45) value then u have
to retreave it from a table.but there is no table to
retreave that value.
so we use the sample table dual as table name in place of
table name in the select query.

ex:select sin(45) from dual;

Query to retrieve record for a many to many relationship ?

0 Answers   Keane India Ltd,

---

Can group functions be used in the order by clause in oracle?

0 Answers  

---

How do I find the database name in oracle?

0 Answers  

---

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

0 Answers  

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

0 Answers  

---

Is it possible to enter only time value into a column of a table in sql?

2 Answers  

---

What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?

1 Answers  

---

What are the data types in oracle?

0 Answers  

---

How to download oracle database 10g xe?

0 Answers  

---

What do database buffers contain?

0 Answers  

---

How to drop an index?

0 Answers  

---

What is Redo Log Buffer in Oracle?

0 Answers   MCN Solutions,

---