Skip to main content

Half a Century of Trophies

What is Oracle Dev Gym?

Join the Oracle Dev Gym (FREE!) and build your Oracle technology muscles by taking workouts, quizzes and even entire classes on SQL, PL/SQL, database design, logic and more. Learn More Get Started.

The trophies I have collected,

Minor milestone reached. Yes, I have collected half a century of trophies from Oracle Dev Gym by taking quizzes, attending classes, and doing workouts. (SQL, PL/SQL, APEX, Java and Database)



Here's my tweet,
The best way to improve your Oracle skills,

1) You want to improve your SQL, PL/SQL, APEX, Java, Database Design, Security, Logic and etc knowledge?

3) You can do workouts, attend classes, play weekly tournament, or just do random quizzes.

4) It's fun and you can spend as little or as much time as you want.

Happy Coding!

Comments

Popular posts from this blog

Printing Page Numbers in RTF Template [Oracle BI Publisher]

Here I am giving an example to print the page numbers dynamically in the RTF (Rich Text Format) template. Step 1:  Go to page footer and copy and paste the below script. Page |  <?fo:page-number?>  of  <?fo:page-number-citation:xdofo:lastpage-joinseq?> <fo:page-number> :   This is the object, which is used to represent the current page-number. <?fo:page-number-citation:xdofo:lastpage-joinseq?> :  This is the syntax, which is used to represent the total number of pages. Step 2:  Load the XML and preview the result. Output: That's it. References: fo:page-number Printing Page Number Code in Oracle XMLP RTF Template

Oracle Application Express Views (APEX)

Application Express Views Search SELECT * FROM apex_dictionary WHERE column_id = 0; View Comment Parent View APEX_APPLICATIONS Applications defined in the current workspace or database user. APEX_WORKSPACES APEX_APPLICATION_ALL_AUTH All authorization schemes for all components by Application APEX_APPLICATIONS ...

Save Selected Interactive Grid Records into a Collection - Oracle APEX

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  ...