Having 17 year of experince in variety of field including 14 year as IT and
As a Oracle DBA Having 7 year of Experince With PT , Backup and Recovery , Database Migration (sql to ORACLE ),Creating Stand By Database. New Projects Installation.
Have experice in any kind of Trouble shooting in Database. Knowledge of RAC and Dataguard.
Financial prospective of projects and cost reduction
Tuesday, October 7, 2008
Delete duplicate row from table
delete from TABLE_NAME where rowid in (select min(rowid) from TABLE_NAME group by (empid, LOCATION) having count(empid)>1 );
No comments:
Post a Comment