DECLARE
BEGIN
--Bye Tables!
FOR i IN (SELECT ut.table_name
FROM USER_TABLES ut) LOOP
EXECUTE IMMEDIATE 'drop table '|| i.table_name ||' CASCADE CONSTRAINTS ';
END LOOP;
END;
Showing posts with label Delete. Show all posts
Showing posts with label Delete. Show all posts
Saturday, June 13, 2015
Oracle - PL/SQL - Delete all table
Oracle - PL/SQL - Delete all sequence
DECLARE
BEGIN
--Bye Sequences!
FOR i IN (SELECT us.sequence_name
FROM USER_SEQUENCES us) LOOP
EXECUTE IMMEDIATE 'drop sequence '|| i.sequence_name ||'';
END LOOP;
END;
Tuesday, September 4, 2012
Unix : Delete file or Folder
rm foo
delete the file named "foo"
rm a*
delete all files with names beginning with "a"
rm *.jpg
delete all files with names ending in ".jpg"
rm -R temp
delete the directory named "temp", and all of its contents
Subscribe to:
Posts (Atom)