Vinish Kapoor

An Oracle Apex Consultant, Oracle ACE, and founder of foxinfotech.in and orclqa.com a question and answer forum for developers.

An Example of Pre-Query and Post-Query Triggers in Oracle Forms With Using Display_Item to Highlight Dynamically

Example is given for Pre-Query and Post-Query triggers in Oracle Forms, with using Display_Item built-in in Post-Query triggers to highlight fields dynamically. This is the screen shot below for this example: You can also download this form from the following link: Query.fmb The example is based on HR schema departments table. In this example Department No. …

An Example of Pre-Query and Post-Query Triggers in Oracle Forms With Using Display_Item to Highlight Dynamically Read More »

SQL Query Example to Read Data from XML in Oracle

Below is the example of SQL query to read / extract data from XML in Oracle. You can query any XML easily by providing its namespace clause and the path information through SQL query. Suppose you have XML data in the following format: <main>   <DATA_RECORD> <EMPNO>7369</EMPNO> <ENAME>SMITH11V9</ENAME> <JOB>CLERK</JOB> <MGR>7698</MGR> <HIREDATE>1980/12/17 00:00:00</HIREDATE> <SAL>800</SAL> <DEPTNO>20</DEPTNO> </DATA_RECORD> …

SQL Query Example to Read Data from XML in Oracle Read More »