Now I am going to describe about a Fixed static value by which we can retrieve data from database by Select List, Popup Lov.
Here I show an example too.
1. First Create a item with Select List /Popup Lov and set a static value in Default option Default value.
2. Then make a query like this
select 'ALL' ret ,'ALL' dis from dual
union all
select column_name ret , column_name dis from TABLE ;
Now you can get data respecting this query and by showing Static Value.
Muhammad Abdul Qaium is a Database Engineer/Oracle Apex Developer/BI Developer (in Atlanta, USA) who is an Oracle Certified Cloud Architect Professional, OCI Autonomous DB specialist as well as Oracle Business Intelligence Foundation Suite 11g Certified Implementation Specialist with extensive expertise in Database design , PL/SQL, Oracle Apex, Microsoft SSIS, ETL, Power BI, Qlik Sense, OBIEE. Contact: qaiuminfo@gmail.com
Search This Blog
Subscribe to:
Post Comments (Atom)
Check Difference Between Two Database Objects
Step-1. Create Two DBLINK to connect with Two Database then Step-2. define logindb= DBLINKONE define remotedb= DBLINKTWO define schema_name=...
-
Search by keyword from Oracle Database Objects. select owner, type, name, line, text from dba_source where 1 = 1 and text like '%TEXT Y...
-
We Can Export Application Components individually from Oracle Apex. Application > Shared Components > Export Application Compo...
No comments:
Post a Comment