CODEWITHSUNDEEP
oracle-databaseoracle-apexoracle12coracle-apex-5.1
Roberto Hernandez
Roberto Hernandez

Reputation: 8518

Oracle Application Express - Build SQL command workshop

My environment :

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

Live SQL

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.

enter image description here

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

Upvotes: 0

Views: 525

Answers (1)

Vinish Kapoor
Vinish Kapoor

Reputation: 679

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:

enter image description here

Upvotes: 2

Related Questions