On Oracle, you can write simple insert/update statements with PL/SQL. Also using some if-then-else cases you can decide wether to insert or to update data.

The much more elegant way to insert or update data with pl/sql is to use Oracle’s MERGE Command (like upsert in mySQL).

Usually within the Merge command, you can join two tables together to check the data. Just search the web - you’ll find many examples with MERGE and JOINS.

But what when you’d only like to MERGE into a single table?

After some tries, I found a solution using the DUAL table.
Just see my MERGE PL/SQL sample. It’s absolutelly easy to understand:

merge into position_table t
        using dual
        on (t.pos_id = p_pos_id)
        when matched then
                update
                set anzahl = p_anzahl
                  , gueltig_ab = p_gueltig_ab
                  , doc_id = p_doc_id
                  , bemerkung = p_bemerkung
        when not matched then
                insert
                   (pos_id
                   ,anzahl
                   ,gueltig_ab
                   ,doc_id
                   ,bemerkung
                   )
                values
                   (p_pos_id
                   ,p_anzahl
                   ,p_gueltig_ab
                   ,p_doc_id
                   ,p_bemerkung
                   )
        ; — ende merge

For example you’re using a Fujitsu Siemens notebook Amilo LI2727

To save energy, FS recommeds to start WLAN manual. But when you’re using the internet every time you start up the notebook this does not make very much sense.

A easy solution to start WLAN automatically: Just copy a shortcut of WisWBSet.exe to the Autostart folder.

It’s easy:

Step 1: Search for your wlan startprogram WisWBSet.exe

(This is already installed on your computer. Acutally this is the program behind you “WLAN-Button” on your notebook). I found it in this directory:

C:\Programme\Launch Manager\WisWBSet.exe
(or C:\Program Files\Launch Manager\WisWBSet.exe)

continue reading "wlan autostart windows vista - amilo li2727 - shortcut WisWBSet.exe to autostart folder"