Technical Blog

Column having number(5) and Char(5) datatype for a particular table cant reduce its size even if that column contains data with length 1 ....

Oracle GLOBALIZATION SUPPORT 1  N is used as escape character for national character set In 9.2, Oracle has to convert your entire SQ...

                       Histograms are used to predict cardinality and the number of rows returned to a query .The Oracle Query Optimizer us...

SQL compilation implies execution plans generation PL/SQL compilation implies P-code generation ------------------------------------------...