File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Soft Skills: The software developer's life manual this week in the Jobs Discussion forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle - NOT NULL field displayd as NULL

 
Sajee Joseph
Ranch Hand
Posts: 200
  • 0
  • 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