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 does coalescing a tablespace do?
as a technical developer in oracle applications which type errors feced in your experience sofar
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
0 Answers Punjab National Bank,
what is the link between suppliers and banks in ap module in oracle apps? And also query?
What is the mandatory setup in cyclecount ?
default triggers available for reports
What is the difference between conversions and interfaces? : oracle accounts receivable
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
please send me oracle pl/sql exp resume. and also faqs...
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
how to replace not in with not exist?
How would you determine who has added a row to a table?