1

Topic: and rownum = 1??

select tl.customer_trx_id
from oe_order_headers_all h
,ra_customer_trx_lines_all tl
where h.header_id = 22914495
and (to_char (h.header_id) = tl.interface_line_attribute1 or to_char (h.order_number) = tl.sales_order)
and rownum = 1

The plan (and the fact) gives  tl
If to remove and rownum = 1
That all
I can not understand why so
If to envelop in a subquery, the same hogwash

2

Re: and rownum = 1??

Compote;
And that all is possible on more in detail about ""?
Can show the plan where, by your words, all ?

3

Re: and rownum = 1??

Compote;
[quote =] ORA-00942: the table or representation of the user does not exist
00942. 00000 - "table or view does not exist"