Tag Archives: DDL

Interesting Database SQL Concept Question, Give it a try??

#TGIF Today’s will try to walk you through a Database concept questions and hopefully you will learn something new. (Obviously if you are not aware of it.!) Suppose we have below scenarios, In Database Session 1 : –> we are … Continue reading

Rate this:

Posted in Helper SQL, Oracle Internal | Tagged , , , , , | 4 Comments

Add Not NULL constraint on existing table column having null values

Recently in OTN someone posted a question with scenario as below. “Add Not NULL constraint in the existing table that has null values” At first it seems to be simple, Just an AlTER Command should do. But think what would … Continue reading

Rate this:

Posted in Oracle Internal | Tagged , , , , , , , , | Leave a comment