-
Recent Posts
Recent Comments
krishna kumar on How to create virtual host in… vipul on To get current location using… How to create virtua… on How to create virtual host in… Archives
- June 2018
- May 2018
- April 2018
- March 2018
- January 2018
- December 2017
- October 2017
- July 2017
- June 2017
- May 2017
- April 2017
- March 2017
- February 2017
- January 2017
- December 2016
- October 2016
- September 2016
- July 2016
- June 2016
- May 2016
- March 2016
- February 2016
- January 2016
- December 2015
- November 2015
- October 2015
- July 2015
- March 2014
- September 2013
- June 2013
Categories
Meta
Monthly Archives: December 2017
What is sys_refcursor in oracle ?
SYS_REFCURSOR is a pointer to result set of query where you allow the client to fetch many or a few records as per requirement. You will need the SYS_REFCURSOR whenever it require to fetch records from stored procedures. Using REF CURSOR s is one … Continue reading
What is pragma sql in oracle ?
In Oracle PL/SQL, PRAGMA refers to a compiler directive or “hint” it is used to provide an instruction to the compiler. The directive restricts member subprograms to query or modify database tables and packaged variables. Pragma directives are processed at compile time … Continue reading
What is ‘SERIALLY REUSABLE’ in oracle package ?
SERIALLY_REUSABLE packages let you design applications that manage memory better for scalability. If a package is not SERIALLY_REUSABLE, its package state is stored in the user global area (UGA) for each user. Therefore, the amount of UGA memory needed increases linearly with … Continue reading
what features are not available in oracle express edition ?
Enterprise Edition (EE) – The flagship Oracle offering with a vast array of tools and features for the large corporation. Standard Edition (SE) – Oracle SE contains the basic database management functions for small- and medium-sized shops at a far lower … Continue reading
Find objects size in MB (TABLES, INDEXES, PARTITIONS etc)
summary Finding object size in Oracle database is very important and common. Is it very useful to know the exact size occupied by the object at the tablespace. The object size in the following scripts is in Mbytes. The scripts … Continue reading