Home » Posts tagged 'PLSQL'
Tag Archives: PLSQL
NULL-Related Functions (NVL, DECODE, NVL2, COALESCE, NULLIF, LNNVL, NANVL, SYS_OP_MAP_NONNULL)
NULL-Related Functions (NVL, DECODE, NVL2, COALESCE, NULLIF, LNNVL, NANVL, SYS_OP_MAP_NONNULL)
This article from Oracle Base
The article direct link NULL-Related Functions (NVL, DECODE, NVL2, COALESCE, NULLIF, LNNVL, NANVL, SYS_OP_MAP_NONNULL)
Summary
This article provides a summary of the functions available for handling null values. For a more detailed description follow the links are the bottom of the article.
Sending a SMS to a mobile phone from APEX and PL/SQL
Sending a SMS to a mobile phone
This article from Inside Oracle APEX by Patrick Wolf
The article direct link Sending a SMS to a mobile phone
Summary
this article explains how to sending a SMS from APEX and PL/SQL through a Web-Service. For example if you have a system failure or get a new order in your shop…
Oracle eBusiness Suite Electronic Technical Reference Manual – eTRM
Oracle eBusiness Suite Electronic Technical Reference Manual – eTRM
This article from Oracle eBusiness Suite Electronic Technical Reference Manual – eTRM
The article direct link Oracle eBusiness Suite Electronic Technical Reference Manual – eTRM
Summary
eTRM is a pl/sql utility that reads design information in an Oracle database and displays its output in html format. It shows database design and dependency information for the Oracle eBusiness Suite. Enter the name of a database object (example: per_people_f) or a search condition (example: contract compliance) then press ‘Search’ to search for information. Alternatively you can browse the FND Model or Oracle Data Dictionary from the FND or DBA tabs.
Attach Concurrent Program Output to an Apps Transaction using PL/SQL
Attach concurrent program output to an Apps transaction using PL/SQL
This article from Oracle Maniacs’ Notes
The article direct link Attach concurrent program output to an Apps transaction using PL/SQL
Summary
An interesting requirement came to me. I had to customize the PO workflow and after the workflow was approved I had to send the PO in PDF format to the supplier within an email. Oracle gives the option of sending the PO in PDF format to the supplier once the PO is approved. Once the PO is approved Oracle executes the program named, PO Output for Communication (POXPOPDF), saves it into the database, attaches it to the PO and sends this output as an attachment. The layout of the report can also be customized also. I shall discuss about this customization procedure in another post. The problem is that the standard report, PO Output for Communication, was unable to provide all the details.
Oracle APEX the server requires a username and password the server says XDB
Oracle APEX the server requires a username and password the server says XDB
This article from Mohammad Fawzy
The article direct link Oracle APEX the server requires a username and password the server says XDB
Summary
After install APEX on enterprise edition database you will get the following message if you try to connect to APEX “the server requires a username and password the server says XDB”
In a new installation, we must configure the embedded PL/SQL gateway by running the configuration script apex_epg_config.sql. Then, we must unlock the ANONYMOUS account.
Oracle PL/SQL Language Pocket Reference, Fourth Edition
Oracle PL/SQL Language Pocket Reference, Fourth Edition
This article from IT eBooks
The article direct link Oracle PL/SQL Language Pocket Reference, Fourth Edition
Summary
The fourth edition of this popular pocket guide provides quick-reference information that will help you use Oracle’s PL/SQL language, including the newest Oracle Database 11g features. A companion to Steven Feuerstein and Bill Pribyl’s bestselling Oracle PL/SQL Programming, this concise guide boils down the most vital PL/SQL information into an accessible summary.
You can download the Oracle PL/SQL Language Pocket Reference, Fourth Edition book directly from the following link:
Oracle PL/SQL Language Pocket Reference, Fourth Edition.pdf
Set And Reset Interactive Report Filters In PLSQL
Set And Reset Interactive Report Filters In PLSQL
This article from MattsBits
The article direct link Set And Reset Interactive Report Filters In PLSQL
Summary
Within the APEX APEX_UTIL package there are a couple of useful procedures for setting and resetting Interactive Report filters. This allows you to manipulate IR filters programmatically within PLSQL.
OraPedia 