How to Write Good User Stories

How to write good User stories? Writing good user stories is always a challenging job, In this process you always try to inline with the standards and business goals. For me it is just an initiative for any task/feature to our product and gateway to give the insights of product to the Development Team. Now let’s …

New Version Control in Oracle APEX 20

New Version Control in Oracle APEX 20.1. As we know APEX came with new APEX export utility in Version 20.1. Let’s have a walk through how is works. Also Checkout related articles New Updates in APEX 20.1. APEX 20.1 First look In old APEX versions we had to manually export all the components like Pages, Shared …

Reading File From Oracle Directory

How to read Files from Oracle Directory using PL/SQL? File Structure ACCOUNTING RESEARCH SALES OPERATIONS 3 Records 5 Records 6 Records 0 Records How to generate files into Oracle Directory? DECLARE l_file UTL_FILE.file_type; l_read VARCHAR2 (32767); BEGIN l_file := UTL_FILE.fopen ('MY_DIR', …

Forms Reloaded APEX 19.2 Part 2

APEX Form region On Query | Part 2. Let’s try some insights of APEX form region. Below script to add Emp and Dept if you don’t have. CREATE TABLE dept ( deptno NUMBER (2) CONSTRAINT pk_dept PRIMARY KEY, dname VARCHAR2 (14), loc VARCHAR2 (13) ); CREATE TABLE emp ( empno NUMBER (4) CONSTRAINT pk_emp PRIMARY …

Forms Reloaded APEX 19.2 | Part 1

What are the upgrades in APEX Forms as of APEX 19.2? Oracle APEX form is being great component for interacting with database. These are basically require very low code to build and seem less functionality. There are significant upgrades in APEX forms from APEX 18 to APEX 19. let’s walk through them. APEX 18.2 …

APEX Forms Reloaded Part 3

Auto validation Forms APEX 19 | Part 3 In our tradisional forms we have to write additional code for preventing invalid rows or putting any validation. APEX 19 forms came up with a concept where you can define the row qualifier in query and that’s it, Form will automatically prevent the any invalid row. Create …

APEX 19.2 Navigation Menu styles

APEX 19.2 Navigation Menu styles Navigation menu has been upgraded a lot as APEX is growing. As of now in APEX 20.1 we have already seen the Mega menus which is really cool. Let’s see what styles actually available in APEX 19.2, and of course these are carry forwarding in APEX 20.1 as well. In navigation menu …

How to Install Apex in Oracle 19 C

How to install APEX in Oracle 19 C Download APEX from Oracle products. Download APEX 19.2 Oracle 19 C is multi tenant architecture database. We can create multiple Pluggable databases (PDBs ) and each database can have one APEX instance. Extract the Zip file in the system folder. Open Command Prompt (CMD) as …

New Login Page Template APEX 19 20

New Login Page template APEX 19 / 20.1 APEX 19 came with New LOGIN page design. Now screen can be display as splitted. Let’s try. We need to change the template type There are two Page layouts Floating Split Floating is old layout, try with split. Select Split layout, save and run. We can use backgrounds as …

APEX 20 First Look

APEX 20.1 First look Page Designer Updates User Profile Browse by Facets : This is gonna great interface for developers to manage all the application components. Available filters in facets “Search Application Pages” are below Page Type Template Build Option Authorization Created By Last Updated By …