Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ch.ramesh
Drop is used to drop the total table
from data base
syntax: drop table <tablename>
note: there is no rollback command for drop
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What do you mean by merge in oracle and how can we merge two tables?
What are the different types of modules in oracle forms?
How to use values from other tables in update statements using oracle?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What is the implicit cursor in oracle?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
Explain integrity constraints?
Explain temporal data types in oracle
How to upsert (update or insert into a table)?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What is rowid and rownum in oracle?
Why cursor variables are easier to use than cursors?
Explain do view contain data?
What are the predefined tablespaces in a database?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
