Tuesday, January 15, 2013

Why Windows 7 is better than Windows 8

In other words,  why Fidelity Windows 7 gadget  is better than Windows 8 finance app with Live tiles.

Dow Jones index is shown in red which kind of indicates it's down in Fidelity app.


 What's the point in having live tile, if it can't paint the picture using proper color. Why is it in green when the index is down in Windows 8.



Thursday, January 10, 2013

Mapping multiple schemas to Apex Workspace

Unfortunately Apex Admin application doesn't let you map more than one schema to the workspace. However I had a requirement to map 500 schema's to one single workspace (For the creation of training application for 500 Users). APEX_INSTANCE_ADMIN package came in handy and I did it using PL SQL.
Here is how you do it.

SQL> APEX_INSTANCE_ADMIN.ADD_SCHEMA(
p_workspace  => 'MY_WORKSPACE', p_schema => 'MY_SCHEMA');

PS: You can use the same package REMOVE_SCHEMA to remove the mapping as well. Also SYS & SYSTEM schema's cannot be mapped using the same due to security restriction.

Reference to Oracle documentation: http://docs.oracle.com/cd/E37097_01/doc/doc.42/e35127/apex_instance.htm