Skip to main content

Modifying Oracle APEX 18.2 Application Login Page

select * from apex_dictionary

Objective:

To modify you oracle apex application login page as per your imagination.

Fig 1: Actual Login Page

Step 1: Go to shared components => Static or Application files and upload required image.

Design 1:

Just add below CSS in inline CSS option in page header.

.t-PageBody--login .t-Body { background-image: url(#APP_IMAGES#highway_dubai-1000x600.jpg); background-size: 100% auto; } .t-Login-header { display: none; } .t-Login-header { display: none; } .t-Login-container { float: right; margin-right: 2%; top: 0px; right: 0; position: absolute; } .t-Login-region { box-shadow: none; padding: 20px 15px 10px 15px; width: 67%; float: right; margin-top: 70px; background: rgba(255, 255, 255, 0.59); border-radius: 17px; } .t-Button--hot { font-family: Poppins-Regular; font-size: 15px !important; width: 60% !important; margin-left: 20% !important; padding: 13px 24px !important; background: #ec5e66 !important; font-weight: normal !important; border-radius: 10px; } .t-Alert { top: 10px !important; position: absolute !important; left: inherit !important; }

Output



Fig 2: Custom Login Page
Design 2:

Just add below CSS in inline CSS option in page header.

.appIcon.sample_ig { background-position: -192px -192px; } .appIcon { display: inline-block; width: 64px; height: 64px; background-repeat: no-repeat; border: none; -webkit-border-radius: 4px; -moz-border-radius: 4px; border-radius: 4px; -webkit-box-shadow: 0 0 1px rgba(0, 0, 0, 0.75) inset; -moz-box-shadow: 0 0 1px rgba(0, 0, 0, 0.75) inset; box-shadow: 0 0 1px rgba(0, 0, 0, 0.75) inset; margin-right: 8px; vertical-align: middle; } span.t-Login-logo { backgroung-size: cover; width: 50px; height: 50px; } .t-PageBody--login .t-Body { background-image: url(#APP_IMAGES#highway_dubai-1000x600.jpg); background-size: 100% auto; } .t-Login-region { box-shadow: none; padding: 20px 15px 10px 15px; float: right; width: 100%; background: rgba(255, 255, 255, 0.59); border-radius: 17px; }

Output
Fig 3: Custom Login Page

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

Generating the report with APEX_DATA_EXPORT

With the APEX_DATA_EXPORT package, you are able to export data from Oracle Application Express in the following file types: PDF, XLSX, HTML, CSV, XML, and JSON. Step 1: Create a table and populate it with some sample records. CREATE TABLE emp   (     empno        NUMBER,     first_name   VARCHAR2(240),     last_name    VARCHAR2(240),     mgr          NUMBER,     deptno       NUMBER,     sal          NUMBER,     created_date TIMESTAMP (6),     comm         NUMBER,     hiredate     DATE,     JOB          VARCHAR2(240),     ename        VARCHAR2(240),     PRIMARY KEY (empno) USING INDEX ENABLE   ); /    INSERT INTO emp (empno, first_name, last_name, mgr,                   deptno, sal, created_date)         VALUES                 (1, 'Larry', 'Ellison', ,                  10, 5000, LOCALTIMESTAMP);   INSERT INTO emp (empno, first_name, last_name, mgr,                   deptno, sal, created_date)         VALUES                 (2, 'Juan', 'Juan', 1,  

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  manager ,                emp . hiredate ,                 nvl ( emp . sal , 0 )  salary ,                 nvl ( emp . comm , 0 )  commission            FROM  eba_demo_chart_emp emp ,                eba_demo_chart_dept dept ,                eba_demo_chart_emp mgr           WHERE  emp . deptno = dept . deptno             AND  emp . mgr      = mgr . empno  ( + )           ORDER   BY  emp . ename