Oracle Application Express - Build SQL command workshop
My environment :
- Oracle Database 12.2
- Oracle Application Express 5.1.4
I am having a lot of issues with users running queries with SQL Developer, a problem I already described in this question some days ago
Oracle Parallel Query behaviour with IDE tools as SQL Developer or Toad
As a intermediate solution, I was wondering on how Oracle did build the SQL Worksheet in Oracle Live SQL. You might have a look here
My idea would be to build a small apex application that might provide a similar functionality, thereby the users can access to a SQL editor of some kind and run queries. With this method, I can use the Java pool of ORDS through Tomcat to take care of reuse existing sessions and close ones with no use, avoiding my current issue with so many active parallel slaves in status active when their query coordinators are inactive in SQL Developer. I know for a fact that with a Java Pool I don't suffer the problem of slaves in status active when their parent processes are inactive.
I know that I might create a user with only access to the SQL Workshop, removing it from accessing the other components of the workspace, but that implies that the user must have access to the workspace itself, which I can't do in Production, unless I don't find any other way.
Does anyone know of any plugin or any other way that I can have the same in-built functionality but inside an application ?
Thank you
I have created an application in Oracle Apex 20.2. It is the same as the option SQL Commands in SQL Workshop. You can download it from GitHub via the following link:
https://github.com/devvinish/sql-command
Below is the screenshot of the app:
- Oracle Scheduler Job Failing
- Event read by other session causing blocks
- Create date periods based on two tables
- Oracle SQL query using regexp_substr to get string between 2 strings
- Missing expression in Oracle Function
- Examine all REF CURSOR outputs from stored procedure called in a loop
- PLS-00382: "expression is of wrong type" when opening REF CURSOR on stored procedure called in a loop
- How to join two tables where the entries are listed as rows in one table and as columns in the other table?
- PowerShell Script Failing at insert records
- How to resolve the following AWS Glue error while writing to Redshift using Spark: "ORA-01722: invalid number"?
- How to create an oracle.sql.ARRAY object?
- Select rows with same item code but different value in another column
- SQL select distinct with condition
- How to pretty format the printing of SQL queries in SQLAlchemy
- JetBrains PhpStorm / DataGrip introspecting Oracle database error
- Is there any way to maintain large scale data rules efficiently in SQL?
- How to check if input parameter of timestamp type in oracle stored procedure is null?
- How can I number the instance of a duplicate record?
- How to convert oracle regex pattern into Databricks compatible version?
- oracle add_months function differs from Java
- How to export (expdp) a tablespace Oracle express 21c?
- How to query the distribution (grouped by value range) of a column value in Oracle?
- Avoid ZERO and NULL Record
- BI-Publisher RTF Template: Repeat colums or rows horizontally first before new page
- ORA-20999: Failed to parse SQL query! ORA-06550: line 4, column 82: ORA-00936: missing expression
- django how to see sql query when running tests?
- How to identify rows that add up (sum) to a specific amount
- oracle sql developer - HOW TO put together the results of 2 selects that have nothing in common
- No more data to read from socket error
- How Grant Create Foreign Key on another schema?