Search This Blog

Wednesday, September 4, 2019

Get Workspace ID

To import a single page at APEX application, we need workspace id. The id can be detected by the following query.


SELECT WORKSPACE, TO_CHAR (WORKSPACE_ID) 
FROM APEX_WORKSPACES;

OR

SELECT APPLICATION_ID, WORKSPACE, TO_CHAR (WORKSPACE_ID) 
FROM APEX_APPLICATIONS;

No comments:

Post a Comment

Search String Inside Oracle Database Objects SQL

SELECT owner, name, type, line, text  FROM dba_source WHERE instr(UPPER(text), UPPER('string')) > 0;