Category : Oracle
This category contains all articles related to PLSQL, BI Publisher and other Oracle technologies.
Common User and Group LDAP Attributes
Lightweight Directory Access Protocol (LDAP) is a network protocol for managing directories often used to implement user databases or telephone directories. Here is a list of common LDAP attributes.
Find Page With No Items In Oracle Portal
To track down pages in Oracle Portal that contain no content you can use the following query. It counts items on a specified page and all its subpages. Those with a count of zero can be identified.
Bulk Delete Empty Pages In Oracle Portal
When users have created hundreds of pages it is useful to be able to delete empty pages without have to search for them individually. This script can identify and delete empty pages using PLSQL.
List of All Sub Pages In Oracle Portal
The following query can be used to return all the Oracle Portal pages within a particular page branch, including the level at which they appear in the tree.
Count Sub-Pages In Oracle Portal
The following PLSQL code creates a database function that counts the number of sub-pages on a page (folder) in Oracle Portal. This function can then be called whenever a sub-page count is required.
Count Page Items In Oracle Portal
The following PLSQL code creates a database function that counts the number of items on a page in Oracle Portal. This function can then be called whenever an item count is required.
Generate Oracle Error Codes In PLSQL
While developing Oracle applications you may come across any number of error codes. The following PLSQL code can generate the appropriate error message for a group of error codes.
Convert Delimited Lists To Tables PLSQL
If you need to break up a delimited string within PLSQL into parts then you can use DBMS_UTILITY.comma_to_table. This function breaks up a comma delimited string.
Create, Delete And View Cookies In PLSQL
You can create, delete and view browser cookies within PLSQL using an Oracle Web Agent (OWA) package called "owa_cookie". This package can be used within APEX if required.
Handling Errors And Exceptions In PLSQL
In PL/SQL, a warning or error condition is called an exception. Exceptions can be predefined or they can be user defined. This article explains how you can define and use your own custom exceptions.
Top 20 Posts
HTML & CSS (10)
Microsoft .NET (3)
Mobile Phones (15)
PHP & MySQL (5)
Raspberry PI (5)
APEX Blog Aggregator
APEX on Wikipedia
Application Express Documentation
Application Express Home
Application Express Official Forum
Denes Kubicek ApEx BLOG
Official Oracle Forums
Oracle SQL Developer
Binary Decimal Hexadecimal Co...
HTML List Generator
LED Current Limiting Resistor...
Oracle BI Publisher Chart Generator
Rounded Corner Generator
Secure Password Generator
ShopIntegrator Button Generator
Text to HTML Converter
... Show More
Google Web Search
If you wish to contact us please email email@example.com -
MattHawkins CMS v3.0 - Copyright 2009-2017