Archive for

Refresh constraints

  Constraints are one of the fundamental concepts, which arrive at a very elementary stage of Database designing. Constraints are nothing but the rules on the data. This preserves the Entity integrity, Referential Integrity, and Domain Integrity of the data. While entity integrity focusses on uniqueness and NULLable property of a data, referential checks the data of a column ‘in … Continue reading

OakTable User Account

Hi, Today, my user account at OakTable network(http://www.oaktable.net) has been approved. Just to share with you all, I am happy to be the subscribed user of OakTable N/W. Thanks OakTable and Thanks all SBH

Oracle 11g SecureFiles

Hi All, Oracle 11g saw through very significant PL/SQL feature i.e. Storage of external files/objects. These objects fall under unstructured data category and database recognises them as Large Objects. They are stored as LOB types in database. This normal storage was improved upon, after this philosophy slowly moved from ‘featured one’ to ‘overhead’ level in terms … Continue reading

Saurabh K. Gupta

Saurabh K. Gupta

Database Enthusiast, Author, Speaker and blogger

View Full Profile →

Twitter Profile

Advanced Oracle PL/SQL Developer’s Guide – Second Edition

Advanced Oracle PL/SQL Developer's Guide - Second Edition

Oracle Advanced PL/SQL Developer Professional Guide

Oracle Advanced PL/SQL Developer Professional Guide


SBHOracle is an independent blog and all the posts are based on my self experience and hands on with the technologies. It shares no relations with any of my current projects or from those in the past.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 784 other followers

SbhOracle Blog stats

  • 78,768 hits
Aggregated by OraNA