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. It returns the chunk that you request.

myStr := SPLIT_STRING_BY_TOKEN('red:blue:green',':',2)

This function call above returns the 2nd chunk in the string which results in 'blue'.

If you need to get a users IP address in PLSQL or Oracle Application Express you can use the following syntax :

l_ip := owa_util.get_cgi_env('REMOTE_ADDR');

Creating charts using the Oracle BI Publisher Word Template Builder is fairly straightforward. Once you've got your XML input data you simply load it within Word and run the chart wizard.

If the wizard creates the chart you want then you are lucky. Modifying the chart or doing any customisation usually involves editing the raw XML definition. However, there is almost no decent documentation available for tweaking the XML and is something of a black art.

So I created the Oracle BI Publisher Chart Generator.

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. It assumes anything starting with an ampersand must be a bind variable.

For example the query below :

SELECT * FROM TBL_COLOURS WHERE colour = 'Red&Blue';

would result in a pop-up window asking for a value for "&Blue".