|
|
|
|
|
|
| Re: Display rownum in tabular form [message #419985 is a reply to message #419946] |
Wed, 26 August 2009 06:03  |
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
| sharjeelshafqat wrote on Wed, 26 August 2009 10:49 | begin
select rownum,column_name into v_field1,v_field2 from table name
exception
when no_data_found then
null;
when too_many_rows then
select rownum,column_name into v_field1,v_field2 from table name
when others;
select rownum,column_name into v_field1,v_field2 from table name
end;
|
What on earth do you think that's going to achieve?
And why are you re-running the query in the exception handlers? If it failed once it's not really going to work a 2nd time.
And will you please read the orafaq forum guide and follow the posting guidelines.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
