ANYONE CAN TELL ME THAT WHY THIS CODE IS GIVING ME AN ERROR OF TABLE OT CLUSTER KEY WORD IS MISSING? [closed]

by

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!!

More Related Contents:

  1. What is the replacement of cursor foreach in oracle pl/sql?
  2. Can you SELECT everything, but 1 or 2 fields, without writer’s cramp?
  3. Printing the value of a variable in SQL Developer
  4. PL/SQL, how to escape single quote in a string?
  5. Oracle PL/SQL – Raise User-Defined Exception With Custom SQLERRM
  6. Passing an array of data as an input parameter to an Oracle procedure
  7. Convert comma separated string to array in PL/SQL
  8. UTL_FILE.FOPEN() procedure not accepting path for directory?
  9. Oracle stored procedure with parameters for IN clause
  10. PL/SQL ORA-01422: exact fetch returns more than requested number of rows
  11. Get resultset from oracle stored procedure
  12. ways to avoid global temp tables in oracle
  13. Split function in oracle to comma separated values with automatic sequence
  14. check if “it’s a number” function in Oracle
  15. ORA-06508: PL/SQL: could not find program unit being called
  16. How to return a resultset / cursor from a Oracle PL/SQL anonymous block that executes Dynamic SQL?
  17. Create Pivot view in SQL from a SQL table
  18. SQL*Plus how to accept text variable from prompt?
  19. SQL Fiddle Output Error
  20. Why doesn’t PL/SQL respect privileges granted by Roles?
  21. oracle PL/SQL how to calculate range ip for IPv6 cidr
  22. if (select count(column) from table) > 0 then
  23. Can We use threading in PL/SQL?
  24. Why cannot I use bind variables in DDL/SCL statements in dynamic SQL?
  25. Trying to export a Oracle via PL/SQL gives a date of 0000-00-00
  26. What is the algorithm used by the ORA_HASH function?
  27. passing in table name as plsql parameter
  28. Reading clob line by line with pl\sql
  29. BEGIN – END block atomic transactions in PL/SQL
  30. Escaping single quote in PLSQL

Leave a Comment