•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 428,566 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,603 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Oracle advertiser: Programming Forums
Views: 2326 | Replies: 3
 |
•
•
Join Date: Mar 2007
Posts: 45
Reputation: 
Rep Power: 0
Solved Threads: 1
Light Poster
how to delete more then one row at a time can any body tell how to delete all the tables in a user ata a time
•
•
Join Date: Jan 2007
Location: Austin, TX
Posts: 30
Reputation:
Rep Power: 2
Solved Threads: 0
Light Poster
•
•
•
•
Originally Posted by satish.paluvai 
can any body tell how to delete all the tables in a user ata a time
I have never had to do that so I don't know if there is a built in command to do it. The query below would return all the drop commands you need which you could then run in SQLPLUS. If you were just trying to empty the tables substitute truncate for drop.
SQL Syntax (Toggle Plain Text)
Dan Moore
www.danmoore.org
www.danmoore.org
•
•
Join Date: Mar 2007
Posts: 45
Reputation:
Rep Power: 0
Solved Threads: 1
Light Poster
U Have Tried This One? This Is Not Working. All The Tables R Same Like That Only
|
•
•
•
•
•
•
•
•
DaniWeb Oracle Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Similar Threads
- Add/Delete Registry Keys to Remote Servers (C#)
- Trying to update entire column in database (PHP)
- Problem Updating Row in GridView (ASP.NET)
- How to delete a row in text file? (Visual Basic 4 / 5 / 6)
- Delete from multiple tables (MySQL)
- Populating a fields on a form base on a selected item from a droplist. (PHP)
Other Threads in the Oracle Forum
- Previous Thread: (SQL , PL/SQL) enough for searching jobs in ORACLE ?
- Next Thread: Whats your favorite Oracle "How To..." ?
