Hi,
I have an SQL question. I hope this is the appropriate forum for it. I would like to know if there is any way to retrieve a set of rows from a table without using an identifying column ie. primary key. I want to be able to write a
JDBC application where I can plug a table name into a query statement and retrieve
a set of rows,ie rows 50 to 100, without knowing any of the column name or values for that table. I tried writing:
SELECT *
FROM tablex
WHERE rownum BETWEEN 50 AND 100;
This doesn't work. I'd appreciate anyones advice.
Thanks,
Paul