RSS

how to delete more then one row at a time

Please support our Oracle advertiser: Programming Forums

Thread Tools Display Modes

Views: 2438 | Replies: 3

•

Join Date: Mar 2007

Posts: 45

Reputation: satish.paluvai is an unknown quantity at this point

Rep Power: 0

Solved Threads: 1

satish.paluvai satish.paluvai is offline

Offline

Light Poster

how to delete more then one row at a time

Mar 29th, 2007

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: 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'