|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
September 15th, 2005, 06:21 AM
|
|||
|
|||
accessing rows using rownums.
Is it possible to access the rows using row numbers?I tried many times but except the 1st row i was unable to access any other rows.
try out me to understand the records and index by table in pl/sql.
|
|
#2
September 15th, 2005, 07:12 AM
|
||||
|
||||
|
You can access rows by rowid (unique row identifier), rownum is transparently added to the results of a query and can only be used in that case.
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
#3
September 15th, 2005, 08:10 AM
|
||||
|
||||
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > accessing rows using rownums. |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
