Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query not showing output for Null columns.

user10151069Sep 11 2018 — edited Sep 11 2018

Oracle 11.2.0.4.

When I query the data I don't get values in sql plus where as in client tool Toad I can see the null values for c_id and C_date columns.

select c_id,U_id,C_date from F_user where C_id=NULL;

No rows returned

pastedImage_2.png

Toad output:

pastedImage_1.png

u_id,c_id,C_date from F_user where C_id=NULL;

When I do the below it returns no rows either.

select c_id,U_id,C_date from F_user where C_id='';

No rows returned

CREATE TABLE F_USER

(

U_ID NUMBER(11) NOT NULL,

C_ID NUMBER(11),

C_DATE DATE

)

TABLESPACE QRT01

PCTUSED 0

PCTFREE 10

INITRANS 1

MAXTRANS 255

STORAGE (

        INITIAL          128K

        NEXT             128K

        MINEXTENTS       1

        MAXEXTENTS       UNLIMITED

        PCTINCREASE      0

        BUFFER\_POOL      DEFAULT

       )

LOGGING

NOCOMPRESS

NOCACHE

MONITORING;

ALTER TABLE F_USER ADD (

CF\_USER\_UID\_PKONSTRAINT

PRIMARY KEY

(U_ID)

USING INDEX F_USER_UID_IK

ENABLE VALIDATE;

What am I missing?
This post has been answered by mNem on Sep 11 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 9 2018
Added on Sep 11 2018
#sql-developer
2 comments
1,135 views