Pipelined Functions in Oracle

How to create Pipelined Functions in Oracle? Pipeline functions are used to return data in tabular format. It returns the data in the nested table type. Pipeline functions are useful to dump data derived from the complex queries. Create the types CREATE TYPE g_emp_row AS OBJECT ( empno NUMBER (4), ename VARCHAR2 (10 …

Change Language anytime in Oracle APEX

How to Change application language after login in ORACLE APEX? In the previous article , we have seen how to translate the application. But what if the user logs in and then want to change the language. Create one dialog page with a select list which holds the list of language. Item Setting: Page Action on Selection: …

APEX Split Login template experiment

How to Add new region position in APEX login page? APEX has been upgraded it login templates all the way from simple region to login template region then in APEX it is also available with split design. Since I have been playing around the APEX templates and themes i found we could add region position to our APEX page …

Get Images from ORACLE REST Web Service

How to get Images from ORACLE REST Web Service ? Oracle REST APIs provides the feature of media resource, here we can write the query with two columns content type and image blob. While i was trying to implement i saw tweaks, the query has to be in below format only. SELECT 'content_type', column FROM . . …

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 …