In Application Express, there is no standard way of copying users in an existing workspace to a new workspace. Everytime you create a new workspace, all developers and users must be added manually.
Here’s a little script that does the work for you. Just replace the WORKSPACE with the name of your own workspace where you want to copy the users from, and execute in a SQL Command window in a new workspace. Might save you some time!
declare cursor c_usr is select t.user_name, t.first_name, t.last_name, t.email_address , t.default_schema , fd.developer_role from APEX_040100.WWV_FLOW_FND_USER t join apex_040100.wwv_flow_developers fd on fd.user_id = t.user_id where t.security_group_id = ( select cp.PROVISIONING_COMPANY_ID from apex_040100.wwv_flow_companies cp where cp.short_name = 'WORKSPACE') ; begin for r_usr in c_usr loop APEX_UTIL.CREATE_USER( p_user_name => r_usr.user_name , p_first_name => r_usr.first_name, p_last_name => r_usr.last_name, p_description => null, p_email_address => r_usr.email_address, p_web_password => 'Welkom01', p_developer_privs => r_usr.developer_role, p_default_schema => r_usr.default_schema, p_allow_access_to_schemas => null, p_change_password_on_first_use => 'Y' ); end loop; end;
A question often asked by users, is the addition of tooltips with extended functions (like line breaks or formatting) to Application Express. There is no default functionality in Apex for that, other than the standard alt or title tag in HTML, which I think is rather boring.
There is a more versatile and nice looking alternative for that, called qTip2. It’s an extension for JQuery, which is already incorporated in Apex since version 4.0.
I found it a little challenging to get qTip2 working in Apex, so here’s a how-to for you.
- Download the javascript code at craigsworks. The download contains a file with Javascript code and a CSS file.
- Upload the two files (you can choose a minified or a human readable version) to your application’s Shared Components. There are sections for Cascading Style Sheets and Static Files (for the javascript) in the Files part.
- You need to include the javascript and CSS in your Apex page (or on page 0 to have them linked everywhere in your Application).
- go to the Edit Page section and add this to the HTML Header Atribute :
<link type="text/css" rel="stylesheet" href="#WORKSPACE_IMAGES#jquery.qtip-2.0.0.css" />
- Add this to the Footer Text Attribute a little lower:
<script type="text/javascript" src="#APP_IMAGES#jquery.qtip.js"></script>
- And add this code to the Function and Global Variable Declaration. It replaces the standard title attributes with the qTip attribute. Mind you: alltitle attributes on the page. That’s ok, it ensures a consistent look of your tooltips on the page.
$(document).ready(function() { $('a[title]').qtip(); }); Your page now looks like this:
- Now let’s give it a try. Create a new Text item on your page, and put this in the Label attribute:
<a href="#" title="Your <i>custom</i> label Tooltip">A tooltip label</a>
- And look at the result:
This is a basic example of what you can do with a little help from third party javascript libraries, in this case JQuery with qTip2. Take a look at the examples at the qTip2 website, there is a lot you can change e.g. backgroundcolours, fade effects and positioning.
Of course you can also use the syntax used in step 7 in other parts of your page, like report headers, poplists or just plain text.
Check this page: https://www.spotify.com/nl/download/previews/.
If you follow the instructions (I’ve copied them here for your convenience) Spotify is installed in the Linux distro of your choice. I tried with Ubuntu 11.10 and it works. You need a Premium or Unlimited account though.
# 1. Add this line to your list of repositories by # editing your /etc/apt/sources.list deb http://repository.spotify.com stable non-free # 2. If you want to verify the downloaded packages, # you will need to add our public key sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 4E9CFF4E # 3. Run apt-get update sudo apt-get update # 4. Install spotify! sudo apt-get install spotify-client-qt
Last week I installed OS X Lion, which was great fun. I’m not going to say it is revolutionary, but it certainly has some nice improvements. One particular issue often mentioned on the internet, is that some software stops working on OS X Lion or Mountain Lion.
I needed Oracle SQL Developer, so downloaded the installer from Oracle Technet. To my surprise, it wouldn’t start. It would be very inconvenient if SQL Developer would be broken under OS X for me! After some research I found that OS X Lion does not have a Java Runtime, and SQL Developer does need one.
You might want to check your log files too. I found that SQL Developer generated a whopping 30 gigabytes of logfiles when it couldn’t find the java runtime.
Installing is simple. Go to your terminal, enter java -version and press enter. Voila, OS X asks if you want to install the JRE. Of course you want to! Press Yes and you’re all set to go. Enjoy.
