This week's book giveaway is in the Performance forum.
We're giving away four copies of The Java Performance Companion and have Charlie Hunt, Monica Beckwith, Poonam Parhar, & Bengt Rutisson on-line!
See this thread for details.
Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle - NOT NULL field displayd as NULL

 
Sajee Joseph
Ranch Hand
Posts: 200
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello all,
Is there any sitrualtion in which a NOT NULL filed is displayed as null when we issue :
DESC <<tablename>>.
I have a table tab1 with a field col1.
When i DESC tab1, it displays col1 as NULL.
However all th values for col1 are not null. So i try to modify this column to NOT NULL. Now it gives the error that col1 is already NOT NULL.
Why is this so???
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic