Answers for "oracle apex truncate collection"

SQL

1

oracle apex truncate collection

BEGIN
  IF NOT APEX_COLLECTION.COLLECTION_EXISTS('EMPLOYEE_CL') THEN
      APEX_COLLECTION.CREATE_COLLECTION('EMPLOYEE_CL');
  ELSE
      APEX_COLLECTION.TRUNCATE_COLLECTION('EMPLOYEE_CL');
  END IF;
  -- Or
  APEX_COLLECTION.CREATE_OR_TRUNCATE_COLLECTION('EMPLOYEES_CL');
END;

Posted by: Guest on July-14-2021

Source

Code answers related to "oracle apex truncate collection"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#