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 Function (Works with 11g Release 1)

SELECT DEPTNO, WM_CONCAT(ENAME) AS EMPLOYEES

FROM   EMP

GROUP BY DEPTNO;

Table Content

Result of the query

Thanks for visiting my blog and reading this article !

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    SYS.OBJECTS

WHERE   NAME = ‘<TABLE>’

Script to find when the table data was last changed, here you will need to specify the database name and the table number. You may require admin privilege to run this query.

SELECT  

OBJECT_NAME(OBJECT_ID) AS TABLENAME ,

LAST_USER_UPDATE ,

USER_UPDATES ,

INDEX_ID

FROM    SYS.DM_DB_INDEX_USAGE_STATS

WHERE   DATABASE_ID = DB_ID(‘<DATABASENAME>’)

AND OBJECT_ID = OBJECT_ID(‘<TABLENAME>’)

Hope this helped you, Thanks for reading this article !

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 A110 (recovery.img) Download

5. SuperSU v1.04 (05_SuperSU_v1_04.zip) Download

Warning: Before we start with the process, This site will not be responsible for any data loss  if you make any Mistakes and Bricked Devices. If you root your phone, it will void the  warranty.

And here are the steps you should follow.

1.  First install Micromax Canvas 2 A110 drivers (Available in the built-in drive with the phone available in the USB Mass storage).

2. Connect your phone via USB now switch off phone without disconnecting and wait for few minutes while all the drivers are installed.

3. Unzip the Micromax A110 VCOM Drivers and install the drivers.

4. Unzip the SP Flash Tool v3.1224 and open the tool Flash_tool.exe.

5. Click on the “Scatter-loading” button and select the “MT6577_Android_scatter_emmc.txt” from the Micromax Stock A110 JB 1.11 zip file.

6. Now make sure you have deselected every options except “RECOVERY”.

7. Click on “RECOVERY” and select the recovery.img (Make sure name is  recovery.img)

8. Now turn-off the phone, remove the battery and disconnect it from the PC.

9. Click the “Download” button in the Smart Phone Flash Tool.

10. Now connect the phone via USB (In the state  mentioned in the step 8) to the PC, you will see the progress bar that the image is getting downloaded to the phone and once completed you will see the popup window a green circle.

11. Close the SP Flash Tool,  turn on the phone and copy the 05_SuperSU_v1_04.zip file (Without unzipping) to the phone SD Card.

12. Switch off the phone and then switch on by pressing Volume Up + Volume Down + Power Button together. Select the recovery , get into the CWM recovery, choose the option Install from SD card,  select the 05_SuperSU_v1_04.zip file and install the file.

13. Restart the phone normally you will find SuperSU App in the phone.

Now your phone is rooted!

Thanks to the people who share this download files. Thanks for reading this article!

Read More