skip to main
|
skip to sidebar
Thoughts on Technology
Saturday, October 3, 2009
Delete all rows in Oracle database
1. Run this:
select 'delete from ', table_name, '; ' from user_tables;
2. run and script the output into a file.
3. copy paste the commands from the file into your SQL editor.
done
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)
Facebook
Blog Networks
Blog:
Thoughts on Technology
Topics:
java
,
IT
Join my network
Blog Archive
▼
2009
(7)
►
November
(1)
▼
October
(1)
Delete all rows in Oracle database
►
September
(1)
►
July
(1)
►
April
(1)
►
February
(1)
►
January
(1)
►
2008
(15)
►
December
(5)
►
November
(10)
►
2007
(1)
►
November
(1)
About Me
Allan's
View my complete profile