Hi , Thanks ..

In Oracle Stored procedure , how to see which line is currently
executing ?

I have a SP that does multiple stuff and I want to see which part of SP
is presently executing by Oracle ..

Please Help

Dibyendu

-----Original Message-----
From: Chad Smith
[mailto:oracledba-ezmlmshield-x90442862.[Email address protected]
Sent: Friday, July 29, 2005 2:40 PM
To: LazyDBA Discussion
Subject: RE: Need Help

Update X
Set owner = 'oracle'
Where owner = 'sql'
And rownum < 10001

-----Original Message-----
From: Dibyendu Bhattacharya (dibyendu)
[mailto:oracledba-ezmlmshield-x40323122.[Email address protected]
Sent: Friday, July 29, 2005 12:54 PM
To: LazyDBA Discussion
Subject: Need Help
Importance: Low

Hi ,
I am new to Oracle , I need one help in writing a query ..

I have a table say X , which has 3 columns .. messageKey , owner , and
type

Now , the table has many rows(milions) , where majority of the owner is
say "sql"

Now , I want to write a query , to change the owner to "oracle" to first
10000 rows where owner is sql

Dibyendu


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html





--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page