OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » No. of Rows

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

No. of Rows [message #20930]

Tue, 02 July 2002 04:59

Giri Gajjela
Messages: 14
Registered: June 2002

Junior Member

Hi,

I am executing one select statement using the execute immediate (Dynamic SQL). I would like to get the no. of rows processed by this select statement.

How to get it?

Regards,
- Giri Gajela

Report message to a moderator

Re: No. of Rows [message #20931 is a reply to message #20930]

Tue, 02 July 2002 05:03

Giri Gajjela
Messages: 14
Registered: June 2002

Junior Member

I got the answer.

Thanks
- Giri Gajjela

Report message to a moderator

Re: No. of Rows [message #20934 is a reply to message #20930]

Tue, 02 July 2002 05:54

Balaji
Messages: 102
Registered: October 2000

Senior Member

hi giri
can u share the same with us ? even i wanted to know the answer !

rgds
balaji

Report message to a moderator

Re: No. of Rows [message #20942 is a reply to message #20930]

Tue, 02 July 2002 09:05

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

sql%rowcount

Report message to a moderator

Previous Topic:	Execute immediate not working..please help me out..!!
Next Topic:	Result not showing after execution of this block

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 17 22:45:55 CDT 2024