Question : I am not able to find the right documentation on setting specific timings for materialized view refresh for […]
Tag: oracle-apex
Can not install oracle apex on GNU/Linux (db 12c)
Question : I have to install oracle apex on oracle database 12.2.0.1.0, database is on GNU/Linux server. I followed instructions […]
PL/SQL operating system call
Question : I’m trying to lauch a system call from Oracle Apex, directly or indirectly. It seems to only accept […]
How to access apex data from sqlplus?
Question : I have setup an oracle database in my Ubuntu machine. Now I have took the following steps to […]
Why does Oracle APEX Shared_Servers = 0 Break Apex 3.2
Question : Installed APEX 3.2 and set the shared_servers = 5 and APEX works great, but breaks other processes with […]
Switching alias in subquery equality leads to different result
Question : Trying to learn sql queries recently and as the title says I stumbled upon some “behavior” i didn’t […]
How do I discover the Oracle Express workspace name?
Question : Is there a way to discover the WORKSPACE name if I’ve forgotten it? I cannot login to the […]
User with dba privs can’t login to APEX, but can from SQL*Plus
Question : I’m using Oracle 11gR2 XE. A user with dba privileges can’t log in to the APEX interface, but […]
How to know max specified memory in Oracle XE11g release 2?
Question : What is the max specified memory in Oracle XE11g release 2? I have read in Oracle documentation that […]