RSS

Re: how to delete more then one row at a time

Please support our Oracle advertiser: Programming Forums

how to delete more then one row at a time

•

Join Date: Jan 2007

Location: Austin, TX

Posts: 30

Reputation: Memento is an unknown quantity at this point

Rep Power: 2

Solved Threads: 0

Memento

Offline

Light Poster

Re: how to delete more then one row at a time

Mar 29th, 2007

•

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.

 Help with Code Tags 
 SQL Syntax (Toggle Plain Text) 
SELECT 'DROP '||table_name|| ' \'
  FROM all_tables
 WHERE owner = 'USER TO PURGE'
 
SELECT 'DROP '||table_name|| ' \'
  FROM all_tables
 WHERE owner = 'USER TO PURGE'

Dan Moore
www.danmoore.org

DaniWeb Home > Forums > Web Development > Databases > Oracle > how to delete more then...

Re: how to delete more then one row at a time

how to delete more then one row at a time

Re: how to delete more then one row at a time