Oracle - String Aggregate Functions

Hi Everyone, If there is a requirement to list values from multiple rows to a single row related with a specific value, Oracle string aggregation function can be used to achieve this. Below are the different methods available in different versions of Oracle.  LISTAGG Analystic Function in 11g Release 2 SELECT DEPTNO, LISTAGG(ENAME, ',')  WITHIN GROUP (ORDER BY ENAME) AS EMPLOYEES FROM   EMP GROUP BY DEPTNO; WM_CONCAT...

Read More

MS SQL Server - How to get the last change date of table data and schema?

Hi Everyone, Do you need to know when was the last change (Insert, Update or Delete) happened in the SQL Server table data and the table meta data (schema change)? If you are searching for answers for the above questions, here I am with the answers. Script to find the last schema change date of a table, you will need to supply table name in the where clause. Run this query in the target database. SELECT NAME AS TABLENAME , MODIFY_DATE AS LAST_SCHEMA_CHANGE FROM...

Read More

How to root Micromax Canvas 2 A110 with Original Jelly Bean 4.1.1 ROM?

Follow the steps if you want to root your Micromax Canvas 2 A110 with a Jelly Bean 4.1.1 ROM. Download the below files before we start the process. 1.  Micromax Stock A110 JB 1.11  (01_Micromax_Stock_A110_JB_1_11.zip) Download 2. Micromax A110 VCOM Drivers (02_Micromax_A110_VCOM_Driver.zip) Download 3. SP Flash Tool v3.1224 (03_SP_Flash_Tool_v3_1224.zip) Download 4. CWM Recovery for Micromax Canvas 2...

Read More