can we drop dual table

Answer Posted / priya

Dual table is a single row , single coloumn table.
with single datatype VARCHAR2(1).
Yes we can Drop by the syntax
Drop table SYS DUAL;

But it is not a good practice to drop because we can't recreate Dual table.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I would like to study certification course in Data base adminidtrator then where would i go to study this course?

1741


can u pls share responsibilities for production how to environment in odi?and how to generate report ?

1917


Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

1967


i want to know about the javaBean.what is its purpose and how it can use in Forms.

1843


Why more redos are generated when the oracle database is in begin backup mode?

676






how to replace not in with not exist?

3203


Can we modify approve purchase order?if yes what is navigation?

1559


A scenario for amount correction & how to use amount correction functionality in AP invoices

1658


hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me

1780


what are the API of GL,PO,AP

1785


What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

632


CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

1624


what is difference between inner join & nested query or subqueries

2492


what is the link between suppliers and banks in ap module in oracle apps? And also query?

2028


How would you determine who has added a row to a table?

1806