How to create and use temporary table in oracle stored procedure?

by

Just create it first (once, outside of your procedure), and then use it in your procedure. You don’t want to (try to) create it on every call of the procedure.

create global temporary table tmp(x clob)
on commit delete rows;

create or replace procedure...
-- use tmp here
end;

More Related Contents:

  1. How to uninstall / completely remove Oracle 11g (client)?
  2. How can I set a custom date time format in Oracle SQL Developer?
  3. Get counts of all tables in a schema
  4. Determining location of relevant tnsnames.ora file
  5. Default row ordering for select query in oracle
  6. oracle convert unix epoch time to date
  7. Oracle trigger after insert or delete
  8. ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
  9. Difference between a user and a schema in Oracle?
  10. Base64 encoding and decoding in oracle
  11. What is the dual table in Oracle?
  12. Recursion In Oracle
  13. creating parameterized views in oracle11g
  14. Oracle’s default date format is YYYY-MM-DD, WHY?
  15. PL/SQL print out ref cursor returned by a stored procedure
  16. How to use a table type in a SELECT FROM statement?
  17. Default Schema in Oracle Connection URL
  18. Trigger to enforce M-M relationship
  19. How do you get nicely formatted results from an Oracle procedure that returns a reference cursor?
  20. Oracle: how to INSERT if a row doesn’t exist
  21. Valid Date Checks in Oracle
  22. Functions vs procedures in Oracle
  23. Oracle: difference between max(id)+1 and sequence.nextval
  24. HikariCP: What database level timeouts should be considered to set maxLifetime for Oracle 11g
  25. merge update oracle unable to get a stable set of rows
  26. How to get the week day name from a date?
  27. DBMS_JOB vs DBMS_SCHEDULER
  28. How to change default nls_date_format for oracle jdbc client
  29. How to generate a GUID in Oracle?
  30. Escaping single quote in PLSQL

Leave a Comment