Tables

UC_PLUGINSPRO_LICENSE

The table stores information about plug-ins pro licenses activated.

Columns

Column Name	Data Type	Nullable	Default	Primary Key
PLUGIN	VARCHAR2(250)	No	-	Yes
API_KEY	VARCHAR2(250)	Yes	-	-
LICENSE_KEY	VARCHAR2(500)	Yes	-	-
CUST_KEY	VARCHAR2(250)	Yes	-	-
CREATED_ON	DATE	No	sysdate	-
VALID_TILL	DATE	Yes	-	-

Sequence

None

Triggers

None

UC_FROALA_SAMPLE_BLOBS

The table stores uploaded images using the plug-in RESTful service.

Columns

Column Name	Data Type	Nullable	Default	Primary Key
ID	NUMBER	No	-	Yes
FILE_NAME	VARCHAR2(4000)	No	-	-
FILE_MIMETYPE	VARCHAR2(4000)	No	-	-
FILE_CONTENT	BLOB	No	-	-
SESSION_ID	VARCHAR2(4000)	Yes	-	-
STATIC_ID	VARCHAR2(4000)	Yes	-	-
FOLDER	VARCHAR2(4000)	Yes	-	-
CREATED_ON	DATE	No	sysdate	-

Sequence

CREATE SEQUENCE   "UC_FROALA_SAMPLE_BLOBS_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 29413 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  GLOBAL
/

Triggers

CREATE OR REPLACE EDITIONABLE TRIGGER  "BI_UC_FROALA_SAMPLE_BLOBS" 
  before insert on "UC_FROALA_SAMPLE_BLOBS"                
  for each row   
begin    
  if :NEW."ID" is null then  
    select "UC_FROALA_SAMPLE_BLOBS_SEQ".nextval into :NEW."ID" from sys.dual;  
  end if;  
end;  
 
/
ALTER TRIGGER  "BI_UC_FROALA_SAMPLE_BLOBS" ENABLE
/

UC_FROALA_SAMPLE_CLOBS

Columns

Column Name	Data Type	Nullable	Default	Primary Key
ID	NUMBER	No	-	Yes
SESSION_ID	NUMBER	No	-	-
CLOB_CONTENT	CLOB	Yes	-	-
STATIC_ID	VARCHAR2(4000)	Yes	-	-
DESCRIPTION	VARCHAR2(4000)	Yes	-	-
CREATED_ON	DATE	No	sysdate	-

Sequence

CREATE SEQUENCE   "UC_FROALA_SAMPLE_CLOBS_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 11778 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  GLOBAL
/

Triggers

CREATE OR REPLACE EDITIONABLE TRIGGER  "BI_UC_FROALA_SAMPLE_CLOBS" 
  before insert on "UC_FROALA_SAMPLE_CLOBS"                
  for each row   
begin    
  if :NEW."ID" is null then  
    select "UC_FROALA_SAMPLE_CLOBS_SEQ".nextval into :NEW."ID" from sys.dual;  
  end if;  
end;  
 

/
ALTER TRIGGER  "BI_UC_FROALA_SAMPLE_CLOBS" ENABLE
/

The table stores the sample application CLOB values modified with the plug-in.

UC_FROALA_SAMPLE_CLOB_BLOBS

The table stores uploaded image BLOB content (table UC_FROALA_SAMPLE_BLOBS) in the context of saved rich text document CLOB value (table UC_FROALA_SAMPLE_CLOBS).

Columns

Column Name	Data Type	Nullable	Default	Primary Key
ID	NUMBER	No	-	Yes
BLOB_ID	NUMBER	No	-	-
CLOB_ID	NUMBER	No	-	-
IMAGE_URL	VARCHAR2(4000)	No	-	-

Sequence

CREATE SEQUENCE   "UC_FROALA_SAMPLE_CLOB_BLOBS_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 621 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  GLOBAL

Triggers

CREATE OR REPLACE EDITIONABLE TRIGGER  "BI_UC_FROALA_SAMPLE_CLOB_BLOBS" 
  before insert on "UC_FROALA_SAMPLE_CLOB_BLOBS"               
  for each row  
begin   
  if :NEW."ID" is null then 
    select "UC_FROALA_SAMPLE_CLOB_BLOBS_SEQ".nextval into :NEW."ID" from sys.dual; 
  end if; 
end; 

/
ALTER TRIGGER  "BI_UC_FROALA_SAMPLE_CLOB_BLOBS" ENABLE
/

UC_FROALA_SAMPLE_LANGUAGES

The table stores the list of editor languages offered by the sample application. It is static reference data, seeded once when the supporting objects are installed.

Before release 26.1.0 this list was written into a per-session APEX collection on every new session. Moving it into a table removed 98 collection members per session.

Columns

Column Name	Data Type	Nullable	Default	Primary Key
LANG_CODE	VARCHAR2(10)	No	-	Yes
LANG_NAME	VARCHAR2(100)	No	-	-