MattsBits
MattsBits

MattsBits

Techniques, code snippets, examples and information relating to PLSQL, Javascript and APEX

RSS Feed for Oracle category

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.

[Read More]

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.

[Read More]

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.

[Read More]

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.

[Read More]

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.

[Read More]

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.

[Read More]

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.

[Read More]

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.

[Read More]

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.

[Read More]

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.

[Read More]

PHP Powered  MySQL Powered  Valid XHTML 1.0  Valid CSS  Firefox - Take Back The Web  EUKHost - Recommended Webhosting Solutions

MattHawkins CMS v3.0 - Copyright 2009-2022