Skip to Content
avatar image
Former Member

JDBC oracle: statement to select only 1 record

Hi,

I have a scenario where i need to read only one specific

record from an oracle database using the "WHERE" statment

for specific condition.

Could you please provide with an example ?

Thanks

Antonis

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Oct 15, 2008 at 02:17 PM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 15, 2008 at 02:19 PM

    In the Sender JDBC Adapter in Processing Tab at the Query SQL Statement mention

    "SELECT SINGLE * FROM table WHERE processed = 0;"

    Edited by: SEBIN B THOMAS on Oct 15, 2008 10:20 AM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 15, 2008 at 02:29 PM

    Use the primary Key value for the table in WHERE clause.

    Primary key is always unique and will return only 1 record.

    Thanx

    Aamir

    Add comment
    10|10000 characters needed characters exceeded