Tuesday, November 13, 2012

PL/SQL SELECT into array

DECLARE
    TYPE ARRAY_TYPE IS TABLE OF VARCHAR2(20);
    mno_array ARRAY_TYPE;
    mno_id VARCHAR2(20);
BEGIN
     SELECT *
        BULK COLLECT
        INTO mno_array
        FROM (SELECT DT_PARTY.HOST_MNO_ID FROM RESOURCE_DB.HT_SIM_PARTY, RESOURCE_DB.DT_PARTY
                    WHERE HT_SIM_PARTY.PARTY_ID = DT_PARTY.PARTY_ID
                        AND HT_SIM_PARTY.SIM_ID = 'SIM_0000000000000184');
    DBMS_OUTPUT.PUT_LINE('count='||mno_array.COUNT);
    FOR i in 1 .. mno_array.COUNT
    LOOP
        DBMS_OUTPUT.PUT_LINE(mno_array(i));
    END LOOP;
END;

PL/SQL SELECT into hash array

DECLARE
    TYPE HASH_TYPE IS TABLE OF NUMBER INDEX BY VARCHAR2(20);
    mno_array HASH_TYPE;
    mno_id VARCHAR2(20);
BEGIN
    FOR r IN (SELECT DT_PARTY.HOST_MNO_ID FROM RESOURCE_DB.HT_SIM_PARTY, RESOURCE_DB.DT_PARTY
              WHERE HT_SIM_PARTY.PARTY_ID = DT_PARTY.PARTY_ID
              AND HT_SIM_PARTY.SIM_ID = 'SIM_0000000000000184') LOOP
        MNO_ARRAY(R.HOST_MNO_ID) := 1;
    END LOOP;

    IF mno_array.EXISTS('BT') THEN
        DBMS_OUTPUT.PUT_LINE('BT=YES');
    END IF;
END;

Monday, November 12, 2012

Install Mountain Lion

Conf.: Asus P8Z68V LX + Intel Core i5 2500K + RAM Patriot PC3-12800 1600MHz 8GB (2x4GB) + nVidia GT240 512MB GDDR5
  1. Install patched ASUS BIOS v4003 so as to allow for Sleep to work
  2. Create a bootable USB flash drive with Mountain Lion like explained here: UniBeast: Install OS X Mountain Lion on Any Supported Intel-based PC
  3. Boot on USB flash drive: <TAB>, then PCIRootUID=0
  4. Format disk as Mac OS Extended (journaled), options: GUID Partition Table
  5. Install ML
  6. Upgrade to 10.8.2
  7. Download tonymacx86 MultiBeast 5.1.3
  8. Check options as shown:
  9. Reboot, no option
  10. Et voila: a fully working hackintosh with sleep capability on and no DSDT
  11. Keyboard: In order to map my Dell keyboard w/ GB layout, used the wonderful Ukelele w/ Logitech GB layout

Sunday, November 11, 2012

Install a QNAP network HP C5280 printer on Windows 8

Thank you Mr MS for not including the HP C52xx driver into W8.
Download the mostly useless HP software for this printer (362MB!): you will find it easily with Google on the HP website.
Open the HP .exe in WinRAR, and uncompress it.

Goto Panneau de configuration
Then goto Materiel et audio, then "Peripheriques et imprimantes"
Then click on "Ajouter une imprimante"
Then don't let the search finish and click the "L'imprimante que je veux n'est pas repertoriee" link
Enter the name of the QNAP printer:
http://192.168.1.102:631/printers/qnapPR3
then click on "Suivant"


Then select the driver from disk. For this, in HP directory, go into prn_x86 (prn_x64) and select prnhp003.inf
Throw away all the HP bloatware.

Monday, November 5, 2012

List RPM

> rpm -qa

Sunday, November 4, 2012

Install Mountain Lion from InstallESD.dmg

You won't be able to use UniBeast directly with InstallESD.dmg:
Open dmg, and move "Install OS X Mountain Lion" into Applications folder:
Then right click on "Install OS X Mountain Lion", and select "Show Package Contents".
Go into Contents folder, and create a new folder named "SharedSupport":
Then drag InstallESD.dmg into SharedFolder:
You will then be able to proceed through UniBeast: Install OS X Mountain Lion on Any Supported Intel-based PC

Saturday, November 3, 2012

FCPX: Use Disk Images to archive your work

Managing Your FCP X Events & Projects using Disk Images
Then you can move your projects to your Disk Image in order to archive them: