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 !!
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… Read More Create a table with only scale specification for a column
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… Read More PL/Scope and PL/SQL Hierarchical Profiler in Oracle 11g
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… Read More Enable Encryption for SecureFiles
Happy Diwali to all
Dear All, I wish you all a very happy, safe, cracking, sparkling and colourful Diwali. Have a great year ahead !!! Indian cricket has already gifted the Diwali gift with cracking clean sweep over England 🙂
Protect your database with VPD
Hi All, Database security is an important aspect of database management and administration. Several database security solutions have been designed to prevent database from corruption, hacking threats, and unauthorized data access. Fine Grained Access Control (FGAC) is one of the security approaches which allow the logical and virtual partition of a database. In a multi… Read More Protect your database with VPD
Result Caching feature in Oracle 11g
Caching has always been the pick of the programmers world. These days applications formulate and maintain different strategy for Cache Manager. Database presents an efficient cache manager which is capable of caching the SQL query results, PL/SQL functions results and client OCI result cache. In earlier versions of Oracle, caching mechanism was limited up to… Read More Result Caching feature in Oracle 11g
Enable code optimization technique using PLSQL_OPTIMIZE_LEVEL
Attribution: This article is a complimentary excerpt from Oracle Advanced PL/SQL Developer Professional Guide Oracle initialization parameter PLSQL_OPTIMIZE_LEVEL The parameter was introduced in Oracle 10g to decide the level of optimization applicable for a program unit during compilation. The optimization during compilation means the removal of dead code, code movements to optimize iterative constructs, inline… Read More Enable code optimization technique using PLSQL_OPTIMIZE_LEVEL
My RMOUG abstract (Inheritance in Oracle)
Inheritance in Oracle: Exploring the Descendents “The Abstract Object model of database is an under implemented and commercially unexplored flavor of database. In the late 1980s, relational model of Oracle faced several deficiencies, which forced the evolution of Object model. Undoubtedly, relational model did all well for flat data storage, maintenance of integral data,… Read More My RMOUG abstract (Inheritance in Oracle)
culture, change, and tech 