APEX

RUPEE SYMBOL IN REPORTS IN ORACLE APEX 4.2 USING HTML

Most of the Applications includes Accounts Reports like Employee Payroll Reports, Company Purchase Reports, Invoice Reports,etc. Now using this method user can add RUPEE symbol in your reports. Step 1: Create Report (Interactive Report (or) Classical Report) Step 2: Place the below SQL Query in Report Region Source SELECT ‘<span style=”font-weight:bold;”>?</span>’ || ‘ ‘ || CASE WHEN NVL (SUM (amount), 0) = 0 THEN ‘0.00’ ELSE TO_CHAR (NVL (SUM (amount), 0), ‘99999999999.99’) END amount FROM reimbursement_dtls OUTPUT:

COORDINATE MAPPING IN ORACLE APEX

Coordinate Mapping: Line coordinates are used to specify the position of a line just as point coordinates (or simply coordinates) are used to specify the position of a point. User can draw multiple lines on an Apex Image Item and the Coordinates of all the drawn lines can be obtained and stored in Database Table. This can be acheived by using HTML,CSS, JavaScript. Steps To be followed : Step 1: To get Multiple Lines on your Apex Display Image Item place the following code in the page HTML Header. CODE: <!DOCTYPE HTML> <html lang=“en”> <head> <div id=“page”> <div id=“content”> <style> /* Lines can be styled with normal css: */ div.line{ –webkit–transform–origin: 0 50%; –moz–transform–origin: 0 50%; transform–origin: 0 50%; height: 2px; /* Line width of 3 */ background: red; /* Black fill */ opacity: 0.5; box–shadow: 0 0 8px #B99B7E; /* For some nice animation on the rotates: */ –webkit–transition: –webkit–transform 1s; –moz–transition: –moz–transform 1s; transition: transform 1s; } …

HIGHLIGHT MANDATORY ITEMS THROUGHOUT THE APPLICATION

Here is how to highlight form text items, which Value Required attribute is set to “Yes” and do not have any value. Step1:Create dynamic action to page zero Name: Highlight required Event: Change Selection Type: jQuery Selector jQuery Selector: input[type=’text’][required] Condition: -No Condition- Action: Execute JavaScript code Fire On Page Load: True Code: if(!$v(this.triggeringElement)){ $(this.triggeringElement).css({“background”:“#FFFF77”}); }else{ $(this.triggeringElement).css({“background”:“”}); } Selection Type: None Step2: Now run application and items having Value Required set to “Yes” background color is changed if item do not have any value. You can find Value Required setting from item attributes. OUTPUT:

DYNAMIC DATE RANGE IN APEX DATEPICKER

Using this method you can set the range of selectable dates by entering a Minimum and Maximum Date value dynamically “real-time”. Step 1: Create a Page Item (Example: “P101_DATE”). Step 2: Go to Settings -> Minimum Date In Minimum Date valid condition has to be specified. Minimum Date Conditions are (..+3d,+2d,+1d,+0d,-1d,-2d,-3d..) +0d => It will display Both SYSDATE as well as all the future following the sysdate. -10d => It will display 10 days, which are below the sysdate (Sysdate is not accounted). Example 1: (Minimum Date Condition) OUTPUT: Example 2: OUTPUT:

HOW TO PLAY VIDEOS IN ORACLE APEX 4.2

Viral advertising is a proven technique that will assist to enhance your enterprise internet presence in a really expense-powerful manner. It is an marketing activity in which information about a products preads between people, especially on the internet. This technique allows you to play videos in APEX Application. Category 1: Call Required Videos Form You tube. Step 1: Create a Page Step 2: Create a HTML Region on a Page Step 3: In Region Source => Write the following HTML: Output: Category 2: Call Required Videos from Server itself. Step 1: Upload Videos into the Server. Step 2: Call Require Videos through path. Example: (It has been done using LINUX Machine.) 1.If you have created the default path to save the videos, then specify the video name in HTML source. 2. Create the default path var/www/html. 1. If you haven’t created the default path to save the videos, then specify the path name and video name (Any Name). 2. For Example, you have saved the videos in the Desktop. Output:

CAPTURE LOG (LOGIN, LOGOUT, SESSION, SYSTEM) DETAILS IN ORACLE APEX 4.2

To Capture User Login Details: User Log Reports provides the detailed information about the users’ login details along with their history. These reports are more accurate and also provides the details of the user, their logon time, logoff time, the computer from which they logged on, the domain controller they reported, etc., along with their logon history. It also provides the details of Currently Logged On Users and Frequently Loggedon Users. The following information can be captured in the Database. 1. Login Date 2. Login Time 3. Session Id 4. System IP Address 5. Host Name 6. User Name Step 1: Table Creation <<table_name>> (column_names) {Based on the column Requirement} Step 2: Creation of Page Hidden Items Create Page Hidden Items P0_SESSION_ID, P0_USER_ID for getting Session id as well as User id. P0_SESSION_ID : SELECT v (‘session’) FROM DUAL Step 3: Creation of Insertion Process in the User Login Page On Click of Login Button or Enter Button in Login Page the following process has to be created. Insertion Process: DECLARE ln_session_id NUMBER; lv_ip_address VARCHAR2 (30); lv_login_date VARCHAR2 (100); lv_login_time VARCHAR2 (50);…

SLIDESHOW OF IMAGES IN APEX

Websites that include many images, such as art or photo gallery sites, can benefit by presenting some (or all) of their images in slide show format. Slideshow of various Images on an Apex Page can be achieved using HTML, JavaScript, CSS and jQuery. Step 1: Uploading all the images in the Workspace Shared ComponentsàFilesàImagesàCreateàSelect Application nameàChoose image fileàUpload. Step 2: Source code Give the following code in the Page Region source. Make sure that all the images are uploaded in the Workspace. Source Code: <div id=”slideshow”> //opening the Slider division <img src=”#WORKSPACE_IMAGES#Office2.jpg” alt=”Slideshow Image 1″ class=”active” width=”1100px;” height=”550px;”/> // calling the first image from workspace and width, height has been defined. <img src=”#WORKSPACE_IMAGES#2aioug.JPG” alt=”Slideshow Image 1″ class=”active” width=”1100px;” height=”550px;”/> // calling the Second image from workspace and width, height has been defined. <img src=”#WORKSPACE_IMAGES#3bay1.jpg” alt=”Slideshow Image 2″ class=”active” width=”1100px;” height=”550px;”/> // calling the Third image from workspace and width, height has been defined. <img src=”#WORKSPACE_IMAGES#4loveDoyensys1.jpg” alt=”Slideshow Image 3″ width=”1100px;” height=”550px;” /> // calling the Fourth image from workspace and width, height has been defined. <img src=”#WORKSPACE_IMAGES#5bay2.jpg” alt=”Slideshow Image 4″ width=”1100px;” height=”550px;”/> // calling the fifth image from workspace and width, height has been defined. <img src=”#WORKSPACE_IMAGES#6cricket.jpg” alt=”Slideshow Image 4″ width=”1100px;” height=”550px;”/> // calling the Sixth image from workspace and width, height has been defined.</div> Step 3: Give the below code on the HTML header </script> //within the script tag the division name will be called using JQUERY <script type=”text/javascript”> function slideSwitch() { //Opening the function var $active = $(‘#slideshow IMG.active’); if ($active.length == 0) $active = $(‘#slideshow IMG:last’); var $next = $active.next().length ? $active.next() : $(‘#slideshow IMG:first’); $active.addClass(‘last-active’); $next.css({ opacity: 0.0 }).addClass(‘active’).animate({ opacity: 1.0 }, 1000, function() { $active.removeClass(‘active last-active’); });…

DISABLING KEYS USING JAVASCRIPT IN APEX

Application customization, by using JavaScript “Key Disabling” can be achieved, thereby preventing the user from feeding the particular key input value into the system. It restricts the characters which need not to be entered into a particular field in a Form or Report column. To disable a key, follow these steps: Step 1: Creation of JavaScript Function Create the following JavaScript Function in the page HTML Header Region. Source Code: <SCRIPT language=JavaScript> <!— function isNumberKey(evt) { var charCode = (evt.which) ? evt.which : event.keyCode if (charCode > 31 && (charCode < 48 || charCode > 57)) return false; return true; } //–> </SCRIPT> Step 2: Calling the JavaScript Function Call the JavaScript function on the particular Report Column/Field in which the Keys has to be disabled. onkeypress=“return isNumberKey(event);” (Or) onclick=“return isNumberKey(event);” OUTPUT: The Input Key does not work in the field where the JavaScript function is called, provided if the Input Key code falls between the char-code entered in to the JavaScript function.

Session State Protection in APEX

Session State Protection is a built-in functionality that prevents hackers from tampering with the URLs within your application. URL tampering can adversely affect program logic, session state contents, and information…

Clearing Session State in APEX

As you develop your applications, you may find it useful to clear the cached value for specific items, all items on a page, all pages in an application, or the…

We take you from best practices to next practices of software implementation

Solutions that Ensure You Stay Ahead of Competition

Your Partner for Strategic Technology Solutions

Guiding Your Digital Transformation Journey