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.

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2184

---

How to view all columns in an existing table?

979

---

Can you have more than one content canvas view attached with a window ?

2370

---

What is connection pooling in oracle?

1018

---

Give the advantages and disadvantages of clusters.

1096

---

Difference between inner join vs where ?

1096

---

What to do if dba lost the system password?

1244

---

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2089

---

Explain the use of indexes option in imp command.

1259

---

What are the limitations of check constraint?

1073

---

What is max rowid in oracle?

1081

---

Compare and contrast between sql and sql server and explain its various functions?

1016

---

What is the quickest way to fetch the data from a table?

1100

---

What is a nvl function?

1093

---

What is an oracle and why it is used?

1212

---