OFFSET function in oracle

[¢Ð¢ý¢ö]

I want to retrieve a range of record
such as retrieving 11th to 20th records from 10000 records
In SQL Server, i can use the "OFFSET" function.
so i wanna ask does Oracle provide any function similar to "OFFSET" in SQL
SERVER?

Thanks in advance
Regards
Bun

[Christine]

this may help you ....

select * from mytable where rownum <= 20
minus
select * from mytable where rownum <= 10
"¢Ð¢ý¢ö" <@.@> wrote in message news:<bp******* ***@imsp212.net vigator.com>...

I want to retrieve a range of record
such as retrieving 11th to 20th records from 10000 records
In SQL Server, i can use the "OFFSET" function.
so i wanna ask does Oracle provide any function similar to "OFFSET" in SQL
SERVER?

Thanks in advance
Regards
Bun

[Guido Konsolke]

"Christine" <ka******@hotma il.com> wrote...

this may help you ....

select * from mytable where rownum <= 20
minus
select * from mytable where rownum <= 10

Hi Christine,

you're kidding, right?

[Ethel Aardvark]

Well write a little PL/SQL and do it yourself. It might look less
efficient than SQL Server, but that's pretty much what it does
internally.

ETA

"Guido Konsolke" <[e-mail] m> wrote in message news:<10******* ********@news.t hyssen.com>...

"Christine" <ka******@hotma il.com> wrote...

this may help you ....

select * from mytable where rownum <= 20
minus
select * from mytable where rownum <= 10

Hi Christine,

you're kidding, right?

[VC]

select * from
( select t1.*, rownum rn from ( select * from t1 order by x ) t1
where rownum <= upper_limit )
where rn >= lower_limit;
"¢Ð¢ý¢ö" <@.@> wrote in message news:bp******** **@imsp212.netv igator.com...

I want to retrieve a range of record
such as retrieving 11th to 20th records from 10000 records
In SQL Server, i can use the "OFFSET" function.
so i wanna ask does Oracle provide any function similar to "OFFSET" in SQL
SERVER?

Thanks in advance
Regards
Bun

[mcstock]

this question seems to pop up every few days

good solution, but don't forget to take a larger look at your application

if the user is paging thru a large set of records, consider some mechanism
to pre-select the PKs for the entire set and then use these to fetch each
page -- the performance trade off can come after only one or two pages. and
depending on your development tool, you could keep one cursor for doing the
PK fetches as needed, and use a second one for grabbing the current page of
data

-- mcs

"VC" <bo*******@hotm ail.com> wrote in message
news:Vppvb.2028 77$275.751945@a ttbi_s53...
| select * from
| ( select t1.*, rownum rn from ( select * from t1 order by x ) t1
| where rownum <= upper_limit )
| where rn >= lower_limit;
|
|
| "¢Ð¢ý¢ö" <@.@> wrote in message
news:bp******** **@imsp212.netv igator.com...
| > I want to retrieve a range of record
| > such as retrieving 11th to 20th records from 10000 records
| > In SQL Server, i can use the "OFFSET" function.
| > so i wanna ask does Oracle provide any function similar to "OFFSET" in
SQL
| > SERVER?
| >
| >
| >
| > Thanks in advance
| > Regards
| > Bun
| >
| >
|
|

[Christine]

"Guido Konsolke" <[e-mail] m> wrote in message news:<10******* ********@news.t hyssen.com>...

"Christine" <ka******@hotma il.com> wrote...

this may help you ....

select * from mytable where rownum <= 20
minus
select * from mytable where rownum <= 10

Hi Christine,

you're kidding, right?

this should work ->

select rownum, * from mytable where rownum <= 20
minus
select rownum, * from mytable where rownum <= 10

[Christine]

how come i can't delete my meg???
THIS should work, really... ->

select rownum, col1, col2 ... from mytable where rownum <= 20
minus
select rownum, col1, col2 ... from mytable where rownum <= 10
* replace (col1, col2 ...) to whatever colname you want to select.