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]

Here are some useful queries when you’re looking at an Oracle database: [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]

You can see if a job is running in Oracle by checking against the user_jobs table for the exact name of what you are running, for example: [Read More]

A proc containing a cursor can be written as follows: [Read More]