Monthly Archives: July 2010

Displaying multiple records in single row

If you want to display values of multiple records in a single row seperated by commas, it can be done using ‘SYS_CONNECT_BY_PATH’ or also using DBMS_UTILITY.TABLE_TO_COMMA procedure. Example: If you want to display all employee names belonging to dept 10 … Continue reading

Posted in PLSQL | Leave a comment

Migrating Personalization from one instance to another.

Post Courtesy : Satya Roopa Madhuri G Moving Personalizations

Posted in OAF | 2 Comments

Program for recompiling invalid packages

When we compile a package specification and if it has errors, all the dependent packages will become invalid. In such cases we may need a script which automatically identifies the packages which are in invalid status and recompile them to … Continue reading

Posted in PLSQL | 2 Comments