Make Custom User Authorization Schemes. Oracle Apex. Part-1

How To Change Dynamically Reported SQL Queries In Oracle Apex?

You Can Use Pl / SQL Function Returning SQL Query To Dynamically Modify The SQL Query In Oracle Apex Application Reports.

Follow These Steps To Change Dynamically Reported SQL Queries:

1. Create A New Item First.
Name= P85_TABLE_NAME
Type= Select List
List of Values
Type = SQL Query

Get list of all tables in Oracle Database
Get list of all tables in Oracle Database
SQL Query =

SELECT TABLE_NAME D, TABLE_NAME R FROM USER_TABLES;

2. Create A New Classic Report.
Name = Classic Report.

Source-

Location = Local Database
Type = Function Body returning SQL Query
Language = PL/SQL
PL/SQL Function Body returning SQL Query =

DECLARE
    l_str   VARCHAR2 (4000);
BEGIN
    l_str :=
        CASE
            WHEN :P85_TABLE_NAME IS NULL THEN 'select * from part_7'
            ELSE 'select * from ' || :P85_TABLE_NAME
        END;
    RETURN l_str;
END;

3. I Will Create A Dynamic Action To Submit The Page Opposite The Item.

Create A Dynamic Action
Name- Submit Page
Event = Change
Selection Type = Item(s)
Item(s) = P2_SQL_CODE
Action = Submit Page

We Finished Our Sql Query Report In A Dynamic Way. Now Our Pl / Sql Function Body Returning Sql Query Has Been Completed Correctly? I'll See.

🔗 Demo Application-
URL- Demo Application
Username - demo, Pass- demo

I hope everyone will like it. Please watch the full video,
Comment on any of your problems, I will try my best to solve the problem, In-Shah Allah. Everyone's cooperation is desirable. Visit my blog site, new technology related videos, you will get different types of tutorials of Oracle Apex, and hopefully, you can use them in your daily work.
Please stay tuned by subscribing to the YouTube channel, and encourages new videos to be uploaded.
=================
Visit my site to get more collaborative posts about Oracle Apex and subscribe to my YouTube channel. Thanks.
Comment on any of your issues, I will try my best to solve the problem, In-Shah Allah. Everyone's cooperation is desirable.
Visit my blog site, new technology-related videos, you will get different types of tutorials of Oracle Apex, and hopefully, you can use them in your daily work.
==============================

🙍🏾‍ Md jABER HOSSEN
📲 Mobile- +8801760688286
📨 Email- jaberit786@gmail.com
🌐 FB- facebook.com/mdjaber.hossen1
Please Subscribe to My Channel

Many thanks for visiting the site.

Then Enjoy.........................