| jayesh |
Posted: Mar 08, 2008 10:12:33 AM |
Total Post: 60
Joined: Jan, 2008
|
hi
i want to retrieve rows of a column as per the given series of rownum
1,4,7,10....how can i do it pls tell me. |
|
|
 Orcl.sg |
| Posted: Mar 08, 2008 10:00:29 PM |  |
|
Total Post: 12
Joined: Dec, 2007
|
SQL> select HIGH_OPTIMAL_SIZE,OPTIMAL_EXECUTIONS from DBA_HIST_SQL_WORKAREA_HSTGRM where rownum in (1,2,3,4) order by HIGH_OPTIMAL_SIZE;
HIGH_OPTIMAL_SIZE OPTIMAL_EXECUTIONS
----------------- ------------------
4095 133665
131071 728
262143 141
524287 114
|
|
|
|
|
| jayesh |
| Posted: Mar 09, 2008 04:50:07 AM | |
|
Total Post: 60
Joined: Jan, 2008
|
|
|
|
|
| jayesh |
| Posted: Mar 10, 2008 11:57:01 AM | |
|
Total Post: 60
Joined: Jan, 2008
|
i tried the given query but its not working
i m just practicing at home and error i got is table orview does not exists.
pls suggest me any other way.
thanx in advance.
|
|
|
|
|
| positive |
| Posted: Jun 29, 2008 08:45:37 PM | |
|
Total Post: 361
Joined: Jun, 2008
|
http://neworacledba.blogspot.com/
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
