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

Oracle LazyDBA home page