Showing posts from August, 2023
How to generate distinct values in a column with comma separated using LISTAGG function in Oracle with data as ( select BNU_USER, STATE, DISTRICT_NAME, listagg(VILLAGE_NAME,',') within group…
Oracle Database startup throws ORA-00214 after abrupt shutdown ( due to power failure ) Issue SQL> startup ORACLE instance started. Fixed Size 2256752 bytes Total System Global Area 2889490432 bytes Variable Size 1124073616 bytes Database Buffe…
