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

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;

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