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.

sql if value is null not equal does not work

user8851230Aug 18 2020 — edited Aug 18 2020

I have the below query, but the AND pd.FROMLOC <> 'DMS' does not work if the column has {null} is there a workaround?

SELECT pd.wavekey, pd.orderkey, o.externorderkey, pd.pickdetailkey, pd.status, pd.fromloc, pd.loc, pd.sku, pd.qty, pd.adddate, SUBSTR(o.c_zip,1,3), O.SUSR4, od.cartonbreak

FROM sprtict.pickdetail pd

Join sprtict.ORDERS O on O.ORDERKEY = PD.ORDERKEY

Join sprtict.ORDERDETAIL OD on OD.ORDERKEY = O.ORDERKEY and od.ORDERLINENUMBER = pd.ORDERLINENUMBER

WHERE(PD.adddate BETWEEN (TRUNC(SYSDATE-1) + 21/24) AND (TRUNC(SYSDATE) + 21/24))

AND od.cartonbreak NOT IN ('FLOORPICK', 'LIFTPICK', 'STRINGERS')

AND pd.FROMLOC <> 'DMS'

AND pd.LOC <> 'DMS'

AND O.SUSR4 = '3P01'

AND pd.wavekey = '0001520762'

AND o.externorderkey = 'SP000044662873'

screenshot2.jpg

screenshot.jpg
This post has been answered by Joerg.Sobottka on Aug 18 2020
Jump to Answer

Comments

Ashish Awasthi
Answer

Hi User

use default setting in ViewObject tuning part

on page select your af:table and set it's auto height rows property to 5 , so it will display a scroll-bar after 5 rows, and then set contentDelivery of table to immediate

don't use page ranging , just use default scrollable access mode

Thanks

Marked as Answer by user2555199 · Sep 27 2020
user2555199

Thank you so much, this has finally worked!

I wonder why in all the blogs I have check about this question before asking here they never mentioned about autoHeightRows.

I really appreciate your help.

1 person found this helpful
1 - 2

Post Details

Added on Aug 18 2020
9 comments
6,277 views