Friday, February 25, 2011

How to update date filed in Oracle like SQL

Update tableName set date =to_date(‘6/5/2011’,’mm/dd/yyyy’) where ---

How to get top n Record in Oracle like Sql

Sample Query to get Top n Record from oracle

Select * from tableName where FiledName =”” and rownum<=5

Above statement will give u top 5 record
rownum<=5