In this post I am going to demonstrate how to return dataset from function in PL/SQL using pipelined table function. For this we need to perform below steps. Create TYPE object as OBJECT of the structure of required output format Create
Articles related to PL/SQL
In Oracle PL/SQL, PRAGMA refers to the compiler directive and it is used to provide an instruction to the compiler. PRAGMA are processes at compile time, not run time. They do not affect the meaning of program, they simply convey
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