Monthly Archives: September 2018

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

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

Table Alias in Oracle and SQL Server.

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 | Tagged , , | Leave a comment