Not displaying items which match criteria in Oracle SQL Developer but no error -

-

i have code below , used display fields wh_id of 'mp'

select o.wh_id, o.bill_to_code, d.create_date,    (case when d.pick_area 'gps%' 'gps' else d.pick_area     end) pick_area,     count(*) ouc t_order o inner join  t_pick_detail d  on o.order_number = d.order_number o.wh_id = 'mp' group o.wh_id, o.bill_to_code, d.create_date,      (case when d.pick_area 'gps%' 'gps' else d.pick_area     end) order o.bill_to_code

it gave me following results:

enter image description here

then once add in 1 piece of criteria matches items in table above.

extra criteria is:

and d.create_date =  '19-feb-15'

full code :

select o.wh_id, o.bill_to_code, d.create_date,    (case when d.pick_area 'gps%' 'gps' else d.pick_area     end) pick_area,     count(*) ouc t_order o inner join  t_pick_detail d  on o.order_number = d.order_number o.wh_id = 'mp' , d.create_date =  '19-feb-15' group o.wh_id, o.bill_to_code, d.create_date,      (case when d.pick_area 'gps%' 'gps' else d.pick_area     end) order o.bill_to_code

now results shown below, makes seem though there no results info there can see above print screen. don't error though.

enter image description here

hope can help, thanks.

from performance point of view, not suggest use trunc not use regular index on date column.

better use range condition. use index on date column , see index range scan rather full table scan.

for example,

d.create_date >= to_date('19-feb-15', 'dd-mon-yy') , d.create_date < to_date('19-feb-15 ', 'dd-mon-yy') + 1

or,

d.create_date  between to_date('19-feb-15', 'dd-mon-yy')  ,     to_date('19-feb-15 ', 'dd-mon-yy') + 1

if want use trunc, have create function_based index.

have @ link https://hoopercharles.wordpress.com/2010/03/08/impact-of-the-trunc-function-on-an-indexed-date-column/


Comments

Post a Comment

Popular posts from this blog

How to run C# code using mono without Xamarin in Android? -

-
i want create program uses mono runtime run c# code (binary not application). i copied libmono.so unity app , i'm write code using documentation: http://www.mono-project.com/docs/advanced/embedding/ and it's working have problems references can access classes mscorlib.dll , have problems system.reflection.assembly class throwing exception, when print console see: system.missingmethodexception: method not found: 'system.reflection.assembly.op_inequality' can fix it? can use mono runtime in c binary on android? ps. i'm using android tests. edit: found solution loading libraries, need set environment variable mono_path libraries path. but have still problems assembly class. the system.missingmethodexception error have seems .net profile mismatch error, 1 explained here . can use mono runtime in c binary on android? yes, using ndk guess. there alternatives can use instead of rolling own, such xmadevlab .
Read more

html - grunt SVG to webfont -

-
i'm trying generate webfont svgs using grunt-webfont . the issue need task valid on windows , linux machines. in order achieve need use node engines doesn’t work svg files . i know if there way convert svgs proper svg format supported grunt plugin or alternatively there better grunt plugin/s achieve this i have task able take svgs (created in illustrator) , output webfont files (.eot,.svg,.svg,...) , css file (like icomoon export) thanks. perhaps artboard small. recommend checking have 512pt x 512pt artboard each icon. stumbled upon gem ( https://www.fourdigits.nl/blog/using-a-webfont-to-display-icons ) when grunt-webfont documentation left me alone in forest.
Read more

c# - SharpSsh Command Execution -

-
Image
i trying create ssh client using c#. using tamir.sharpssh library. having issues sending command , getting appropriate response server. the way have been testing sending on ls command, followed cd.. command, followed ls command again -- see whether or not cd.. command being executed properly. however, there no difference between first ls command , second ls command. not entirely sure doing wrong. perhaps using wrong ssh type. have provided code , output getting. have added output expect. using tamir.sharpssh; namespace sshnetexample { class program { static void main(string[] args) { sshexec ssh = null; try { console.write("-connecting..."); ssh = new sshexec(host, username, password); ssh.connect(); console.writeline("ok ({0}/{1})", ssh.cipher, ssh.mac); console.writeline("server version={0}, client versio...
Read more