Don’t miss chance to meet ACEs and some great Oracle DBA and Developer sessions. Sangam 2011. See you all there !! Advertisements
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
Just to share with you all Oracle ACE Nominations.
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
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