Skip to Content
0
Former Member
Mar 04, 2009 at 05:03 AM

Reg:JDBC Select Key

17 Views

Hi...

I am having mapping problem while doing jdbc scenario.

in oracle table, i am having name,id,active,enable.

The active and enable fields will have values 1 or 0

Name ID Active Enable

Test1 1 1 1

Test2 2 0 0

i need to select all the names where active = 1 and 0 and same for enable = 1 and 0

suppose if the input to the jdbc request is null, then ,

Can you please tell how to use the key field in JDBC request.

select--action

tablename--table

access

Name

ID

Active

Enable

key

?

Can you tell me how to define the key value?

Thanks & Regards,

Leela