Oracle SQL and PLSQL Beginner Resources
In this post lets take a look at few of the free Oracle SQL and PLSQL Beginner resources. These can also be used by Intermediate and advanced users!! Oracle Dev Gym Here is a great blog by Steven Feuerstein about Oracle Dev Gym. The portal has got 4 main sections: Classes: there are some really […]
Create XML Using DBMS_XMLDOM
DBMS_XMLDOM The DBMS_XMLDOM package is used to access XMLType objects, and implements the Document Object Model (DOM), an application programming interface for HTML and XML documents. The Document Object Model (DOM) is an application programming interface (API) for HTML and XML documents. It defines the logical structure of documents, and the manner in which they are accessed […]
Submit XML Publisher Report from PL/SQL
Today, let us look at how we can submit XML Publisher report from PL/SQL. Now you might think that I already know how to use “fnd_request.submit_request” to submit a concurrent program. Right? Well, things are a little different when it comes to XML Publisher Report / Concurrent Program. First, let us see what happens when you submit a XML […]
Interesting SQL and PLSQL Tips and Tricks
This blog covers some interesting SQL and PLSQL Tips and Tricks. I will try to include some interesting functions and plsql solutions to some interesting requirements. Find Last Day of the Month SQL Function :- LAST_DAY() SELECT LAST_DAY(SYSDATE) FROM DUAL Find First Day of the Current Month SQL Function:- Combination of LAST_DAY () and ADD_MONTHS […]
UTL_MAIL to Send Email form PL/SQL
Let us see how we can utilize UTL_MAIL to send Email form PL/SQL. Using the UTL_MAIL package is pretty straight forward. Check the below example. [sql] begin utl_mail.send( sender => ‘oracle@mydomain.com’, recipients => ‘user1@mydomain.com,user2@mydomain.com’, subject => ‘Test Mail from my Instance’, message => ‘Test message’ ); end; [/sql] As you can see there are 4 […]