Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP 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