• Home
• org.kuali.ole
• ole-test-sql
• 1.6.2
• source code
• ole-test-sql.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sql.oracle.ole-test-sql.sql Maven / Gradle / Ivy

-----------------------------------------------------------------------------
-- EN_UNITTEST_T
-----------------------------------------------------------------------------
DECLARE temp NUMBER;
BEGIN
	SELECT COUNT(*) INTO temp FROM user_tables WHERE table_name = 'EN_UNITTEST_T';
	IF temp > 0 THEN EXECUTE IMMEDIATE 'DROP TABLE EN_UNITTEST_T CASCADE CONSTRAINTS PURGE'; END IF;
END;
/

CREATE TABLE EN_UNITTEST_T
(
      COL VARCHAR2(1)
    

)
/

ALTER TABLE EN_UNITTEST_T
    ADD CONSTRAINT EN_UNITTEST_TP1
PRIMARY KEY (COL)
/