Archive for

Register for Sangam 2011 at AIOUG

Don’t miss chance to meet ACEs and some great Oracle DBA and Developer sessions. Sangam 2011. See you all there !! Advertisements

Create a table with only scale specification for a column

Hi All, Just came across a peculiar way of specifying only the column scale and not its precision, so thought of sharing with all. It looks pretty simple but could be a handy tip for table designs. Scenario: Create a table CONT_EMPS where Salary column must store values upto 2 places of decimals (i.e. scale … Continue reading

Oracle ACE Nominations

Just to share with you all Oracle ACE Nominations.

PL/Scope and PL/SQL Hierarchical Profiler in Oracle 11g

Hello world, Ever since the release of Oracle 11gR2 in 2009 under the theme “Consolidate. Compress. Control“, its new features have always been the talk of the conferences and meetings. But besides the compression, control and other development features, there were several other features which have got less weightage. I shall present my walkthrough experience … Continue reading

Enable Encryption for SecureFiles

Last week, I was trying to enable ENCRYPTION property for Oracle 11g Secure File. But I couldn’t find sufficient information on the web. However, I have tried it now and would like to demonstrate on my blog. Suppose I have a table EMPLOYEES where employees image (BLOB) has to be loaded into the database. You … 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