Delete Duplicate Rows from Oracle Table

DELETE FROM EMPLOYEES WHERE ROWID NOT IN
(SELECT MIN(ROWID)
FROM EMPLOYEES
GROUP BY LAST_NAME ) ;

How to compile Forms in 11i and R12

Compile Forms in 11i

$ f60gen module=<formname>.fmb userid=apps/<apps_pwd> output_file=$XX_TOP/forms/US/<formname>.fmx


Compile Forms in R12

$ frmcmp_batch <formname>.fmb userid=apps/<apps_pwd> output_file=$XX_TOP/12.0.0/form/US/<formname>.fmx module_type=form compile_all=special

Oracle will retire several certification tracks effective November 1, 2011

Exams to be retired November 1:

1Z0-109 Oracle WebLogic Server 10g Developer
1Z0-110 Oracle Weblogic Portal 10g Developer
1Z0-200 Oracle 11i E-Business Essentials
1Z0-207 Oracle Comm. Billing & Revenue Mgmt.: Pricing
1Z0-208 Oracle Comm. Billing & Revenue Mgmt.: Server Developer
1Z0-209 Oracle Comm. Billing & Revenue Mgmt.: System Administrator
1Z0-211 Oracle 11i General Ledger Fundamentals
1Z0-212 Oracle 11i Payables Fundamentals
1Z0-213 Oracle Receivables 11i Fundamentals
1Z0-221 Oracle 11i Inventory Management Fundamentals
1Z0-222 Oracle 11i Purchasing Fundamentals
1Z0-223 Oracle 11i Order Management Fundamentals
1Z0-231 Oracle 11i 2.6 Implement Workflow
1Z0-232 Oracle 11i System Administration
1Z0-233 Oracle 11i Install, Patch and Maintain Applications
1Z0-235 Oracle 11i Applications DBA: Fundamentals I
1Z0-236 Oracle 11i Applications DBA Fundamentals II
1Z0-255 Hyperion Essbase 7.1.2 Consultant
1Z0-257 Hyperion Financial Management 4.1 Consultant
1Z0-259 Hyperion Planning 4.1 Consultant
1Z0-262 Hyperion Planning 4.1 Administrator
1Z0-263 Hyperion System 9 BI+ 9.0 Administrator
1Z0-273 Hyperion Financial Management 4.1 Administrator I & II
1Z0-301 Oracle9iAS: Basic Administration
1Z0-615 Siebel 7.7 Consultant Core Exam
1Z0-620 Siebel 7.7 Analytics Application Developer Professional Exam
1Z0-630 Siebel 7.7 Analytics Server Architect Professional Exam
1Z0-640 Siebel 7.7 Analytics Data Warehouse Developer Professional Exam

Just Words

Believe that anything you can imagine you can achieve it real.
Having the devotion,passion and dedication to learn & Work

“Knowledge grows when it is shared“.