can we drop dual table
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 |
what are the tools used for oracle 10g in real time.
What is autocashrule set? : oracle accounts receivable
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
How can you gather statistics on a table?
what is difference between inner join & nested query or subqueries
Difference between transaction type and transaction sources. : oracle accounts receivable
the user should know to which database he is connected currently in oracle
what are important reports in HRMS,GL,AP,AR in oracle apps?
3 Answers IBM, Pathway Technologies, Satyam, Techtimer, Wipro,
Explain how to close periods in ar. : oracle accounts receivable
What is an Oracle database Full Backup?
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
Is there any link between pr form(purchse requisition)and po form(purchase order)