I want to delete all the date of all the table in a scheman.
but i got error at execute immediate statement.
can any body help me.
thanks
Expand|Select|Wrap|Line Numbers
- DECLARE
- query varchar2(700);
- CURSOR cu_idx IS
- SELECT *
- FROM user_tables;
- BEGIN
- FOR cur_rec IN cu_idx LOOP
- query:= 'delete from ' || upper(cur_rec.table_name) || ';' ;
- execute immediate query;
- END LOOP;
- END;
DECLARE
*
ERROR at line 1:
ORA-00911: invalid character
ORA-06512: at line 9