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

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

1838


What do you mean by hz_ in customer tables? : oracle accounts receivable

641


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

1902


which one is currently in used software cmpanies.

1658


what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

1831






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

1726


Explain about party and customer in ar : oracle accounts receivable

723


I need a Technical evaluation between Oracle and SAP ? please do a need ful.

1488


What is the difference between oracle media recovery and crash recovery?

669


What is Restricted Mode of Instance Startup in Oracle?

673


What is Tax Categories?

1624


Could you please let me know the interfaces in OM / FA??

1734


we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.

1869


What is supporting issues GL AP and AR?

1983


1. What is PO rate variance gain and loss?

2312