Hi,
I am looking to delete all the table data of particular schema. I have written a script like this:
BEGIN
FOR c IN (SELECT table_name FROM user_tables)
LOOP
EXECUTE IMMEDIATE ('SELECT COUNT(*) FROM' || c.table_name);
END LOOP;
END;
But it doesn't seem to work. Can some body help how it can be achieved?