Answer / vyshak.navillae

yes but we need admin privileges.

Answer / hraju_tt

Yes,Dual table can be dropped

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.

Answer / guest

yes

Answer / ss

No Bcoz its System Defined Table we cannot drop..

Answer / mohamed ibrahim

Yes
Syntax for Drop more than one table

DROP TABLE TABLE1,TABLE2,.....n

Answer / rudresh

Yes Dual Table Can Be Dropped .
drop table Tablename1,Tablename2

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

0 Answers  

What is the Query Optimizer. How you optimize your qeury.

2 Answers   Ericsson,

pl help me, i want oracle HRMS training institute address,in chennai

8 Answers  

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

2 Answers  

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

0 Answers   HCL,

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  

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?

7 Answers   TCS,

what is the difference b/w oracle8i and oracle9i

3 Answers   iGate,

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

0 Answers   Pathway Technologies,

What Are Cross Validation & Adi?

0 Answers   Oracle,

How to update the simple views?give me example?if the table having 100 records and created a view on this table. if i can update the table then how to update the views

2 Answers   Cap Gemini, Syntel,

Explain the use of table functions.

0 Answers