About Oracle and Oracle ā'pěks (#orclapex)

Here I am giving an example to save selected interactive grid records into a oracle apex collection. Step 1: Create a new blank page. Note: Mine was page 20. You will need to update reference to " P20 " with your page number if it's different. Step 2: Create a new interactive grid report region to the page using below query. Set Static Id "EmpDetails" to the region. SELECT  *     FROM   ( SELECT  emp . empno ,                emp . ename ,                emp . JOB ,                dept . dname department ,                dept . loc  LOCATION ,                mgr . ename  ...

   What is Oracle ACE Program? The  Oracle ACE Program  is designed to recognize and reward members of the Oracle Technology and Applications communities for their contributions. The Oracle ACE Program award is given for a  one year term  and past members are  Oracle ACE Alumni . I am happy to announce that I became an Oracle ACE Associate  in September 2020. Thanks Oracle  and Oracle ACE Program to honored me as an Oracle ACE Program Member and for this wonderful award. Hard work Pays off!!!.  I have received the Oracle ACE Associate Award (based on my significant contributions and activity in the oracle technical community) and my profile has been added in the Oracle ACE Directory . What else i need more? An award is a morale booster, An award gives you that high no drug in this world can give, today I am totally on a new high, My Oracle Ground Breakers award has been approved and I was on Cloud, but moments I realized that there is ...

  Here I am giving an example to find out the tables without having relationships in oracle database. Tables that are not referencing and are not referenced by other tables. Something we called "Loner Tables" . Query 1: All tables accessible to the current user in Oracle database that don't have foreign keys and are not referenced by other tables with foreign keys. SELECT  t . owner   AS  schema_name ,        t . table_name ,         '>- No FKs'  fks    FROM  sys . all_tables t    LEFT   JOIN   ( SELECT   DISTINCT   owner   AS  schema_name ,                     table_name                 FROM  sys . all_constraints     ...

Here I am giving an example to find out number of tables by the number of rows in oracle database. Query 1: Number of all tables accessible to the current user in Oracle database by the number of rows grouped into predefined intervals . SELECT  row_interval ,         count ( * )   AS  no_of_tables    FROM   ( SELECT   owner ,                table_name ,                num_rows ,                 CASE                   WHEN  num_rows >  1000000000                   THEN   '1b rows and more' ...

  Here I am giving an example to fetch recently created tables in oracle database. Query 1: All tables accessible to the current user in Oracle database that were created within the last 30 days. SELECT   owner    AS  schema_name ,        object_name  AS  table_name ,        created    FROM  sys . all_objects   WHERE  object_type =  'TABLE'    -- excluding some Oracle maintained schemas     AND   owner   NOT   IN   ( 'ANONYMOUS' , 'CTXSYS' , 'DBSNMP' , 'EXFSYS' ,   'LBACSYS' ,                         'MDSYS' ,   'MGMT_VIEW' , 'OLAPSYS' , 'OWBSYS' , 'ORDPLUGINS' ,                  ...