Skip to Main Content
Forums

SQL & PL/SQL

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to restrict Null values

Shitab_416Jul 20 2012 — edited Jul 24 2012
Dear All,

I have main query..And i written a Query for Issued Quantity.

The query is retrieving exact data. And when i add the Query in main query the data is coming with extra null values.

for ex. Query for Issued Qty fetchs 16 records.
and i run the main query it fetchs 20 records...there r 4 records which issued Qty is null.

How can i restrict that records.

Thanks.
This post has been answered by Venkadesh Raja on Jul 20 2012
Jump to Answer

Comments

HajoNormann

The future of modern API design started here.

Key takeaway: Differentiate APIs along "private" and "public"

Microservices are "private"

APIs are "public"

Expect more to come!

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 20 2012
Added on Jul 20 2012
14 comments
383 views