can we drop dual table
- 7 Answers
- 13965 Views
- Metric Stream, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / mohamed ibrahim
Yes
Syntax for Drop more than one table
DROP TABLE TABLE1,TABLE2,.....n
| Is This Answer Correct ? | 2 Yes | 11 No |
Answer / rudresh
Yes Dual Table Can Be Dropped .
drop table Tablename1,Tablename2
| Is This Answer Correct ? | 0 Yes | 9 No |
A Table has 10,000 records,How can i get latest 10 dates from the table.so that i can only store those 10 records in to my Resultset Object,to reduce load on my app?
How to clone the database using RMAN back
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?
What is mrc and what is its use? : oracle accounts receivable
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
what is the difference b/w oracle8i and oracle9i
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
can we drop dual table
how can we send a concurrent program output to the clients through mail or fax give me example.
What is supporting issues GL AP and AR?
Oracle General 
