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
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???
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Oracle - NOT NULL field displayd as NULL