How do I create a SQL Command in an Oracle Apex application?
❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
OrclQA.Com is a question and answer forum for programmers.
Here anyone can ask questions and anyone can answer to help others.
It hardly takes a minute to sign up and it is 100% FREE.
Vinish Kapoor
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 Kapoor
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 Kapoor
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 Kapoor
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