on 06-02-2011 3:18 PM
Hi,
I have an interface with an Oracle database and I need to read only the records that have a null value in a field.
I have created the mappings and all work fine except the selection for this records, in other words I need simulate in the where clausule an 'is null'.
Select field1 field2 from table tab1 where field1 = 'A' and field2 = 'B' and boldfield3 is nullbold
I have try with attributes isNULL and hasQuot but doesn't works
Could somebody help me?
Hai !
I agree with the Query given by BaskerGopal.
Try that.
Regard's
Preethi.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI
you must use "ISNull" in your condition statement.
Naoki
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
try ' ' in your query inplace of Null.
Select field1 field2 from table tab1 where field1 = 'A' and field2 = 'B' and field3 = ' '
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
select <field1>,<field2> from <table> where <fieldn> is null and <fieldm> = 'aaa'
The above query worked for us in Oracle, so guess this should solve your problem
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Try this...
Select field1,field2 from tab1 where field1='A' and field2='B' and field3 IS NULL;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.