Posts

Displaying Images in Oracle Apex

Image
Displaying Images in Oracle Apex Steps : 1. Create PL/SQL dynamic Content Region and write the code declare  cursor c1 is   select FILE_SHORT_INFO,emp_code from prtl_files where emp_code = :P8_empcd;  t varchar2(200); begin    for i in c1    loop     htp.p('<body>');htp.p('<p>&nbsp;</p>');        htp.p('<table width="100%">');         htp.p('<tr>');       for rec in (select * from PRTL_FILES                where emp_code = :P8_EMPCD and status='A')     loop       IF rec.ATT_MIMETYPE is not null or rec.ATT_MIMETYPE != '' THEN  htp.p('<td colspan="2">'); htp.p( '<img src="my_image_display?                          fid='||NVL(rec.FILE_ID,0)||'" height="'||100||'"/>' );    ...
Post a Comment
Read more

Printing Bar Code in Oracle Apex

Image
Bar Code report in Oracle Apex Steps: 1.  Download barcode font  https://www.wfonts.com/font/code39azalea 2. Upload the both .ttf & .woff font in Application > Shared Component > Static Application Files 3. Write the below code      a. Pages Designer > Javascript >  Function and Global Variable Declaration function printContent(el){       var restorepage = $('body').html();       var printcontent = $('#' + el).clone();       $('body').empty().html(printcontent);       window.print();       $('body').html(restorepage);       }    b.  Pages Designer >  CSS > Inline @font-face {    font-family: 'barcode';           src: url('#APP_IMAGES#Code39Azalea.ttf') format('truetype');           src: url('#APP_IMAGES#Code39Azalea.woff') format('woff');    ...
Post a Comment
Read more

Balance sheet

Image
Oracle Apex - Balance Sheet I have developed nice report to show the Balance Sheet using PL/SQL Dynamic Content. Steps : 1. create a table to store the Main Account Details 2. Create table to store the sub account details sample data as follows for Main Account Details sample data as follows for Sub Account Details 3. create a PL/SQL Dynamic Content Region and write the below code Balance Sheet main Report Drill Down Note : define the "GetInfo" javascript for drill down report, you must define it in Page Designer > HTML Header as follows
Post a Comment
Read more

Customize Apex Login

Image
How to customize Oracle Apex - Application Login Page Sometime i feel little dryness in Oracle Application login page, just like similar to below  While searching in internet i found below steps to change your login page appearances like below Application Express 18.1.0.00.45 Steps : 1. upload the files into your workspace Application Builder -- Shared Components - Static Application files  2. Write Below HTML - CSS code  in     a. Goto Page # 9999 (Default Login Page)     b. Goto Page Designer Property > CSS > Inline span.t-Login-logo { background-image: url(#APP_IMAGES#logo.jpg); background-size: cover; width: 400px; height: 204px; } .t-Body {   background: url(&APP_IMAGES.backround.jpg); } That's All, You can see nice login page during login.
Post a Comment
Read more