How to Select 38th row details in table without using rownum ?

Question Posted / nvsubbareddy

Answers were Sorted based on User's Feedback

How to Select 38th row details in table without using rownum ?..

Answer / vinu

select * from <tablename> where rownum='38'

Is This Answer Correct ?

2 Yes

15 No

How to Select 38th row details in table without using rownum ?..

sdf
sdf
f
sdf
sdf
sdf
sdf
sdf
sdf

Is This Answer Correct ?

4 Yes

18 No

More Oracle Errors Interview Questions

ORA-32732: Parallel Oradebug session is aborted

ORA-39103: Timeout before worker process string finished initialization. Worker error:

ORA-30018: Create Rollback Segment failed, USN string is out of range

NNL-00215: Scheduled specified index number's next auto-refresh to occur in string

ORA-32762: Turn on Temp LOB Ref Count Tracing

ORA-13707: Either the start snapshot string or the end snapshot string is incomplete or missing key statistics.

DRG-13303: value of wildcard offset must be in the range string..string, at line string

NID-00307: Control File string - dbid changed, wrote new name

ORA-00020: maximum number of processes (string) exceeded

ORA-01636: rollback segment 'string' is already online

ORA-12435: invalid audit success: string

ORA-30553: The function is not deterministic

For more Oracle Errors Interview Questions Click Here