searock

Get a list of all the packages
adb shell pm list packages

Get the location for the app
adb shell pm path com.example.someapp

Download all the apks
adb pull /path/apk1 .
adb pull /path/apk2 .

searock

# Modifing the APK

This instructions are for mac

Make sure you have java installed and you can access it from the terminal.

Head to apktool website and download the apktool jar and apktool.sh
https://ibotpeaches.github.io/Apktool/install/

Rename the jar to apktool.jar

searock

//class
var package = function (packageName, originLatitude, originLongitude,
    destinationLatitude, destinationLongitude) {
    return {
        packageName : packageName,
        origin : { type : "Point", coordinates: [originLatitude, originLongitude]},
        destination : { type : "Point", coordinates: [destinationLatitude, destinationLongitude]}

    };
};

searock

select column_name, count(column_name)
from table
group by column_name
having count (column_name) > 1;

searock

SELECT *
FROM (SELECT R.*, ROWNUM RNUM, COUNT(*) OVER () RESULT_COUNT 
      FROM (SELECT i.ITEM_CODE, i.ITEM_NAME
            FROM TBL_ITEMS i) R)
WHERE RNUM between 0 and 9 ;