APEX Popup LOV with more columns

Today I found a really neat plug-in to Oracle's APEX.

Have a look here: http://www.apex-plugin.com/oracle-apex-plugins/item-plugin/skillbuilders-super-lov_75.html


All's well, ut there is a downside to using this plug-in. Cascading Parent LOV's are not supported yet. I hope they will soon. So I came up with an alternative that does use the native popup LOV.

• I altered the template that displays the LOV to use a fixed with font for the body
• I use LPAD and RPAD in combination with ' | ' to neatly outline the columns

the result looks like this:

Maybe is not the most beautiful solution, but it suffices for now.

APEX 4.0.2 is installed

OK Guys,

APEX 4.0.2 has been installed without any trouble. just follow the instructions provided by Oracle.

Digital Nativity

This you gotta check out.

Fantastic:

Oracle Database Development Tools (ODDT): APEX 4.0.2 is here, and its got two new themes!

As soon as I find the time I'm going to investigate further:

Oracle Database Development Tools (ODDT): APEX 4.0.2 is here, and its got two new themes!: "Oracle Application Express (APEX) 4.0.2 patch is now available on MySupport and a re-release is available on OTN as of last Friday November ..."

Oracle 11g on Windows DBConsole does not start

Wow. I have broken my thoughts about this for a loooooong time. In the end stuff can be so simple:

When you get the errormessage that it cannot  start the DBConsole do this:

• Make sure you have the MS loopback adapter installed (remember my previos Blog-entry)
• Make an entry in your hosts file:
  xx.xx.xx.xx yyyy
  where xx.xx.xx.xx is your fixed IP-number on the MS Loopbackadapter and yyyy is your computrename
• Restart the service

That should do the trick

Great thanks to http://www.ywema.com/yweblog/2008/09/oracle-11g-dbconsole-en-apex/

Oracle DB on a notebook

If you want to install an Oracle database on a notebook, then it is essential that beforehand you install the MS Loopback adapter. This is a "virtual" network adapter.

After installation assign it a fixed IP-addres (192.168.99.99 for example) and you're ready to install the Oracle Listener and Database instances.

You should not believe people who claim that Oracle doesn't need it anymore. Maybe Oracle can do without the loopback adapter, but it will prevent a lot of issues that you would need to solve manuallly.

What Are Private And Public IP Addresses?

A computer on the Internet is identified by its IP address. In order to avoid address conflicts, IP addresses are publicly registered with the Network Information Centre (NIC). Computers on private TCP/IP LANs however do not need public addresses, since they do not need to be accessed by the public. For this reason, the NIC has reserved certain addresses that will never be registered publicly. These are known as private IP addresses, and are found in the following ranges:

• From 10.0.0.0 to 10.255.255.255
• From 172.16.0.0 to 172.31.255.255
• From 192.168.0.0 to 192.168.255.255

Transfer Dreamweaver 8 from Windows to Wine (or another Windows) including all Extensions

Well.. First of all I must say that I don;t know how legal all this is... On the other hand I do have all the licenses, but my extension supplier (InterAkt) has been taken over by Adobe and don't provide support on the extensions anymore.


I really learnt to love them, I cannot do without them.

So here's how it works:

1. Create a directory-structure where you are going to store all the files to be transferred. For example 
• D:\DW8Transfer\
• D:\DW8Transfer\Program Files\
• D:\DW8Transfer\Program Files\Common Files\
• D:\DW8Transfer\Windows\
• D:\DW8Transfer\Windows\System32\
• D:\DW8Transfer\windows\profiles\All Users\
2. start regedit and export the key:HKEY_LOCAL_MACHINE/Software/Macromedia
   Save the file as D:\DW8Transfer\macromedia.reg
3. Copy the folder Macromedia from C:\Program Files\ to D:\DW8Transfer\Program Files\
4. Copy the folder Macromed from C:\Windows\System32\ to D:\DW8Transfer\windows\system32\ (yes Macromed and not Macromedia)
5. Copy the folder Macromedia from C:\Documents and Settings\All Users\Application Data\ to D:\DW8Transfer\windows\profiles\All Users\
6. Copy the folder Macromedia from C:\Program Files\Common Files\ to D:\DW8Transfer\Program Files\Common Files\

Copy the contents of the D:\DW8Transfer\ folder into the C:\ drive of your new machine. All stuff should get copied into the correct folders on the target filesystem.

Import the reg file on the target machine.

You should be able to run Dreamweaver now.

How to stop Tortoise SVN from asking for username and password

The easiest way to do this is to right click in Windows Explorer, select Tortoise > Settings.

Then in the Settings window select the Network tab. Then in the SSH client field, set use the Tortoise SSH client, TortoisePlink, to use your username and password. For example:
D:\TortoiseSVN\bin\TortoisePlink.exe -l username -pw password