ROW_NUMBER () OVER (PARTITION BY) functionality in oracle 12c

Usage of ROW_NUMBER () OVER (PARTITION BY) functionality in oracle 12c. This is use for main two purpose 1) It assign new index for row as per repeat Field in Table 2) While you want to convert row to Column (Each row can be convert in Column for another table) EX: ¬†I have Data table…

ORA-12541: TNS:no listener

This error is occurs when oracle service is stopped in database server. You just need to restart this service by following step. 1 ) Open Database Server 2) Open Command prompt and move to till C:/ 3 ) Type following command C:\>lsnrctl start 5) Open your application it will work properly..