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.

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

1633

---

How to retrieve data from an explicit cursor?

1039

---

How can we delete duplicate rows in a table?

954

---

What is a tns service name?

988

---

6. Display the client name and order date for all orders using the traditional method.

2290

---

Explain the dml?

957

---

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2045

---

How oracle handles dead locks?

1054

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2302

---

What is the difference between substr and instr?

1023

---

How to change user password in oracle?

1005

---

What is an oracle recycle bin?

978

---

What are the uses of Database Trigger ?

1686

---

Explain an exception?

971

---

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2166

---