Programming Tutorials & Tech
Vinish KapoorExample 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. ... Read more
Suppose you have a stored procedure in Oracle database which is using XML as parameter to process the data and you want to pass XML parameter to stored procedure to execute it. For this case below is the example PLSQL block showing that how you can pass XML as parameter to stored procedure in Oracle. ... Read more
It's a good news for bloggers who are using Blogger platform for their blogs that Blogger introduced many beautiful themes on 20th March 2017. These themes are fully responsive and SEO friendly with all new fresh look. So you can use these blogger templates launched in 2017 for your blogs rather than taking blogger templates ... Read more
A simple example is given below to insert a long string into CLOB data type in Oracle. You can not insert data directly into CLOB data type, you have to use Empty_Clob() function with returning clause in insert statement then use dbms_lob.write procedure to write the data. Because if you will try to insert directly ... Read more
In the previous blog post, I have given an example to use Oracle Bulk Collect Using Cursor Rowtype Type Object. Which first creates the cursor then type object of cursor type and then open the cursor, fetching into bulk collect and then finally process them using Forall. But sometimes you may be required to prepare ... Read more
In this post, I am giving an example to perform an insert into using Oracle Bulk Collect and FORALL command. Created a PL SQL function which will take data from EMP table using a cursor then creates type array variable of that cursor row type and then it bulk collect and insert into BONUS table ... Read more
Oracle joins with examples are given below to describe Oracle Joins using new syntax. Which is very easy to understand and very good in SQL query readability. Because if query is larger and having too many tables with too many joins in old syntax it becomes complex to understand. So it is better to use ... Read more
If you want to use your Oracle Form's functionality in Oracle Apex application then you need to convert first Oracle Form into XML using frmf2xml utility in Oracle Forms 11g and then you need to create a migration project into Oracle Apex. Below are the steps are given to perform this task. 1. Convert Oracle ... Read more
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> ... Read more
Sometime happens that you posted a blog for a particular topic but you put the title which is not that relevant and after publishing the blog post you realize that you made a mistake and then you change the title of your blog post and publish it again but in Google search result it is ... Read more