Oracle calculates the cost for each candidate of execution plan. This cost calculation depends on the many different factors. Below are the oracle cost calculation factors
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
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
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.
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.
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