Is there any one who can tell that the use of with clause in oracle.
What is the advantage of using with clause?
Please share your views,
Thanks in advance.
No Comments Posted for this Article.
Bitmap Indexes in Oracle
Bitmap IndexesThe purpose of an index is to provide pointers to the rows in a table that contain a given key value. In a regular index, this is achieved by storing a list of rowids for each key...
LOOP AT with WHERE Clause
Performance Problem with Internal Tables being Read with WHERE Clause in LOOP AT Statement If one use a LOOP AT statement with a WHERE clause, the whole TABLE will be read through not only...
These are used to allocate space to a table/ segment to control the growth 1. Initial Extents 2. Minimum Extents 3. Next Extents 4. Max Extents Segment means (table or Index) Group the...
Oracle upgrade Set NLS_LANG select * from v$nls_parameters where parameter like 'NLS_CHAR%'; − If NLS_CHARACTERSET has the value WE8DEC, set NLS_LANG to AMERICAN_AMERICA.WE8DEC − If...