How do I create a SQL Command in an Oracle Apex application?
ShimulProfessional
How do I create a SQL Command in an Oracle Apex application?
10 Answers
You must login to add an answer.
Hey, Dev!
Are you looking for a forum full of active developers to help you?
So if you want to:
➡️ Get answers for your development issues
➡️ Help others
➡️ Write an article
➡️ Get rewarded for your active participation
Then you are going to love this place.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
How do I create a SQL Command in an Oracle Apex application?
You must login to add an answer.
Vinish
What kind of SQL command you want to create, and what is the purpose?
Please explain your question in detail.
Shimul
In Application, Admin user will be able to see the result by QUERY from SQL COMMAND. It May Admin user will see the results in a classic report.
Vinish
Do you mean you want to create a classic report based on a SQL query?
Shimul
i need a sql developer in an Application . where admin user can write sql and then it will return the Data (UI Like Sql Developer). which will be decoded and displayed . (Export Option to export the data as well)
Huy Nguyen
Shimul : You can go SQL workshop of Apex , then run SQL commands, write select query and run, it will give the result of query.
Shimul
I Need it in Application. Not Developer Mode.
Vinish
I have created an Oracle Apex application for you for this purpose. You can download it from the following link:
https://github.com/devvinish/sql-command
It is a one-page app. Open the home page and see the code to know how I built it. You can add functionality further.
Currently, this supports only SQL Select statements. Below is the screenshot of this app.
najeeb Alikhel
i downloaded your this app but not compitable in my oracle apex 20.1 version why
Vinish
It is not compatible because I used the printing option of 20.2 in the classic report.
Shimul
Its work Appropriately . Thank you So Much