Monthly Archives: September 2018

Adding Default Column to a table in Oracle and SQL Server.

Posted on September 21, 2018 by Deepak Mahto

Adding a column to an existing table with default exhibit many question. For instance What would be value for that column on existing rows ? What would happen if new column added is Null? What would happen if new column … Continue reading →

Rate this:

Posted in Oracle Internal | Leave a comment

Aliasing Table in Oracle and SQL Server and interesting difference.

Posted on September 18, 2018 by Deepak Mahto

Sometimes we assume things to work and not test it, but it surprise you and give you a reason to learn. We have a product that works on top of both Oracle and SQL Server, hence we are bound to … Continue reading →

Rate this:

Posted in Oracle Internal, SQL Server Learning | Tagged , , , | 1 Comment