asked on 9/2/2013

Data extraction

Hi.

I am extracting some data from the database.

Theses are four fields i.e. value field1,value field2,value field3,value field4 and the fifth field just carries the unit.

I want that if the value fields are blank it should not report anything. In this case it reports a unit.

And if the value field has a value it should report the value as well as the unit.

How to do it?

value field1||'~'||unit field ||','||
value field2 ||'~'||unit field ||','||
value field3 ||'~'||unit field ||','||
value field4 ||'~'||unit field ||','||
unit field||','||

Oracle Database DB Reporting Tools

Last Comment

johnsone

9/2/2013

Rindbaek

9/2/2013

if you want to exclude rows where values 1 to 4 all are empty (null) add a where clause

where
value field 1 is not null AND
value field 2 is not null AND
value field 3 is not null AND
value field 4 is not null

AmmarDJ

9/2/2013

ASKER

Rindbaek can i use a where clause in a script like the one attached.
instrumentcsv.sql

Rindbaek

9/2/2013

you already have one...

WHERE system = '77';

try:
WHERE system = '77' AND
value field 1 is not null AND
value field 2 is not null AND
value field 3 is not null AND
value field 4 is not null ;

ASKER CERTIFIED SOLUTION

johnsone

9/2/2013

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

AmmarDJ

9/2/2013

ASKER

Johnsone.

Thanks for the feedback.

regarding the nvl function, sounds a a good solution.

But i guess it will report a "null" if there is a null value. What if i just want to report a blank and not "null"

Regards

johnsone

9/2/2013

Change the null at the end of the nvl2 statement to anything you want. Since you are doing string concatenation, if it is null, there is nothing to concatenate.