In SQL Server if you want to know the lengh of fields in a column you will use len(columnname). In my SQL Server database if there is nothing in the field so then len(columnname) = 0. With the same database but in Oracle you would think it would be the same with length(columnname). This is giving me the length of the default column length, 8 but not the fields inside the column.
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here.
General principle of Oracle compression
Oracle compression is a way of reducing the d…
How to Unravel a Tricky Query
If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them. …
This video shows how to copy a database user from one database to another user DBMS_METADATA. It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.