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 are the common oracle dba tasks?

1068

---

How to call a stored function with parameters?

968

---

what is difference between sql plus and sql*plus? (not sql and sql plus).

3811

---

What is parameterized cursor in oracle?

1064

---

How to rename an index in oracle?

1055

---

Explain oracle data types with examples?

964

---

What is query image?

921

---

How to load a large xml file?

1001

---

What are the differences between char and varchar2 in oracle?

1071

---

How to add another datafile to a tablespace?

989

---

How to create a single index for multiple columns?

973

---

How index is implemented in oracle database?

942

---

What to do if the binary spfile is wrong for the default instance?

997

---

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2291

---

How to define a variable to match a table column data type?

936

---