Category Archives: PLSQL

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

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