Interested to Buy Any Domain ? << Click Here >> for more details...
can we drop dual table
- 7 Answers
- 16203 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 |
When the procedures or packagess become invalidate
what is the querry to get first 10 records from the emp table?(emp no is the primary key)
can u give guidance abt packages of plsql
What is auto invoicing? Explain : oracle accounts receivable
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
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?
types of receipts and detail desription about recipts and tables effected by receipts?
what is shared memory?
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
Can we get the deleted Record again if the delete transaction has been committed.
what is the difference between TRUNCATE and DELETE command in SQL
23 Answers ICICI, Saama Tech, SkyTech, TCS,
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
Oracle General 
