SQL Script For Tablespace Utilisation

This query will give you a basic report on the bytes used and bytes available in the Tablespaces within a particular schema. I have used it within Oracle APEX but it can be used elsewhere.

[Read More]

PLSQL Split String By Token Or Delimiter

PLSQL doesn't include any functions to split strings by tokens or delimiting characters such as commas or colons. The function below allows you to split a string separated by a specified character.

[Read More]

Get Users IP Address In PLSQL

If you need to get a users IP address in PLSQL or Oracle Application Express you can use the owa_util.get_cgi_env function.

[Read More]

Oracle BI Publisher Chart Generator

Creating charts using the Oracle BI Publisher Word Template Builder is fairly straightforward. Modifying the chart or doing any customisation usually involves editing the raw XML definition.

[Read More]

SQL Developer Worksheet And Ampersands

If you attempt to run SQL queries in a SQL worksheet and that query includes ampersands then SQL Developer will prompt you for bind variable values. Here is the solution.

[Read More]