RE: Need Help

RE: Need Help

 

  


I guess you could use dbms_output.putline before you execute each
update. I think if you just look at the current SQL in EM or the data
dictionary, you will get only variables (so you wouldn't know the exact
row), but I could be wrong.


-----Original Message-----
From: Dibyendu Bhattacharya (dibyendu)
[mailto:oracledba-ezmlmshield-x18168339.[Email address protected]
Sent: Friday, July 29, 2005 2:18 PM
To: LazyDBA Discussion
Subject: RE: Need Help


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


--------
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