How do I create a SQL Command in an Oracle Apex application?
Share
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
What kind of SQL command you want to create, and what is the purpose?
Please explain your question in detail.
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.
Do you mean you want to create a classic report based on a SQL query?
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)
@Shimul : You can go SQL workshop of Apex , then run SQL commands, write select query and run, it will give the result of query.
I Need it in Application. Not Developer Mode.
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.
i downloaded your this app but not compitable in my oracle apex 20.1 version why
It is not compatible because I used the printing option of 20.2 in the classic report.
Its work Appropriately . Thank you So Much