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
Oracle LazyDBA home page