A Table is a basic unit of storage in oracle.A nested table is a collection type. The main advantage of collections is instead of processing data sequentially, we may process all the date&nb...
You can create a lexical parameter(references) by entering an ampersand (&) followed immediately by the column or parameter name.Lexical parameter are placeholders for text that you embed in a SEL...
The following hierarchy is followed when a trigger is fired.
1) BEFORE statement trigger fires first.
2) Next BEFORE row level trigger fires, once for each row affected.
3) Then AFTER row level tr...
Package: It is an collection of related variables, cursors,procedures and functions stored at one location. They supports OOPS features like function over loading, encapsulation.ADV: ...
A global variable is used to store charecter value upto 255 in length. It can be access throught the form module. The global variable always prefixed with ':Global.'ThanksRaghu.
We r write pl/sql procedure r packageonly that particular session we use global temparary table once the session complete then global temparary table will be delected automatically.syn:Create global temparary table(-----)
Placeholder column is a global variable for which we can set data type and data value.Format Trigger is a PL/SQL function. This trigger is going to fire before an object is printed in report output.it...
A placeholder column is used to hold the value of certain calculation or a variable that is being carried out in a formula column. A place holder can be defined as anumber, character or date type, dep...
A Correlated Subquery which executes with value returned by the child Query. Unlike subquery it executes per result from child query.Ex: removing duplicate rows from a table Subquery executes once for the entire child query's result