Oracle SQL

Benefits and Limitations of Using Virtual Columns in Oracle Database

By | May 9th, 2015|Oracle|

As the name suggests, Oracle introduced the concept of defining columns on a table that will actually not store values. Instead, it is uses an expression based on other columns in the same table. A very interesting concept. Although these virtual columns appear as normal columns of the table when queried, they are actually not [...]

32 Tips for Oracle SQL Query Writing and Performance Tuning

By | May 8th, 2015|Oracle|

I am working with Oracle SQL from day when I joined IT industry and I have been fascinated by number of things I have learned about SQL, different databases and its usage over the years. In early phase of my career, I learned that writing SQL queries was not just about writing but writing so [...]