Difference between Oracle Instance and Oracle Database

Today we will see the basic terms regarding the oracle database i.e. Oracle Instance, Oracle Database and Oracle Server. Many peoples are always having confusion between Oracle Instance, Oracle Database and Oracle Server. Below is the simple description for all

How to convert number into words using SQL in Oracle ?

Conversion of number into words mostly required in amount translation. In this article we will see how to do this conversion in SQL. How to do ? Oracle has a Julian Date format which converts a number into Julian year

How to return multiple values from a function in Oracle PL/SQL?

Generally we write functions for computing some value. Function can return only one value, though it’s definition may contains more than one return statements. This article explains us how to return multiple values from a function in oracle using PL/SQL language.

Autonomous Transaction in oracle

An autonomous transaction is an independent transaction started by another transaction called as main transaction. It let you allow to execute various DML statements, commit and rollback without commiting or rolling back the DML statements issued by the main transaction.

How to check which events are set on the oracle database ?

I came across the situation where i was not able to find that which events have been set on database. I had set the 10035 event to capture the hard parse failures on the database. But when i check for the value

Page 5 of 512345