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 table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

872

---

Can the query output be sorted by multiple columns in oracle?

741

---

What is data block in Oracle?

834

---

How would you begin to troubleshoot an ORA-3113 error?

1820

---

How to drop an index in oracle?

797

---

How can you use check constraints for self referential integrity?

719

---

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2138

---

How can you merge two tables in oracle?

736

---

What are the built-in functions used for sending Parameters to forms ?

3072

---

How to rename a column in an existing table?

786

---

What is the difference between count (*), count (expression), count (distinct expression)?

771

---

What is a sub query? Describe its types?

759

---

Explain oracle left join with an example?

759

---

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

1926

---

What do you mean by merge in oracle and how can we merge two tables?

794

---