aspose file tools*
The moose likes JDBC and the fly likes Oracle - NOT NULL field displayd as NULL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Oracle - NOT NULL field displayd as NULL" Watch "Oracle - NOT NULL field displayd as NULL" New topic
Author

Oracle - NOT NULL field displayd as NULL

Sajee Joseph
Ranch Hand

Joined: Jan 17, 2001
Posts: 200
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???
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Oracle - NOT NULL field displayd as NULL