Text queries are a very complex subject in Oracle, but briefly, the following is enough for a basic full text search.
The example searches help text in a table called “help_topic” with the column “help_text”.
[Read More]
Sometimes for front-end applications it’s useful to display a list of items to a user, but those items are stored as multiple records in a database table.
This function takes a single field in a cursor and joins the values together into a delimited string.
[Read More]