It is very clear that you are not creating a dynamic query properly. Space is missing between TABLE'|| C.table_name
It must be something like this:
EXECUTE IMMEDIATE 'TRUNCATE TABLE '|| C.table_name; -- see space after TABLE
Cheers!!
3
solved ANYONE CAN TELL ME THAT WHY THIS CODE IS GIVING ME AN ERROR OF TABLE OT CLUSTER KEY WORD IS MISSING? [closed]