tag:blogger.com,1999:blog-86588157148967968872024-02-07T12:10:06.619+00:00Paul Broughton's BlogMy blog is to relay my thoughts, talk about APEX and Oracle. It's also to post any adventures I have along the way.Paul Broughtonhttp://www.blogger.com/profile/06669084384271543017noreply@blogger.comBlogger17125tag:blogger.com,1999:blog-8658815714896796887.post-4149981540654885912014-07-01T09:22:00.000+01:002014-07-01T09:22:18.446+01:00New APEX Meetup Leeds - 13 August 2014<b>Are you an APEX enthusiast or just want to learn more? </b><br />
Well, this is your chance! I have created a new <b><a href="http://www.meetup.com/orclapex-Leeds/">APEX Meetup Group in Leeds</a></b>. This will be the first of its kind in the UK and the first event has been planned for<b> <a href="http://www.meetup.com/orclapex-Leeds/events/191140412/">August 13th 6 - 9pm</a></b> It will be held at the University of Leeds so keep the date free in your calendar and come join us. Tell your friends and your colleagues, all are welcome.<br />
<br />
<b>RSVP for the Event Now:</b> <a href="http://www.meetup.com/orclapex-Leeds/events/191140412/">http://www.meetup.com/orclapex-Leeds/events/191140412/</a><br />
<br />
<b>Join the Meetup Group Now:</b> <a href="http://www.meetup.com/orclapex-Leeds/">http://www.meetup.com/orclapex-Leeds/</a><br />
<br />
<b>So why have I decided to do this?</b><br />
Well, anyone who knows me will know that I am a massive Geek and also that I live and breathe APEX. This is another way of getting involved in the APEX community and sharing knowledge and ideas with each other. It is the first time I have run this kind of event but with the meticulous planning and great people, both presenting and attending, I'm sure this will be a success! I want to emphasise that this event is not solely for those based in Leeds. <b>Everybody is welcome, from near or afar!</b><br />
<br />
<b>Thank you</b><br />
The next thing I want to say is a massive thank you to <b>Anthony Rayner from Oracle</b> for agreeing to come up and present and show us some of the great new features <b>APEX 5.0</b> has to offer, as well as helping to plan the event and put it together.<br />
<br />
<b>More about the Event</b><br />
We have left the arrival time open so you can come any time between 6 and 7, which will allow people to come either straight from work or a little later. It will also give time for anyone coming by train or further afield the chance to get to Leeds. Around half 6 we will be getting some pizzas for everyone and if you do come a little later we will have some left so don't worry. We will also have some refreshments for everyone.<br />
<br />
Around 7 there will be a welcome talk outlining some of the plans for future events. This will be followed by the eagerly anticipated presentation from Anthony on APEX 5.0. We will then have a short break for refreshments.<br />
<br />
We are then going to end with a Q&A Panel with some <b>APEX Experts</b> that are ready to answer any questions you throw at them so make sure you have some questions ready.<br />
<br />
<b>Spaces are limited so <a href="http://www.meetup.com/orclapex-Leeds/events/191140412/">RSVP</a> Now</b><br />
<br />
After the event, we're going to be heading into town for a drink or two. Of course, all are welcome to join us.<br />
<br />
If anyone has any questions, feel free to send me an email or post a comment and I will be happy to answer.Paul Broughtonhttp://www.blogger.com/profile/06669084384271543017noreply@blogger.com3tag:blogger.com,1999:blog-8658815714896796887.post-11840331579568136992014-04-15T00:23:00.000+01:002014-05-29T00:24:02.333+01:00Just GageThis is just a quick post, in one of my applications I needed a nice gage.<br />
<br />
After viewing a few options I decided to use <a href="http://justgage.com/">Just Gage</a>.<br />
<br />
To set it up it was pretty simple:<br />
<br />
Download the Javascript files and link in the page template:<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkWTAdN-BhqC89ZG761Rp3aJnsDS7x4DMILghx06ROIrYs4Igkpg2QNyD8D6V3O4Ih-veKDZ69UzRJuTX32Uyx_yKvdqa96iIfWXOzCX69FOuoIL8DRU2_rjneRiNmjJlsxz1MX64Cy8Q/s1600/template.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkWTAdN-BhqC89ZG761Rp3aJnsDS7x4DMILghx06ROIrYs4Igkpg2QNyD8D6V3O4Ih-veKDZ69UzRJuTX32Uyx_yKvdqa96iIfWXOzCX69FOuoIL8DRU2_rjneRiNmjJlsxz1MX64Cy8Q/s1600/template.png" height="488" width="640" /></a></div>
<br />
Next create a new region with some Div's where the Gages will Appear and some items to retrieve your value:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjm-NdDxCZYPf_mkRMBBR7N2ewIJIiTCQW2-RZegWUPVnMisQCOKxOAA8w8Z275rJcU5lHwi3uIQej7kJK2swpMAXIg9itZadV38bgW5XPePtsUExSXMKHqrHWvUe3hcbjLT4Bca2z6T4c/s1600/region.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjm-NdDxCZYPf_mkRMBBR7N2ewIJIiTCQW2-RZegWUPVnMisQCOKxOAA8w8Z275rJcU5lHwi3uIQej7kJK2swpMAXIg9itZadV38bgW5XPePtsUExSXMKHqrHWvUe3hcbjLT4Bca2z6T4c/s1600/region.png" height="196" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyNaTcX_rl_0PAz_8jKV87iLVtLy-HUK13C0DhYsJSa_EytSGUNuL59G4RxAmpt4MVBKsBnC5xlX5gnIDIBQE7cjnqKpU9woKY2OuS1zqu1Xb6ag1Kq5NbpGBn3gbw8qd2iwr5JykyhDs/s1600/item.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyNaTcX_rl_0PAz_8jKV87iLVtLy-HUK13C0DhYsJSa_EytSGUNuL59G4RxAmpt4MVBKsBnC5xlX5gnIDIBQE7cjnqKpU9woKY2OuS1zqu1Xb6ag1Kq5NbpGBn3gbw8qd2iwr5JykyhDs/s1600/item.png" height="351" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Nearly there now for the dynamic action, just a page load dynamic action that will execute javascript:</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiH_VXGsbxOuXnYLAkLwyfWdfU7fIB710hXAUMGIy5CE5hyphenhyphenwaav2hmYw9-ifyHufmQIoaPVB2kIk52j2sCwTF3l9swUjDghhmud5HsPrPJC_WGvMoUd4UqKac9cu74pO0Htw2P80bYhmj4/s1600/da_page_load.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiH_VXGsbxOuXnYLAkLwyfWdfU7fIB710hXAUMGIy5CE5hyphenhyphenwaav2hmYw9-ifyHufmQIoaPVB2kIk52j2sCwTF3l9swUjDghhmud5HsPrPJC_WGvMoUd4UqKac9cu74pO0Htw2P80bYhmj4/s1600/da_page_load.png" height="238" width="400" /></a></div>
Next the Javascript:<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhvEtu4sO0O1cDlfNih2Eb1HgAul74upxzvOsa6mXTzaib_wct5pFP3lrPjPLtFZqhJYTNSPgcesHlwS8bmie6dLvW8UAOIv6cZ-vnqCqb2I-BYLjQLiDRk3JjrvQgj6s_hEhAFCAhLiEM/s1600/da_settings.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhvEtu4sO0O1cDlfNih2Eb1HgAul74upxzvOsa6mXTzaib_wct5pFP3lrPjPLtFZqhJYTNSPgcesHlwS8bmie6dLvW8UAOIv6cZ-vnqCqb2I-BYLjQLiDRk3JjrvQgj6s_hEhAFCAhLiEM/s1600/da_settings.png" height="387" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Now the final home page, this is just an example. Just gage has many custom options that can be used including custom selectors so you can set levels and varying colours which is very useful.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFE4sCRRT9UIIW2LAmN68PMgBS9Ma5RIlWdx3TOsVOB7kwDZJuwtL9BQhIlIyRyNCZ0uQ3a0Vcq0UJ8J_dDerCN9oA34h8gv5JFfvw0UkS1ZAuylUC0oD0b0zfRrF961H3eyA6dIvqwzs/s1600/jg_home.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFE4sCRRT9UIIW2LAmN68PMgBS9Ma5RIlWdx3TOsVOB7kwDZJuwtL9BQhIlIyRyNCZ0uQ3a0Vcq0UJ8J_dDerCN9oA34h8gv5JFfvw0UkS1ZAuylUC0oD0b0zfRrF961H3eyA6dIvqwzs/s1600/jg_home.png" height="294" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
I will get round to turning this into a plugin but might take me a little while. When I did this in the production app I had 4 gages going across the page which gave a really nice dashboard feel.</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
Paul Broughtonhttp://www.blogger.com/profile/06669084384271543017noreply@blogger.com3tag:blogger.com,1999:blog-8658815714896796887.post-50410979284790581772014-02-18T11:11:00.000+00:002014-02-18T11:11:44.532+00:00Joining the AE Network<div>
I have been working for APEX Evangelists for nearly five years now, during which time I have learnt a great deal and worked on many different projects with a variety of clients. Over these past few years, I have developed many new skills and techniques, which have helped me grow as a developer.</div>
<div>
<br /></div>
As some of you will have seen, APEX Evangelists is currently undergoing a transition phase. You can see more about this on <a href="http://jes.blogs.shellprompt.net/">John's</a> or <a href="http://dgielis.blogspot.co.uk/">Dimitri's</a> blog. <br />
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjy-aGLLNRKuTuqto-e0wAYKEbBPJ9X5ZPJw0vy-tbqg91aQxp1P_LoelGh552q2fpfpcUlot4_BL0ZJa7OBwJnl_86-_e7JKlSXaM_qljODNTYuUGImvLhOE12Y5CYlkwnTRGetxvbG5o/s1600/paul.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjy-aGLLNRKuTuqto-e0wAYKEbBPJ9X5ZPJw0vy-tbqg91aQxp1P_LoelGh552q2fpfpcUlot4_BL0ZJa7OBwJnl_86-_e7JKlSXaM_qljODNTYuUGImvLhOE12Y5CYlkwnTRGetxvbG5o/s1600/paul.jpg" /></a> </div>
<div class="separator" style="clear: both; text-align: left;">
The next stage of the transition for me is becoming a member of the <a href="http://apex-evangelists.com/">AE Network</a>, which is a great honour and I look forward to what the future holds.</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div>
<br /></div>
Paul Broughtonhttp://www.blogger.com/profile/06669084384271543017noreply@blogger.com1tag:blogger.com,1999:blog-8658815714896796887.post-69516292652680009002012-12-11T09:19:00.000+00:002014-02-08T01:08:46.965+00:00Twitter Bootstrap Checkboxes and APEX 4.2<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
The issue:</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
I had an APEX application in which I included Twitter Bootstrap during development. This application was developed prior to the grid layouts and Twitter Bootstrap being shipped with APEX 4.2. The below fix works successfully for firefox only.</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
This is what happened on my page in both IE and Firefox. There is extra white space to the right of my page:</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnZqpUk9DVtka-8VVS4AnA3O2-oVr_EbDBq4JDy_ojj5JaooU-alEILDNvrb09WuPFslhTjS1wR3tG_xaZuhgz9pIce4stBJo6-uRpuWVRgzjJO-X-EJ-ntS0Tbhy1uf5EWROHiPmot0k/s1600/right_page.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnZqpUk9DVtka-8VVS4AnA3O2-oVr_EbDBq4JDy_ojj5JaooU-alEILDNvrb09WuPFslhTjS1wR3tG_xaZuhgz9pIce4stBJo6-uRpuWVRgzjJO-X-EJ-ntS0Tbhy1uf5EWROHiPmot0k/s1600/right_page.png" /></a></div>
<br /></div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
After spending some time looking into this, I realised the issue was related to the checkbox items on this page and the same happened on other pages.</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
When I looked at the html for the checkbox in firebug, I found the following:</div>
<pre style="background-color: #f4f4f4; border: 0px; color: #666666; font-family: 'Courier 10 Pitch', Courier, monospace; font-size: 13px; line-height: 1.5; margin-bottom: 1.625em; outline: 0px; overflow: auto; padding: 0.75em 1.625em; vertical-align: baseline;"><fieldset class="checkbox_group" id="P11_CK1" tabindex="-1">
<legend class="hideMeButHearMe">test</legend>
<input type="checkbox" checked="checked" value="Y" name="p_v11" id="P11_CK1_0"><label for="P11_CK1_0">Show Planned Spend</label>
</fieldset></pre>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
If I then removed the “legend class” from the html, the white space disappeared and my page reverted to the correct size.</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
As Bootstrap is now shipped with APEX 4.2, my next step was to check the css contained within the original Bootstrap css file I included for the “legend class”. It contained the following:</div>
<pre style="background-color: #f4f4f4; border: 0px; color: #666666; font-family: 'Courier 10 Pitch', Courier, monospace; font-size: 13px; line-height: 1.5; margin-bottom: 1.625em; outline: 0px; overflow: auto; padding: 0.75em 1.625em; vertical-align: baseline;">legend {
display: block;
width: 100%;
padding: 0;
margin-bottom: 27px;
font-size: 19.5px;
line-height: 36px;
color: #333333;
border: 0;
border-bottom: 1px solid #eee;
}</pre>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
After this I checked the css shipped with APEX 4.2 and realised there was a conflict so I commented out the “legend class” directly in the originally included Bootstrap css file:</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
This is line 889 – 901 in the version of the “bootstrap.css” I’m using.</div>
<pre style="background-color: #f4f4f4; border: 0px; color: #666666; font-family: 'Courier 10 Pitch', Courier, monospace; font-size: 13px; line-height: 1.5; margin-bottom: 1.625em; outline: 0px; overflow: auto; padding: 0.75em 1.625em; vertical-align: baseline;">/*
legend {
display: block;
width: 100%;
padding: 0;
margin-bottom: 27px;
font-size: 19.5px;
line-height: 36px;
color: #333333;
border: 0;
border-bottom: 1px solid #eee;
}
*/</pre>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
The css shipped with APEX 4.2 is then used and the problem resolved.</div>
Paul Broughtonhttp://www.blogger.com/profile/06669084384271543017noreply@blogger.com1tag:blogger.com,1999:blog-8658815714896796887.post-38738529480292014832012-03-21T09:17:00.000+00:002014-02-08T00:54:56.592+00:00It's a Theme Changer<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
A couple of times recently I have been asked how you can change the colours of APEX report and change the styling of the application without changing the theme. I created a quick app so I could give example.</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
The way I tend to do this is create a separate style sheet that overwrites the standard APEX style sheet. I also use <a href="http://getfirebug.com/.com" style="border: 0px; color: #b41423; font-family: inherit; font-style: inherit; margin: 0px; outline: none 0px; padding: 0px; vertical-align: baseline;" target="_blank">firebug</a> to help me do this as it certainly makes life easier.</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
If you dont have <a href="http://getfirebug.com/.com" style="border: 0px; color: #b41423; font-family: inherit; font-style: inherit; margin: 0px; outline: none 0px; padding: 0px; vertical-align: baseline;" target="_blank">firebug</a> Its definitely something I would recommend, my preferred browser to use it with is firefox but you can get lite versions for other browsers too.</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
First of all I would find the styling for what I want to change by inspecting the element in firebug and change it on the fly to preview my changes</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
Here’s how my homepage looks before any changes with the logo currently been inspected</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbUM-MNjakzOgikBXBdwUjt1d_wMOsTw0POxmnoe0iyMOgby4cUsTfpUwmP_mA84ChbGDbz-15KI4dpR_Y-o34uMIZ1UGOi2klXX86BKNMlmpPuoouJUMZZdvciwFY32kPHfPpG7FkYHU/s1600/tc_1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbUM-MNjakzOgikBXBdwUjt1d_wMOsTw0POxmnoe0iyMOgby4cUsTfpUwmP_mA84ChbGDbz-15KI4dpR_Y-o34uMIZ1UGOi2klXX86BKNMlmpPuoouJUMZZdvciwFY32kPHfPpG7FkYHU/s1600/tc_1.png" height="474" width="640" /></a></div>
<br /></div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
Next I want to show my current CSS shown in firebug when I have inspected the logo text on my page</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrSv0ei69LOHIcpLjd3TnllTNJG_bhLNbEvkHstIiVaHkxgHOXqacQjSfvfL00sWHdbZgzS-L69q7b81OAJtZLxdG-Kc6SR3AjF0J2hV9T6bS8UXO5Ca-QxyHi0toz3z6biZGDKFAxcLk/s1600/tc_2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrSv0ei69LOHIcpLjd3TnllTNJG_bhLNbEvkHstIiVaHkxgHOXqacQjSfvfL00sWHdbZgzS-L69q7b81OAJtZLxdG-Kc6SR3AjF0J2hV9T6bS8UXO5Ca-QxyHi0toz3z6biZGDKFAxcLk/s1600/tc_2.png" height="177" width="400" /></a></div>
<br /></div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
Next my CSS after I changed it in firebug on the fly</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhXFmirutb0Oo1f_EKlfsMLqyNHImkFgj0WO-DEecSimNLsBWgqxwDmHIlOR_FuXjn7VsyaZKQW97uMJ9DK9CrS-vATzl1znFuSNSmWKiEbCqvUXzPJD3ULkv9xWms-VXCzAnrRSeMCCOY/s1600/tc_3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhXFmirutb0Oo1f_EKlfsMLqyNHImkFgj0WO-DEecSimNLsBWgqxwDmHIlOR_FuXjn7VsyaZKQW97uMJ9DK9CrS-vATzl1znFuSNSmWKiEbCqvUXzPJD3ULkv9xWms-VXCzAnrRSeMCCOY/s1600/tc_3.png" height="193" width="400" /></a></div>
<br /></div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
Now my logo with styling changed</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhYyh4Am_ymLbErghMAU_uzfGWWOUJx7VSwh2y5ujn70NO5dABGZIUFKu-ok6APaiC4ckWeu5o8wUIqmI49tDL-LAcq0bV76286vU2DTb_lFp64IvSFozSnYHbQAfKftv4nZBkVMiOEaJs/s1600/tc_4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhYyh4Am_ymLbErghMAU_uzfGWWOUJx7VSwh2y5ujn70NO5dABGZIUFKu-ok6APaiC4ckWeu5o8wUIqmI49tDL-LAcq0bV76286vU2DTb_lFp64IvSFozSnYHbQAfKftv4nZBkVMiOEaJs/s1600/tc_4.png" height="472" width="640" /></a></div>
<br /></div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
I can then very easily copy and paste my changes I made in firebug into an external CSS file that will be used to overwrite the standard CSS permanently.</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
I also changed the styling of my employee report and the region title by changing it on the fly then copying it into my file</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjLos__bT7E1qzAdTBA1YyhSzFTnmL5qY5zb2hYGbk3nTMlqjWL1ZCSiGSlYHtEMNxytXq7n0BWH9y2yd_rLgtrrp3CRshx3WfrRu2TL2j0fTipcCFFlQxDebAxFqMJYkRdSmK253DmUmg/s1600/tc_5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjLos__bT7E1qzAdTBA1YyhSzFTnmL5qY5zb2hYGbk3nTMlqjWL1ZCSiGSlYHtEMNxytXq7n0BWH9y2yd_rLgtrrp3CRshx3WfrRu2TL2j0fTipcCFFlQxDebAxFqMJYkRdSmK253DmUmg/s1600/tc_5.png" height="394" width="640" /></a></div>
<br /></div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
Once I have created my file I can then either store it on my server or upload to APEX</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
To upload to to APEX you can navigate to shared components then Cascading Style Sheets and upload the file</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWDzKgyYuxBVpuryPDsf4XUUbYQkYjRXV7px-Sl5xEysApvW3t8CEbwH5lkaFKONptSA2MaFh6V8FwmNi8yYIkwacuwQm44lSN8afwgfF4I22Bp0XQW4NkdSR143az4YYihxsBiqj8kk8/s1600/tc_7.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWDzKgyYuxBVpuryPDsf4XUUbYQkYjRXV7px-Sl5xEysApvW3t8CEbwH5lkaFKONptSA2MaFh6V8FwmNi8yYIkwacuwQm44lSN8afwgfF4I22Bp0XQW4NkdSR143az4YYihxsBiqj8kk8/s1600/tc_7.png" height="198" width="640" /></a></div>
<br /></div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
By doing this I can then reference the file inside my page template underneath the standard CSS or alternatively on each page by adding to the header text in the page definition</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjL05FQ_4DuQgCSDkeAaNZ59gG8lHqcBxHFsCGFPxishdQ0RSBy9aj_u05o4P-xsnCx4X8LtvVhrcAeLNKXKdb3VeqMLDjH5SH4cw-4aAL60lYGUSWl7p5kX6Kp7wVl7rkfWdlcmhsxDJw/s1600/tc_6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjL05FQ_4DuQgCSDkeAaNZ59gG8lHqcBxHFsCGFPxishdQ0RSBy9aj_u05o4P-xsnCx4X8LtvVhrcAeLNKXKdb3VeqMLDjH5SH4cw-4aAL60lYGUSWl7p5kX6Kp7wVl7rkfWdlcmhsxDJw/s1600/tc_6.png" height="317" width="640" /></a></div>
<br /></div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
Once I have then linked the file my changes are then included on the page</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFe-hbtueAEgJbc5dStbWy8MjoDWh9LgYaZwhQlH9jECmxJI-GnRaPsx4P5UmUcIvWHEnFvV2MPjnm7twMavdvxBdsxLjO_YUR_Ecq70ZwBlP1DeJwddXYr0bKYPWTa9IQAHN9I4RNl_g/s1600/tc_8.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFe-hbtueAEgJbc5dStbWy8MjoDWh9LgYaZwhQlH9jECmxJI-GnRaPsx4P5UmUcIvWHEnFvV2MPjnm7twMavdvxBdsxLjO_YUR_Ecq70ZwBlP1DeJwddXYr0bKYPWTa9IQAHN9I4RNl_g/s1600/tc_8.png" height="492" width="640" /></a></div>
<br /></div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
One thing to be aware of is if you include the CSS in the page template then it will be modified on every page.</div>
Paul Broughtonhttp://www.blogger.com/profile/06669084384271543017noreply@blogger.com0tag:blogger.com,1999:blog-8658815714896796887.post-31682211828515773592012-03-01T09:16:00.000+00:002014-02-08T01:02:46.165+00:00Easy Email Example<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
This ones a very quick post about a regular expression I use all the time to validate email addresses within my applications.</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
A while a go now I had the need to do this and I believe got the regular expression from http://regexlib.com and added into my application.</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
The regular expression which hasn’t failed me as yet is:</div>
<pre style="background-color: #f4f4f4; border: 0px; color: #666666; font-family: 'Courier 10 Pitch', Courier, monospace; font-size: 13px; line-height: 1.5; margin-bottom: 1.625em; outline: 0px; overflow: auto; padding: 0.75em 1.625em; vertical-align: baseline;">^((\s*[a-zA-Z0-9\._%-]+@[a-zA-Z0-9\.-]+\.[a-zA-Z]{2,4}\s*[,;:]){1,100}?)?(\s*[a-zA-Z0-9\._%-]+@[a-zA-Z0-9\.-]+\.[a-zA-Z]{2,4})*$</pre>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
This should let all valid emails through and find all emails which aren’t valid.</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
This is how it should look when implemented. Obviously the item its linked to will very depending on the name of your item.</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; text-align: center; vertical-align: baseline;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhpLHjU1-ea8qu1mYsZklLVccSqNHE9Fc8MRNC6GXXWwr3ubhg6LGYUeMCiaTTqzHBdAnXhRPGYGsxm7iiYOu-gic4ZnOFhswLbM-FHKE1cWDIIYu-f-2gA-9j40jv4nLf1c75V6YgqkAg/s1600/email_validation.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhpLHjU1-ea8qu1mYsZklLVccSqNHE9Fc8MRNC6GXXWwr3ubhg6LGYUeMCiaTTqzHBdAnXhRPGYGsxm7iiYOu-gic4ZnOFhswLbM-FHKE1cWDIIYu-f-2gA-9j40jv4nLf1c75V6YgqkAg/s1600/email_validation.png" /></a></div>
<br /></div>
Paul Broughtonhttp://www.blogger.com/profile/06669084384271543017noreply@blogger.com17tag:blogger.com,1999:blog-8658815714896796887.post-12933058409252732072012-02-25T09:14:00.000+00:002014-02-08T01:06:31.871+00:00Dynamic Action Hide and Show Example<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
Recently I have seen a few people posting on the forum asking how you can hide and show items in APEX 4 and above, because of this I thought I would do a quick example.</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
The example is based on a simple registration form where a user can either choose to complete a private registration or register with company details.</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
I didn’t require the company information from the user if they was registering privately so I wanted to hide these fields.</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
So this is what I did, the first thing was to create my page items:</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjq7CSVA8bfsCmMvaqJzXj-7orOpz1BgQ0Vh9L91KxV1lJbmbxZk0LxQctRYIfzgD1VNaSzReQyEpDgw6tBl8xpUgHQKoRLM59aRDmSyzH1sJHc2fpbt1s-16XyVBDHQE9kyhVSn9EspFE/s1600/hide_show_items.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjq7CSVA8bfsCmMvaqJzXj-7orOpz1BgQ0Vh9L91KxV1lJbmbxZk0LxQctRYIfzgD1VNaSzReQyEpDgw6tBl8xpUgHQKoRLM59aRDmSyzH1sJHc2fpbt1s-16XyVBDHQE9kyhVSn9EspFE/s1600/hide_show_items.png" height="225" width="320" /></a></div>
<br /></div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
Page 102 is where I created my items and is where they will appear. The item that determines if they are hidden or shown is the P102_REGISTRATION_TYPE which is a select list item and has the following static values: STATIC2:Private;PRIVATE,Company;COMPANY</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
The next step is to create a dynamic action that will hide and show the various items.</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; text-align: center; vertical-align: baseline;">
First we have to say when it will fire<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0CU2CQ_Je8wHsi-c9M4RU2Nq8uOWO5J40P2h3iXWMVJW2-3fIQLeLo617LMPGypdif_D0DjN00bifEZ_xi2IAghPr6V3_Z8Ght3rfadTEwk1awgTXk9rgjNBMEyweFk8Cx9uI1EMKPH4/s1600/hide_show_when.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0CU2CQ_Je8wHsi-c9M4RU2Nq8uOWO5J40P2h3iXWMVJW2-3fIQLeLo617LMPGypdif_D0DjN00bifEZ_xi2IAghPr6V3_Z8Ght3rfadTEwk1awgTXk9rgjNBMEyweFk8Cx9uI1EMKPH4/s1600/hide_show_when.png" /></a></div>
<br /></div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
This states that when the P102_REGISTRATION_TYPE item which is the select list is changed and has a value of COMPANY then we want to the true actions to fire if not then the false actions should fire</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; text-align: center; vertical-align: baseline;">
The true and false actions can be seen below<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiVrF_uXKKWhandTi_LUQG0zqNNFz8pCkHaVH8vxDUzDafZ7xoG7Fg8fKCwEtyFxQF5NxV1Ek2YCfZgfoXeLm8dH-LLYEwDHU9jHayxQ_dxYHaI0es2BNZmKJgxsxhTSfTWUqhNyr-vMbM/s1600/hide_show_true.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiVrF_uXKKWhandTi_LUQG0zqNNFz8pCkHaVH8vxDUzDafZ7xoG7Fg8fKCwEtyFxQF5NxV1Ek2YCfZgfoXeLm8dH-LLYEwDHU9jHayxQ_dxYHaI0es2BNZmKJgxsxhTSfTWUqhNyr-vMbM/s1600/hide_show_true.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAPvulPpyqIPyjFRpqpvSp-abUnG8C-8lY-po-Y7XjPRJXPdwARSqY129KvcdT8Uh1_M3gUtf0oFuDSFVS-OFfEhPKCVerBX8PkLykjPJ9VQzDME8vfULXYQNZDlNRoin5i2y4_F0DPs0/s1600/hide_show_false.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAPvulPpyqIPyjFRpqpvSp-abUnG8C-8lY-po-Y7XjPRJXPdwARSqY129KvcdT8Uh1_M3gUtf0oFuDSFVS-OFfEhPKCVerBX8PkLykjPJ9VQzDME8vfULXYQNZDlNRoin5i2y4_F0DPs0/s1600/hide_show_false.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; text-align: center; vertical-align: baseline;">
</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
So in the true actions I wanted to show the company items but hide the address item as I don’t need both a company and personal address.</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
In the false action I needed the address but nothing else</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
I have also checked the box when creating them that states that I want it to fire on page load.</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
This is a very simple way to hide and show items in a page dynamically without the page needing to be reloaded each time the select list is changed.</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
Previously jQuery was used to perform such actions but with the inclusion of dynamic actions in APEX 4 this became very simple using the approach above.</div>
Paul Broughtonhttp://www.blogger.com/profile/06669084384271543017noreply@blogger.com2tag:blogger.com,1999:blog-8658815714896796887.post-13138911699169509972012-02-13T10:34:00.000+00:002014-01-03T10:35:38.249+00:002011 Highlights<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
I wanted to detail some of my highlights from 2011:</div>
<ul style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 30px; list-style: square; margin: 0px 0px 10px 2.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<li style="border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Graduating from Leeds Metropolitan University in July where I graduated in a first class honours degree in computing.</li>
<li style="border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Beginning working full time for <a href="http://apex_evangelists.com/" style="border: 0px; color: #b41423; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: none 0px; padding: 0px; vertical-align: baseline;" target="_blank" title="APEX Evangelists">APEX_Evangelists</a> after finishing university and after having worked part time for them previously.</li>
<li style="border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Speaking at <a href="http://kscope11.com/" style="border: 0px; color: #b41423; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: none 0px; padding: 0px; vertical-align: baseline;" target="_blank" title="Kscope11">Kscope</a> for the second time, it was another fantastic opportunity and experience</li>
<li style="border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Speaking at UKOUG for the first time. Having such a large room and so many people interested in what APEX has to offer really shows the growing interest in the product</li>
<li style="border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><a href="http://apex_evangelists.com/" style="border: 0px; color: #b41423; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: none 0px; padding: 0px; vertical-align: baseline;" target="_blank" title="APEX Evangelists">APEX_Evangelists</a> also launched the APEX Quiz which can be found at<a href="http://apex-challenge.com/" style="border: 0px; color: #b41423; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: none 0px; padding: 0px; vertical-align: baseline;" target="_blank" title="">http://apex-challenge.com</a> as part of the <a href="http://plsqlchallenge.com/" style="border: 0px; color: #b41423; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: none 0px; padding: 0px; vertical-align: baseline;" target="_blank" title="PL/SQL Challenge">PL/SQL Challenge</a> website</li>
</ul>
Paul Broughtonhttp://www.blogger.com/profile/06669084384271543017noreply@blogger.com0tag:blogger.com,1999:blog-8658815714896796887.post-81527172486977024712011-12-13T09:12:00.000+00:002013-09-05T09:12:49.586+01:00UKOUG 2011<br />
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
This was my first year at ukoug and I found it a really enjoyable and worthwhile experience. There were many great presentations. I luckily had the chance to see some of these.</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
Hilary presentation gave an excellent explanation of the latest error handling functionality apex has and how you can create an error table to hold your messages inside.</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
Roel did a great presentation on dynamic actions and how they can be used to control the content on your apex page.</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
John did a presentation that seemed to be very well received on the data dictionary outlining how you can use the apex views to display information about your application in the application such as charts and that tell you the average page load time for a user.</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
I also did an apex presentation that introduced beginners and gave a taster to new users to the tool and some the steps that can be taken to build an apex page. I had the biggest room I had ever presented in which was great<br />
With the largest amount of people I had ever presented to which was also great. Having the opportunity to present at ukoug was a great honour and I want to thank all those that face me that chance.</div>
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 25px; outline: 0px; padding: 0px; vertical-align: baseline;">
One other presentation that has to be mentioned is cary milsaps keynote. If was a fantastic presentation, describing both his career and family life. You could tell the presentation came from his heart and it really was really felt by a lot of people. He talked about the key moments in his life and how without a number of events happening there things wouldn’t have happened.</div>
Paul Broughtonhttp://www.blogger.com/profile/06669084384271543017noreply@blogger.com0tag:blogger.com,1999:blog-8658815714896796887.post-81603428485109801172011-08-09T23:41:00.015+01:002011-08-10T00:09:20.306+01:00<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://www.plsqlchallenge.com/"><img style="float: right; margin: 0pt 0pt 10px 10px; cursor: pointer; width: 237px; height: 46px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgv55QpJ_oOCopfaypwXqTwQu-eZWXlbLR9ib41N8BGsZGp6_jVpuWhQQRCAG4_ShT3J8WpXAqvZieslmNRgg3e04D2ULWqO84EDWqbw46OS6hbQdGmY3QQ_FJDaZdLsHUyilHr6KxfVpM/s200/plsqllogo.png" alt="" id="BLOGGER_PHOTO_ID_5638993127235277954" border="0" /></a><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://apex-evangelists.com/"><img style="float: left; margin: 0pt 10px 10px 0pt; cursor: pointer; width: 166px; height: 54px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiG8LxNvKJ81bXZhMccCD3LPd5OuLgzq97w0qFA7b61R9V6-SHOFFaBSu0SG5YG00EULBo37Dyl7e8ye9rJKNw1sjCWGeVBhOL-fTP10LXNBXIEgtEbx1Y1INl7zvIETe3rigTHoyYMw6I/s200/ae_logo.png" alt="" id="BLOGGER_PHOTO_ID_5638992222926346786" border="0" /></a>
<br />
<br />
<br /> <style> <!-- /* Font Definitions */ @font-face {font-family:"Courier New"; panose-1:2 7 3 9 2 2 5 2 4 4; mso-font-charset:0; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:3 0 0 0 1 0;} @font-face {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0; mso-font-charset:2; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:0 268435456 0 0 -2147483648 0;} @font-face {font-family:"MS 明朝"; panose-1:0 0 0 0 0 0 0 0 0 0; mso-font-charset:128; mso-generic-font-family:roman; mso-font-format:other; mso-font-pitch:fixed; mso-font-signature:1 134676480 16 0 131072 0;} @font-face {font-family:"MS 明朝"; panose-1:0 0 0 0 0 0 0 0 0 0; mso-font-charset:128; mso-generic-font-family:roman; mso-font-format:other; mso-font-pitch:fixed; mso-font-signature:1 134676480 16 0 131072 0;} @font-face {font-family:Cambria; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:3 0 0 0 1 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:Cambria; mso-ascii-font-family:Cambria; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"MS 明朝"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Cambria; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} a:link, span.MsoHyperlink {mso-style-priority:99; color:blue; mso-themecolor:hyperlink; text-decoration:underline; text-underline:single;} a:visited, span.MsoHyperlinkFollowed {mso-style-noshow:yes; mso-style-priority:99; color:purple; mso-themecolor:followedhyperlink; text-decoration:underline; text-underline:single;} p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph {mso-style-priority:34; mso-style-unhide:no; mso-style-qformat:yes; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:36.0pt; margin-bottom:.0001pt; mso-add-space:auto; mso-pagination:widow-orphan; font-size:12.0pt; font-family:Cambria; mso-ascii-font-family:Cambria; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"MS 明朝"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Cambria; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} p.MsoListParagraphCxSpFirst, li.MsoListParagraphCxSpFirst, div.MsoListParagraphCxSpFirst {mso-style-priority:34; mso-style-unhide:no; mso-style-qformat:yes; mso-style-type:export-only; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:36.0pt; margin-bottom:.0001pt; mso-add-space:auto; mso-pagination:widow-orphan; font-size:12.0pt; font-family:Cambria; mso-ascii-font-family:Cambria; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"MS 明朝"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Cambria; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} p.MsoListParagraphCxSpMiddle, li.MsoListParagraphCxSpMiddle, div.MsoListParagraphCxSpMiddle {mso-style-priority:34; mso-style-unhide:no; mso-style-qformat:yes; mso-style-type:export-only; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:36.0pt; margin-bottom:.0001pt; mso-add-space:auto; mso-pagination:widow-orphan; font-size:12.0pt; font-family:Cambria; mso-ascii-font-family:Cambria; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"MS 明朝"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Cambria; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} p.MsoListParagraphCxSpLast, li.MsoListParagraphCxSpLast, div.MsoListParagraphCxSpLast {mso-style-priority:34; mso-style-unhide:no; mso-style-qformat:yes; mso-style-type:export-only; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:36.0pt; margin-bottom:.0001pt; mso-add-space:auto; mso-pagination:widow-orphan; font-size:12.0pt; font-family:Cambria; mso-ascii-font-family:Cambria; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"MS 明朝"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Cambria; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-family:Cambria; mso-ascii-font-family:Cambria; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"MS 明朝"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Cambria; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi; mso-ansi-language:EN-US;} @page WordSection1 {size:595.0pt 842.0pt; margin:72.0pt 90.0pt 72.0pt 90.0pt; mso-header-margin:35.4pt; mso-footer-margin:35.4pt; mso-paper-source:0;} div.WordSection1 {page:WordSection1;} /* List Definitions */ @list l0 {mso-list-id:221912038; mso-list-type:hybrid; mso-list-template-ids:143560166 67698689 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;} @list l0:level1 {mso-level-number-format:bullet; mso-level-text:; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-18.0pt; font-family:Symbol;} @list l0:level2 {mso-level-number-format:bullet; mso-level-text:o; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-18.0pt; font-family:"Courier New";} @list l0:level3 {mso-level-number-format:bullet; mso-level-text:; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-18.0pt; font-family:Wingdings;} @list l0:level4 {mso-level-number-format:bullet; mso-level-text:; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-18.0pt; font-family:Symbol;} @list l0:level5 {mso-level-number-format:bullet; mso-level-text:o; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-18.0pt; font-family:"Courier New";} @list l0:level6 {mso-level-number-format:bullet; mso-level-text:; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-18.0pt; font-family:Wingdings;} @list l0:level7 {mso-level-number-format:bullet; mso-level-text:; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-18.0pt; font-family:Symbol;} @list l0:level8 {mso-level-number-format:bullet; mso-level-text:o; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-18.0pt; font-family:"Courier New";} @list l0:level9 {mso-level-number-format:bullet; mso-level-text:; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-18.0pt; font-family:Wingdings;} ol {margin-bottom:0cm;} ul {margin-bottom:0cm;} --> </style> <p class="MsoNormal"><b style="mso-bidi-font-weight: normal"><span style="mso-tab-count:3"> </span></b></p><div style="text-align: left;"><span style="font-size:130%;"><b style="">
<br /><span style="color: rgb(0, 0, 0);">About the APEX Challenge and future direction</span></b></span></div><p class="MsoNormal" style="text-align:center" align="center"><b style="mso-bidi-font-weight: normal">
<br /></b></p> <p class="MsoNormal" style="text-align:right" align="right"><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTXqAMedq1wdF5GB6pKSAgxLwpVC7R5DZhlwOYY6WiKLiM357opJmhttvFMKeMymB1S3ZJFLb794_9-fHccL-BDaeZZAhP50c4WQmmg1QDxLhXnp0xWDNx9vC8BPSqwcc9xNyfKVKz6bc/s1600/manq.png"><img style="float: right; margin: 0pt 0pt 10px 10px; cursor: pointer; width: 151px; height: 166px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTXqAMedq1wdF5GB6pKSAgxLwpVC7R5DZhlwOYY6WiKLiM357opJmhttvFMKeMymB1S3ZJFLb794_9-fHccL-BDaeZZAhP50c4WQmmg1QDxLhXnp0xWDNx9vC8BPSqwcc9xNyfKVKz6bc/s200/manq.png" alt="" id="BLOGGER_PHOTO_ID_5638993734833884434" border="0" /></a><b style="mso-bidi-font-weight: normal"><span style="mso-spacerun:yes"> </span></b></p> <p class="MsoNormal">The <a href="http://www.plsqlchallenge.com/">APEX Challenge</a> was launched by <a href="http://apex-evangelists.com/">Apex Evangelists</a> on 24<sup>th</sup> June 2011 as part of the <a href="http://www.plsqlchallenge.com/">P</a><a href="http://www.plsqlchallenge.com/">L/SQL Challenge</a> website. The APEX Challenge is a quiz designed to test APEX developers’ skills and knowledge.</p><p class="MsoNormal">
<br /></p> <p class="MsoNormal"> </p> <p class="MsoNormal">The weekly APEX quiz can be played at <a href="http://www.plsqlchallenge.com/">http://www.plsqlchallange.com</a>. All you have to do is register and then you can login and play for free.
<br /></p><p class="MsoNormal">
<br /></p> <p class="MsoNormal" style="text-align:right" align="right"> </p> <p class="MsoNormal">The number of users participating in the APEX Challenge has been growing week on week since it was first launched, with a range of players of all levels now taking part.<span style="mso-spacerun:yes"> </span>The quiz allows you to challenge your colleagues for pride and gain stature within the APEX community through our range of player rankings.</p><p class="MsoNormal">
<br /></p> <p class="MsoNormal"> </p> <p class="MsoNormal">Each month and quarter, prizes will be awarded to the top-ranking players. There is also a quarterly playoff, where participants compete in a ten-question shootout against the other top-ranked players in their category.</p><p class="MsoNormal">
<br /></p> <p class="MsoNormal"> </p> <p class="MsoNormal">I have been part of the development team for the <a href="http://www.plsqlchallenge.com/">PL/SQL Challenge</a> and <a href="http://www.plsqlchallenge.com/">APEX Challenge</a> since they were first introduced, initially whilst working with <a href="http://apex-evangelists.com/">Apex Evangelists</a> on my placement year at university. I graduated in July and became a full-time developer working with <a href="http://jes.blogs.shellprompt.net/">John Scott</a> and <a href="http://dgielis.blogspot.com/">Dimitri Gielis</a> at <a href="http://apex-evangelists.com/">Apex Evangelists</a>.</p><p class="MsoNormal"><span style="mso-spacerun:yes"> </span></p> <p class="MsoNormal"> </p> <p class="MsoNormal">Part of my work is to continue the development of the <a href="http://www.plsqlchallenge.com/">APEX Challenge</a> as well as writing and reviewing some of the quiz questions.</p><p class="MsoNormal">
<br /></p> <p class="MsoNormal"><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiV5EU_9HzW0EQeUNNMoOjRJmjAorN1oxBEbHNq8MkFUcrAvbyQyBBut7oKGHWsOX12KXFED9Kp8rkj3sD6mbkaukP041nmEVXTCOhKBoF0vDe29o685bmdPW9AFF41QWCwatZ2pWclUEk/s1600/quizm.png"><img style="float: left; margin: 0pt 10px 10px 0pt; cursor: pointer; width: 120px; height: 111px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiV5EU_9HzW0EQeUNNMoOjRJmjAorN1oxBEbHNq8MkFUcrAvbyQyBBut7oKGHWsOX12KXFED9Kp8rkj3sD6mbkaukP041nmEVXTCOhKBoF0vDe29o685bmdPW9AFF41QWCwatZ2pWclUEk/s200/quizm.png" alt="" id="BLOGGER_PHOTO_ID_5638994588323903682" border="0" /></a></p> <p class="MsoNormal"><b style=""> What we would</b><b style=""> really like is for the developers who are playing the quiz to submit their own questions; this </b><b style="">will give a more diverse range of questions a</b><b style="">nd help us build a large library.</b></p> <p class="MsoNormal"><span style="mso-tab-count:2"> </span></p> <p class="MsoNormal"><b style="">To submit a qu</b><b style="">estion, log in to your account and click “Submit Quiz” on the orange na</b><b style="">vigation bar at the top of the page.</b></p><p class="MsoNormal">
<br /></p><p class="MsoNormal"><b style="mso-bidi-font-weight:normal">
<br /></b></p> <p class="MsoNormal"> </p> <p class="MsoNormal"> </p> <p class="MsoNormal">Our aim is for the APEX Challenge to be a great learning experience for our quizzers so here are some of the ideas we have for developing the quiz going forward:</p> <p class="MsoNormal">
<br /></p> <p class="MsoNormal"><b style="">Coming Soon</b><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCCTIdo_rukQIYY9Mf3WXRX3isjmJ8ZjRWiSfuyMoJq5j5Uhx3oVRydatU8VGFqbPZI6xqYX_wSVMN1Sucf08wHjrujNi784NqYGnNClQsRQGahYaFT_5mdHMfd31rCvdUruEf0woh2EI/s1600/comingsoon.png"><img style="float: right; margin: 0pt 0pt 10px 10px; cursor: pointer; width: 165px; height: 178px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCCTIdo_rukQIYY9Mf3WXRX3isjmJ8ZjRWiSfuyMoJq5j5Uhx3oVRydatU8VGFqbPZI6xqYX_wSVMN1Sucf08wHjrujNi784NqYGnNClQsRQGahYaFT_5mdHMfd31rCvdUruEf0woh2EI/s200/comingsoon.png" alt="" id="BLOGGER_PHOTO_ID_5638995260061244834" border="0" /></a></p> <p class="MsoListParagraphCxSpFirst" style="text-indent:-18.0pt;mso-list:l0 level1 lfo1"><span style="font-family:Symbol;mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;" ><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman""> </span></span></span>Create an APEX application where players can access the answers to each question</p> <p class="MsoListParagraphCxSpMiddle" style="text-indent:-18.0pt;mso-list:l0 level1 lfo1"><span style="font-family:Symbol;mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;" ><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman""> </span></span></span>Give read-only application builder access to our past question library so players can access the area where quiz question authors test the questions. This will enable players to see the code behind the questions and test the results.</p> <p class="MsoListParagraphCxSpMiddle" style="text-indent:-18.0pt;mso-list:l0 level1 lfo1"><span style="font-family:Symbol;mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;" ><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman""> </span></span></span>Include some questions with screenshots to make the quiz more exciting</p> <p class="MsoListParagraphCxSpLast" style="text-indent: -18pt;"><span style="font-family:Symbol;mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;" ><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman""> </span></span></span>A new APEX welcome page to better promote the APEX quiz</p><p class="MsoListParagraphCxSpLast" style="text-indent:-18.0pt;mso-list:l0 level1 lfo1">
<br /></p> <p class="MsoNormal"><b style="mso-bidi-font-weight:normal"> </b></p> <p class="MsoNormal"><b style="mso-bidi-font-weight:normal">Possible ideas for the future</b></p> <p class="MsoListParagraphCxSpFirst" style="text-indent:-18.0pt;mso-list:l0 level1 lfo1"><span style="font-family:Symbol;mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;" ><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman""> </span></span></span>Switch to a daily quiz but this would require a much larger question library</p> <p class="MsoListParagraphCxSpLast" style="text-indent:-18.0pt;mso-list:l0 level1 lfo1"><span style="font-family:Symbol;mso-fareast-font-family:Symbol;mso-bidi-font-family:Symbol;" ><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman""> </span></span></span>Possibility of a live APEX quiz at an event with a number of APEX developers</p> Paul Broughtonhttp://www.blogger.com/profile/06669084384271543017noreply@blogger.com1tag:blogger.com,1999:blog-8658815714896796887.post-86565086739016845902011-07-19T23:53:00.014+01:002011-07-20T00:13:49.156+01:00ODTUG Kaleidoscope 2011<p class="MsoNormal"><span style=" ;font-family:Arial;font-size:85%;" lang="EN-US" >The reason I'm writing this post is to try to give a brief introduction to what Kaleidoscope is and my experience of it. The reason I have written this a few weeks later is that, since attending the conference, I have returned to begin full-time work after completing my degree so I’ve been rather busy.</span></p> <p class="MsoNormal" style="font-family:arial;"><span style="font-family:Arial;mso-fareast-Times New Roman"font-family:";font-size:10.0pt;" lang="EN-US" > </span><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg29uUtH3af1Zv5jQcc2dGVAOhrJ41VIaRW9y2ZqFidC8QD3zF6w38Kzf9w1qovYXmDhSu_1yDLN1xpVE6gOjV0-SFxvi_yAOPgxTiP0UFVo0XpeFl0esXCZSF3vlYxd7WAsRsuclLOefU/s1600/IMG_0051.JPG"><img style="float: left; margin: 0pt 10px 10px 0pt; cursor: pointer; width: 243px; height: 182px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg29uUtH3af1Zv5jQcc2dGVAOhrJ41VIaRW9y2ZqFidC8QD3zF6w38Kzf9w1qovYXmDhSu_1yDLN1xpVE6gOjV0-SFxvi_yAOPgxTiP0UFVo0XpeFl0esXCZSF3vlYxd7WAsRsuclLOefU/s200/IMG_0051.JPG" alt="" id="BLOGGER_PHOTO_ID_5631192639569978946" border="0" /></a></p><p class="MsoNormal" style="font-family:arial;"><span style="mso-fareast-Times New Roman"font-family:Arial;font-size:85%;" lang="EN-US" > </span></p> <p class="MsoNormal" style="font-family:arial;"><span style="mso-ansi-language:EN-US;font-size:85%;" lang="EN-US" >First of all, what is </span><span style="font-size:85%;">Kaleidoscope?</span><span style=";font-size:85%;" lang="EN-US" ><br /></span></p><p class="MsoNormal" style="font-family:arial;"><span style=";font-size:85%;" lang="EN-US" >Well, it's the annual conference organised by <a href="http://www.odtug.com/"><span style="color:blue;">ODTUG</span></a> (Oracle development tools user group). Although my view is slightly biased as this is the main conference I have attended, I have listened to what other </span><span style=";font-size:85%;" lang="EN-US" >developers have said and many of them, </span><span style=";font-size:85%;" lang="EN-US" >particularly on the APEX track, which I am most interested in as an APEX developer myself, have said that this is their favoured technical conference to attend.<br /></span></p><p class="MsoNormal" style="font-family:arial;"><span style=";font-size:85%;" lang="EN-US" >You can see some of the leading APEX developers blogs and their opinion on the conference at <a href="http://www.apexblogs.info/"><span style="color:blue;">APEX Blogs</span></a></span></p> <p class="MsoNormal" style="font-family:arial;"><span style=";font-size:85%;" lang="EN-US" >The conference provides me with a great learning experience along with the opportunity to pass on my ideas and things I have learnt as a presenter as well as the chance to interact with some of the very best APEX developers in the world.</span></p><p class="MsoNormal" style="font-family:arial;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjq2k60z7SoPpecJvdqlOCGAvZpchKiP5Dz3PrGv8djNqSRd1dVn0haXf2fcDEe673fTtEAA5kh8OAwTcWJkn2pU9yD3kmjrJ6q8DcAy4e8EEBqljJGL9jQ9kX2ddJHP0NK5iwGGW9q2Fo/s1600/odtugsat.jpg"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 200px; height: 150px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjq2k60z7SoPpecJvdqlOCGAvZpchKiP5Dz3PrGv8djNqSRd1dVn0haXf2fcDEe673fTtEAA5kh8OAwTcWJkn2pU9yD3kmjrJ6q8DcAy4e8EEBqljJGL9jQ9kX2ddJHP0NK5iwGGW9q2Fo/s200/odtugsat.jpg" alt="" id="BLOGGER_PHOTO_ID_5631194718729115842" border="0" /></a></p> <p class="MsoNormal" style="font-family:arial;"><span style=";font-size:85%;" lang="EN-US" ><br /></span></p><p class="MsoNormal" style="font-family:arial;"><span style=";font-size:85%;" lang="EN-US" >Saturday Arrival and Registration<br /></span></p><p class="MsoNormal" style="font-family:arial;"><span style=";font-size:85%;" lang="EN-US" ><br /></span></p><p class="MsoNormal" style="font-family:arial;"><br /></p><p class="MsoNormal" style="font-family:arial;"><span style=";font-size:85%;" lang="EN-US" ><br /></span></p><p class="MsoNormal" style="font-family:arial;"><span style=";font-size:85%;" lang="EN-US" ><br /></span></p><p class="MsoNormal" style="font-family:arial;"><span style="mso-ansi-language:EN-US;font-size:85%;" lang="EN-US" >Day 1 - the Sunday </span><span style="font-size:85%;">Symposium</span></p> <p class="MsoNormal" style="font-family:arial;"><span style="font-size:85%;">The main highlight for me was hearing about the new features that will be included in the next version of APEX. The new mobile integration to be included will be phenomenal. The new error handling is going to make life easier and allow my applications to be much more user-friendly. Some other cool things were the fact that you can now fire dynamic actions from a button and one pet hate of all APEX developers for years has been the fact that a region and item button were different, this will be no longer be the case and the item button will match the region button. You can read the <a href="http://www.oracle.com/technetwork/developer-tools/apex/application-express/apex-sod-087560.html"><span style="color:blue;">statement of direction</span></a> and test some of the new features in the early adopter release 2 at <a href="http://tryapexnow.com/"><span style="color:blue;">http://tryapexnow.com</span></a></span></p><p class="MsoNormal" style="font-family:arial;"><span style="font-size:85%;">Day 2 - Monday</span></p> <p class="MsoNormal" style="font-family:arial;"><span style="font-size:85%;">Although I had limited time to watch presentations on the monday, the main highlight had to be my own presentation. Although it was similar to the one I did the previous year, it was great for me to pass on some of my tips and help people learn some things that have helped me in the past. It focussed on tips and tricks that I have learnt and looking at some of the under-used features within APEX that can help developers enhance their applications.</span></p> <p class="MsoNormal" style="font-family:arial;"><span style="font-size:85%;">Day 3 – Tuesday</span></p> <p class="MsoNormal" style="font-family:arial;"><span style="font-size:85%;">There were many excellent presentations. Dan McGhan’s plugin session showed some really cool plugins. Dimitri Gielis’ session demonstrating how we work within Apex Evangelists was very interesting. The highlight had to be Martin D’Souza’s “APEX 4 + HTML 5 = Awesome”. For this presentation, he won the speaker award for the conference overall. Some of the things he showed included the ability to define the type of input for your text field. The web sockets are very cool with the ability to use REST requests from the database to the client’s browser. You can download the slides from Martin’s blog at <a href="http://www.talkapex.com/"><span style="color:blue;">http://www.talkapex.com</span></a></span></p> <p class="MsoNormal" style="font-family:arial;"><span style="font-size:85%;">Day 4 - Wednesday </span></p> <p class="MsoNormal" style="font-family:arial;"><span style="font-size:85%;">Again, there were a number of really cool presentations. John Scott presented a really great presentation on plugins showing off some really interesting ones and discussed how to create the different plugin types you can use. Watching Steven Feuerstein’s presentation</span><span style="font-size:85%;"> on "Best Practices for PL/SQL Development in APEX" was very interesting. Having worked with Steven on the PL/SQL Challenge project, it was interesting to see how he described different aspects of the project and practices used.</span></p><p class="MsoNormal" style="font-family:arial;"><span style="font-size:85%;">I also did my second presentation which was the last session of the day so people were excited about the evening ahead but I still had a good crowd which was nice to see. It focused on building an APEX page and how the different parts of the page link together, as well as simple examples in changing templates. This had a number of demos with different questions asked about various parts of the presentation, which is great as a presenter.</span></p> <p class="MsoNormal" style="font-family:arial;"><span style="font-size:85%;">The main highlight </span><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi8Ubj6qw_LbGvRUr2axn5L2eFk-DdnKqZv1LsMPy2gsL2TNrFBf2EqeUZXnqjKZP99RabAKyx4WNVcML3spE2tlvsY2EmeBEQPlrPTcARmLHY6uFlOZklrl7WzUNVdeLacWUWVhktYH_Y/s1600/Queen_Mary.JPG"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 200px; height: 150px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi8Ubj6qw_LbGvRUr2axn5L2eFk-DdnKqZv1LsMPy2gsL2TNrFBf2EqeUZXnqjKZP99RabAKyx4WNVcML3spE2tlvsY2EmeBEQPlrPTcARmLHY6uFlOZklrl7WzUNVdeLacWUWVhktYH_Y/s200/Queen_Mary.JPG" alt="" id="BLOGGER_PHOTO_ID_5631195773345330114" border="0" /></a><span style="font-size:85%;">of the Wednesday had to be the fantastic night on the Queen Mary. It really was a privilege to be able to visit such a famous ship. Seeing the really funny comedian Don McMillan do two great shows was also very good. This really was an awesome night and I want to thank ODTUG for surpassing any expectations I had. </span></p> <p class="MsoNormal" style="font-family:arial;"><span style="font-size:85%;"><br /></span></p><p class="MsoNormal" style="font-family:arial;"><span style="font-size:85%;"><br /></span></p><p class="MsoNormal" style="font-family:arial;"><br /></p><p class="MsoNormal" style="font-family:arial;"><span style="font-size:85%;">Day 5 – Thursday</span></p> <p class="MsoNormal" style="font-family:arial;"><span style="font-size:85%;">On the final day the awards were people and people were rightly awarded for their contribution to the conference and the class of their presentations.</span></p> <p class="MsoNormal" face="arial"><span style="font-size:85%;">I also attended Shakeeb Rahman’s presentation on “Oracle Application Express: User Interface Design & Themes”, which showed some really cool examples of what you can do with your themes.</span></p> <p class="MsoNormal" style="font-family:arial;"><span style=";font-size:85%;" lang="EN-US" >In closing I want to thank all the staff and volunteers for all their hard work that made the conference such a wonderful experience to attend and present at.</span></p> <p class="MsoNormal" face="arial"><span style="mso-ansi-language:EN-US;font-size:85%;" lang="EN-US" >You can also register for next years conference at <a href="http://kscope12.com/"><span style="color:blue;">http://kscope12.com</span></a></span></p> <p class="MsoNormal" face="arial"><span style="mso-ansi-language:EN-US;font-size:85%;" lang="EN-US" >All I can say is, roll on San Antonio next year and I hope it will be as memorable as this one.</span></p> <p class="MsoNormal" style="font-family:arial;"><span style="font-size:85%;"> </span><br /></p>Paul Broughtonhttp://www.blogger.com/profile/06669084384271543017noreply@blogger.com0tag:blogger.com,1999:blog-8658815714896796887.post-28310340342317502932011-06-01T00:13:00.000+01:002011-06-01T00:35:16.367+01:00First class grade and how I got there!<style> <!-- /* Font Definitions */ @font-face {font-family:"Courier New"; panose-1:2 7 3 9 2 2 5 2 4 4; mso-font-charset:0; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:3 0 0 0 1 0;} @font-face {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0; mso-font-charset:2; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:0 268435456 0 0 -2147483648 0;} @font-face {font-family:"MS 明朝"; mso-font-charset:78; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:1 134676480 16 0 131072 0;} @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:-536870145 1107305727 0 0 415 0;} @font-face {font-family:Cambria; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:-536870145 1073743103 0 0 415 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:Cambria; mso-ascii-font-family:Cambria; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"MS 明朝"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Cambria; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph {mso-style-priority:34; mso-style-unhide:no; mso-style-qformat:yes; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:36.0pt; margin-bottom:.0001pt; mso-add-space:auto; mso-pagination:widow-orphan; font-size:12.0pt; font-family:Cambria; mso-ascii-font-family:Cambria; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"MS 明朝"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Cambria; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} p.MsoListParagraphCxSpFirst, li.MsoListParagraphCxSpFirst, div.MsoListParagraphCxSpFirst {mso-style-priority:34; mso-style-unhide:no; mso-style-qformat:yes; mso-style-type:export-only; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:36.0pt; margin-bottom:.0001pt; mso-add-space:auto; mso-pagination:widow-orphan; font-size:12.0pt; font-family:Cambria; mso-ascii-font-family:Cambria; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"MS 明朝"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Cambria; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} p.MsoListParagraphCxSpMiddle, li.MsoListParagraphCxSpMiddle, div.MsoListParagraphCxSpMiddle {mso-style-priority:34; mso-style-unhide:no; mso-style-qformat:yes; mso-style-type:export-only; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:36.0pt; margin-bottom:.0001pt; mso-add-space:auto; mso-pagination:widow-orphan; font-size:12.0pt; font-family:Cambria; mso-ascii-font-family:Cambria; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"MS 明朝"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Cambria; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} p.MsoListParagraphCxSpLast, li.MsoListParagraphCxSpLast, div.MsoListParagraphCxSpLast {mso-style-priority:34; mso-style-unhide:no; mso-style-qformat:yes; mso-style-type:export-only; margin-top:0cm; margin-right:0cm; margin-bottom:0cm; margin-left:36.0pt; margin-bottom:.0001pt; mso-add-space:auto; mso-pagination:widow-orphan; font-size:12.0pt; font-family:Cambria; mso-ascii-font-family:Cambria; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"MS 明朝"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Cambria; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-family:Cambria; mso-ascii-font-family:Cambria; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"MS 明朝"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Cambria; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi; mso-ansi-language:EN-US;} @page WordSection1 {size:595.0pt 842.0pt; margin:72.0pt 90.0pt 72.0pt 90.0pt; mso-header-margin:35.4pt; mso-footer-margin:35.4pt; mso-paper-source:0;} div.WordSection1 {page:WordSection1;} /* List Definitions */ @list l0 {mso-list-id:386802262; mso-list-type:hybrid; mso-list-template-ids:-201400274 67698689 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;} @list l0:level1 {mso-level-number-format:bullet; mso-level-text:; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-18.0pt; font-family:Symbol;} @list l0:level2 {mso-level-number-format:bullet; mso-level-text:o; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-18.0pt; font-family:"Courier New";} @list l0:level3 {mso-level-number-format:bullet; mso-level-text:; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-18.0pt; font-family:Wingdings;} @list l0:level4 {mso-level-number-format:bullet; mso-level-text:; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-18.0pt; font-family:Symbol;} @list l0:level5 {mso-level-number-format:bullet; mso-level-text:o; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-18.0pt; font-family:"Courier New";} @list l0:level6 {mso-level-number-format:bullet; mso-level-text:; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-18.0pt; font-family:Wingdings;} @list l0:level7 {mso-level-number-format:bullet; mso-level-text:; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-18.0pt; font-family:Symbol;} @list l0:level8 {mso-level-number-format:bullet; mso-level-text:o; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-18.0pt; font-family:"Courier New";} @list l0:level9 {mso-level-number-format:bullet; mso-level-text:; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-18.0pt; font-family:Wingdings;} @list l1 {mso-list-id:1526554740; mso-list-type:hybrid; mso-list-template-ids:812535046 67698689 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;} @list l1:level1 {mso-level-number-format:bullet; mso-level-text:; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-18.0pt; font-family:Symbol;} @list l1:level2 {mso-level-number-format:bullet; mso-level-text:o; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-18.0pt; font-family:"Courier New";} @list l1:level3 {mso-level-number-format:bullet; mso-level-text:; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-18.0pt; font-family:Wingdings;} @list l1:level4 {mso-level-number-format:bullet; mso-level-text:; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-18.0pt; font-family:Symbol;} @list l1:level5 {mso-level-number-format:bullet; mso-level-text:o; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-18.0pt; font-family:"Courier New";} @list l1:level6 {mso-level-number-format:bullet; mso-level-text:; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-18.0pt; font-family:Wingdings;} @list l1:level7 {mso-level-number-format:bullet; mso-level-text:; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-18.0pt; font-family:Symbol;} @list l1:level8 {mso-level-number-format:bullet; mso-level-text:o; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-18.0pt; font-family:"Courier New";} @list l1:level9 {mso-level-number-format:bullet; mso-level-text:; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-18.0pt; font-family:Wingdings;} ol {margin-bottom:0cm;} ul {margin-bottom:0cm;} --> </style> <p class="MsoNormal"><span style="font-size:85%;">Well, I want to pass on some of my thoughts on how I achieved a first class degree. <span style="mso-spacerun:yes"> </span>Over my 2<sup>nd</sup> and 3<sup>rd</sup> years I reached a 75% average, the threshold for achieving a first class being 70%. I achieved this through hard work, motivation, desire and the willingness to succeed.</span></p> <p class="MsoNormal"><span style="font-size:85%;"> </span></p> <p class="MsoNormal"><span style="font-size:85%;"><span style="mso-spacerun:yes"> </span>I have listed a few dos and don’ts below that may help other students to succeed:</span></p> <p class="MsoNormal"><span style="font-size:85%;"> </span></p> <p class="MsoNormal"><span style="font-size:85%;"><b style="mso-bidi-font-weight:normal">DO</b></span></p> <p class="MsoListParagraphCxSpFirst" style="text-indent:-18.0pt;mso-list:l1 level1 lfo1"><span style="font-size:85%;"><span style="font-family:Symbol;mso-fareast-font-family:Symbol;mso-bidi-font-family: Symbol"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman""> </span></span></span>Attend your lectures – you will always learn something useful</span></p> <p class="MsoListParagraphCxSpMiddle" style="text-indent:-18.0pt;mso-list:l1 level1 lfo1"><span style="font-size:85%;"><span style="font-family:Symbol;mso-fareast-font-family:Symbol;mso-bidi-font-family: Symbol"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman""> </span></span></span>Read and re-read your module specifications – it’s very important to actually make sure you’re doing what you’re meant to be and you have not gone off course and done something different</span></p> <p class="MsoListParagraphCxSpMiddle" style="text-indent:-18.0pt;mso-list:l1 level1 lfo1"><span style="font-size:85%;"><span style="font-family:Symbol;mso-fareast-font-family:Symbol;mso-bidi-font-family: Symbol"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman""> </span></span></span>Speak to other students - don’t copy but share ideas, it will definitely help you</span></p> <p class="MsoListParagraphCxSpMiddle" style="text-indent:-18.0pt;mso-list:l1 level1 lfo1"><span style="font-size:85%;"><span style="font-family:Symbol;mso-fareast-font-family:Symbol;mso-bidi-font-family: Symbol"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman""> </span></span></span>Use your lecturers – fortunately my lecturers were very approachable and I could see them in person or email them to ask questions.<span style="mso-spacerun:yes"> </span>You are paying for them, make sure you use them</span></p> <p class="MsoListParagraphCxSpLast" style="text-indent:-18.0pt;mso-list:l1 level1 lfo1"><span style="font-size:85%;"><span style="font-family:Symbol;mso-fareast-font-family:Symbol;mso-bidi-font-family: Symbol"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman""> </span></span></span>Put the hours in and plan your time</span></p> <p class="MsoNormal"><span style="font-size:85%;"> </span></p> <p class="MsoNormal"><span style="font-size:85%;"><b style="mso-bidi-font-weight:normal">DON’T</b></span></p> <p class="MsoListParagraphCxSpFirst" style="text-indent:-18.0pt;mso-list:l0 level1 lfo2"><span style="font-size:85%;"><span style="font-family:Symbol;mso-fareast-font-family:Symbol;mso-bidi-font-family: Symbol"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman""> </span></span></span>Leave things until the last minute - they will always take longer than you think</span></p> <p class="MsoListParagraphCxSpMiddle" style="text-indent:-18.0pt;mso-list:l0 level1 lfo2"><span style="font-size:85%;"><span style="font-family:Symbol;mso-fareast-font-family:Symbol;mso-bidi-font-family: Symbol"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman""> </span></span></span>Work all day and all night – the odd all-nighter is ok but your brain stops functioning after 36 hours (trust me I know!)</span></p> <p class="MsoListParagraphCxSpMiddle" style="text-indent:-18.0pt;mso-list:l0 level1 lfo2"><span style="font-size:85%;"><span style="font-family:Symbol;mso-fareast-font-family:Symbol;mso-bidi-font-family: Symbol"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman""> </span></span></span>Forget to back up your work</span></p> <p class="MsoListParagraphCxSpMiddle" style="text-indent:-18.0pt;mso-list:l0 level1 lfo2"><span style="font-size:85%;"><span style="font-family:Symbol;mso-fareast-font-family:Symbol;mso-bidi-font-family: Symbol"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman""> </span></span></span>Leave applying for a placement until the last minute</span></p> <p class="MsoListParagraphCxSpLast" style="text-indent:-18.0pt;mso-list:l0 level1 lfo2"><span style="font-size:85%;"><span style="font-family:Symbol;mso-fareast-font-family:Symbol;mso-bidi-font-family: Symbol"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman""> </span></span></span>Forget to submit your work</span></p> <p class="MsoNormal"><span style="font-size:85%;"> </span></p> <p class="MsoNormal"><span style="font-size:85%;">Hopefully this will offer some suggestions to help you achieve your goals.</span></p>Paul Broughtonhttp://www.blogger.com/profile/06669084384271543017noreply@blogger.com0tag:blogger.com,1999:blog-8658815714896796887.post-27040021453793428832011-05-31T23:59:00.002+01:002011-06-01T00:05:05.321+01:00Final year at university<style> <!-- /* Font Definitions */ @font-face {font-family:"MS 明朝"; mso-font-charset:78; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:1 134676480 16 0 131072 0;} @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:-536870145 1107305727 0 0 415 0;} @font-face {font-family:Cambria; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:-536870145 1073743103 0 0 415 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:Cambria; mso-ascii-font-family:Cambria; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"MS 明朝"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Cambria; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-family:Cambria; mso-ascii-font-family:Cambria; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"MS 明朝"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Cambria; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi; mso-ansi-language:EN-US;} @page WordSection1 {size:612.0pt 792.0pt; margin:72.0pt 90.0pt 72.0pt 90.0pt; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.WordSection1 {page:WordSection1;} --> </style> <p class="MsoNormal"><span style="font-size:85%;">I thought I would share some of the aspects of my final year and why I have been so busy.</span><span style="mso-spacerun:yes;font-size:85%;" > </span><span style="font-size:85%;">The final year was by far the most challenging for me.</span><span style="mso-spacerun:yes;font-size:85%;" > </span><span style="font-size:85%;">Throughout the year I covered 8 modules on a range of subjects.</span><span style="mso-spacerun:yes;font-size:85%;" > </span><span style="font-size:85%;">I did some C# programming and some PHP website development.</span></p><p class="MsoNormal"><span style="font-size:85%;"><br /></span></p> <p class="MsoNormal"> </p> <p class="MsoNormal"><span style="font-size:85%;">The most exciting parts for me though were the advanced database modules and the final year project.</span><span style="mso-spacerun:yes;font-size:85%;" > </span><span style="font-size:85%;">In the first advanced database module we focussed on data warehousing and star schemas.</span><span style="mso-spacerun:yes;font-size:85%;" > </span><span style="font-size:85%;">This was something I hadn’t done before so I found it very interesting.</span><span style="mso-spacerun:yes;font-size:85%;" > </span><span style="font-size:85%;">I would post the assignment and solution but university may use the same case study next year so I don’t want to give away the answers!</span></p><p class="MsoNormal"><span style="font-size:85%;"><br /></span></p> <p class="MsoNormal"> </p> <p class="MsoNormal"><span style="font-size:85%;">In the second advanced database module, we looked at PL/SQL procedures and functions.</span><span style="mso-spacerun:yes;font-size:85%;" > </span><span style="font-size:85%;">I also worked with PL/SQL for the majority of my placement year so I found a fairly complex function and procedure to impress my tutors.</span></p><p class="MsoNormal"><span style="font-size:85%;"><br /></span></p> <p class="MsoNormal"> </p> <p class="MsoNormal"><span style="font-size:85%;">The rest of my modules were based on a final year project.</span><span style="mso-spacerun:yes;font-size:85%;" > </span><span style="font-size:85%;">The idea behind this was to follow the waterfall project lifecycle to create a product following each stage.</span><span style="mso-spacerun:yes;font-size:85%;" > </span><span style="font-size:85%;">I completed this project as a member of a two-person team rather than on my own, which meant significantly more progress could be made.</span></p><p class="MsoNormal"><span style="font-size:85%;"><br /></span></p> <p class="MsoNormal"> </p> <p class="MsoNormal"><span style="font-size:85%;">As part of the modules I also had to write three 3500 word essays.</span><span style="mso-spacerun:yes;font-size:85%;" > </span><span style="font-size:85%;">The first outlined the scope for the project and a range of project planning documents.</span><span style="mso-spacerun:yes;font-size:85%;" > </span><span style="font-size:85%;">The second report was a research report that looked at a range of journals, books and other websites to give us ideas for our product.</span><span style="mso-spacerun:yes;font-size:85%;" > </span><span style="font-size:85%;">The final report was an evaluation of the project as a whole and considered aspects that went right as well as what went wrong and how this could be improved in the future.</span></p><p class="MsoNormal"><span style="font-size:85%;"><br /></span></p> <p class="MsoNormal"> </p> <p class="MsoNormal"><span style="font-size:85%;">I thought it would be good to give an overview of what I did in my final year so any potential future computing students as well as employers within the industry could get an idea of what was involved.</span></p> <p class="MsoNormal"> </p> <p class="MsoNormal"> </p>Paul Broughtonhttp://www.blogger.com/profile/06669084384271543017noreply@blogger.com1tag:blogger.com,1999:blog-8658815714896796887.post-47647186108700819702011-05-31T15:37:00.004+01:002011-06-01T00:04:37.009+01:00Blog Neglected<style> <!-- /* Font Definitions */ @font-face {font-family:"MS 明朝"; panose-1:0 0 0 0 0 0 0 0 0 0; mso-font-charset:128; mso-generic-font-family:roman; mso-font-format:other; mso-font-pitch:fixed; mso-font-signature:1 134676480 16 0 131072 0;} @font-face {font-family:"MS 明朝"; panose-1:0 0 0 0 0 0 0 0 0 0; mso-font-charset:128; mso-generic-font-family:roman; mso-font-format:other; mso-font-pitch:fixed; mso-font-signature:1 134676480 16 0 131072 0;} @font-face {font-family:Cambria; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:3 0 0 0 1 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:Cambria; mso-ascii-font-family:Cambria; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"MS 明朝"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Cambria; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-family:Cambria; mso-ascii-font-family:Cambria; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"MS 明朝"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Cambria; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi; mso-ansi-language:EN-US;} @page WordSection1 {size:612.0pt 792.0pt; margin:72.0pt 90.0pt 72.0pt 90.0pt; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.WordSection1 {page:WordSection1;} --> </style> <p class="MsoNormal"><span style="font-size:85%;">Well unfortunately due to a very busy year at university and work along side of that my blog got neglected.</span><span style="mso-spacerun:yes;font-size:85%;" > </span><span style="font-size:85%;">You can however expect this to change for the foreseeable future, I have revamped my blog and intend to be blogging much more.</span><span style="mso-spacerun:yes;font-size:85%;" > </span><span style="font-size:85%;">I want to pass on some of the new things I’m learning as my career further progresses.</span><span style="mso-spacerun:yes;font-size:85%;" > </span><span style="font-size:85%;">You can also find me at ODTUG Presenting two APEX presentations in June.</span><span style="mso-spacerun:yes;font-size:85%;" > </span><span style="font-size:85%;">So come back soon to see my newest blogs!</span></p>Paul Broughtonhttp://www.blogger.com/profile/06669084384271543017noreply@blogger.com1tag:blogger.com,1999:blog-8658815714896796887.post-80086078740631411312010-07-22T00:56:00.002+01:002010-07-22T00:57:23.411+01:00ODTUG - 2 weeks onI've been back in the UK a couple of weeks now. I decided to leave it a little while before writing this post as I figured it would give me time to fully comprehend the <a href="http://www.odtugkaleidoscope.com/">ODTUG</a> conference and what I had done as well as where I had been.<br /><br /><a href="http://www.odtugkaleidoscope.com/">ODTUG Kaleidoscope</a> was the first conference on this scale that I had been to anywhere in the world. I feel one of the luckiest people alive as I got to go while doing a work placement with <a href="http://sumneva.com/">Sumneva</a> as an attendee and even got to present which was truly amazing, (a blog post on presenting will follow in the next week so I won't talk about that now).<br /><br />I had never even been to the US before so the conference was a real eye opener for me. I'm not sure what I was expecting before I went but I got that plus a whole lot more. I was pleasantly surprised at how friendly everyone was, I was expecting everyone to be nice to each other but it really showed me how the sense of community spirit thrives within the APEX community.<br /><br />The people I met at <a href="http://www.odtugkaleidoscope.com/">Kaleidoscope</a> truly made the conference fantastic for me. Don't get me wrong the presentations were great and I learned a lot but it was people I met and the friendship I gained that made the conference so wonderful. Unfortunately there are far to many people to list that I met and made friends with, but to all those I met and you know who you are. I just want to say thank you for making it such a great experience and I hope to see you all again soon.<br /><br />Ok now for some of the great presentations I saw.<br /><br />I was at the conference from the Sunday so I was up early and ready to go for the...<br /><br /><strong>Sunday Symposium - APEX A to Z </strong><br />This was really cool seeing and application been built from start to finish. This was definitely a valuable session for me and showed me how different people present in different ways. I'm sure for anyone who hadn't used APEX before this would have been a true eyeopener on how easy APEX is to use and how easy it is to build a new application. This was a great first day and gave me an idea of what to expect for the rest of the week.<strong><br /><br />Monday</strong><br />I started off watching by watching the keynote speech. We had some fun at the start where the audience participated sending texts and things and ended the first part of the session by announcing the the location of <a href="http://www.odtugkaleidoscope.com/">ODTUG Kaleidoscope </a>which is been held in Longbeach California. The second part of the keynote was intriguing, it was someone called Lee Rainie who gave the keynote. He had some very interesting ideas especially on future trends of the internet.<br /><br />The second session I saw was Anton Nielsen - How to Hack and APEX Application. This was a really cool session, I did know quite a few different ways that an APEX page could be hacked such as manipulating the URL and using firebug to change values but I did learn a few new tricks.<br /><br />I then had a few hours off and practiced for my presentation at 2.30pm. This was very scary as it got closer and closer but a new blog post will follow to describe in more detail.<br /><strong><br />Tuesday</strong><br />I started off the day in Johns Scott's session 'APEX Features We Should All be Using but Probably Aren't' - I work with John every day but thought I would watch his session and I can say I picked up some tips, I don't user master applications as much as I should so something I certainly have to bear in mind.<br /><br />The next thing I went to was Patrick Wolf's hands on Lab - 'Oracle Application Express Dynamic Actions'. This was really good fun, due to the amount of work I had been doing running up to <a href="http://www.odtugkaleidoscope.com/">ODTUG</a> I had very little time to really get to grips with APEX 4 and all its new features. This was great opportunity to have a look at the dynamic actions. We were given a worksheet and a laptop so I gradually worked through the sheet. It wasn't super complex but gave me a better idea of how the dynamic actions worked. I can say that the hands on labs are definitely worth while.<br /><br />The final presentation of the day for me was Dimitri Gielis - 'Mastering an APEX Page'. It was an interesting session he covered a number of APEX features but the most interesting for me was learning how the debug worked in APEX 4. It's no longer the same, it doesn't appear on the page any more as it did before. You get a popup window to use debug now. It's a pretty cool enhancement from the previous debug.<br /><strong><br />Wednesday<br /></strong>I decided to watch Dan McGhan - 'JavaScipt in APEX - A Lesson for the PL/SQL Developer' and I picked up a few tips. Dan was an excellent presenter and using a variety of slides he gradually went through using JavaScript and APEX, mainly using jQuery and showed people how easy it is to combine APEX with jQuery to do some really cool things. It was definitely one worth watching and that I would recommend to anyone who wants to use JavaScript with APEX.<br /><br />My next presentation today was Dimitri Gielis - 'My First Months With APEX 4.0'. I had seen Dimitri present earlier in the week and he didn't disappoint this time either. What he did live was export an APEX 3.2 application and rebuild it in 4. This was a really cool presentation and something that he accomplished with some style. Upgrading to APEX isn't always a smooth transition at the best of times so doing it in front of people was definitely a challenge. Watching him do this was definitely inspirational and I could see the room really appreciated what he did.<br /><br />Well that's it my adventure was over and it was time to head back home after a day's work and a days sightseeing. It certainly was an unbelievable experience that I will be eternally grateful for getting the chance to do. I enjoyed every minute of it and I just hope one day I will get to go again to see all the great people I met and enjoy the week as I have this year.<br /><br />This blogpost has taken me a while to write as I wanted to try and get a decent amount of content in it so I hope it has given you an idea of my experience of <a href="http://www.odtugkaleidoscope.com/">ODTUG Kaleidoscope 2010</a>.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-8658815714896796887.post-82541480990614073032010-04-15T20:17:00.011+01:002010-04-15T22:11:35.099+01:00Apex 4 - Tree vs Component View<div style="text-align: left;"><span style="font-weight: bold;font-family:arial;font-size:130%;" >Introduction</span><br /></div><span style="font-family:arial;">The first time I logged into <a href="http://tryapexnow.com/">Apex 4</a> and clicked onto a page of my application to see all my page items in the tree view which I had never seen before live was definitely an experience with such a major change. Having heard of the new tree view but not read any documentation it was very different and took a few minutes to get my head round. I have outlined some of the pro’s and con’s of each view below.</span><br /><br /><span style="font-weight: bold;font-family:arial;font-size:130%;" >Tree View</span><span style="font-family:arial;"><br />Although this is very different once I began to play around with it a little you soon realize it is actually very versatile. The layout once you have worked it out is definitely better. You can customize which elements of the page you want to see at any one time. You can access your report columns directly from the tree, it saves you time digging into the report and then selecting that column. This makes editing the columns much quicker and also easy to see columns in multiple reports at one time.</span><br /><br /><span style="font-family:arial;">Another great addition is the ability to right click on anything within your page and get an action menu. From this action menu you have the ability to very easily create computations and validations on page items without having to dig down into multiple menus. The right click is a vast improvement saving you time in a number of areas.</span><br /><br /><span style="font-family:arial;">So the bad things about it. It does take you a while to work out where all the page regions are now located. You have to open regions up with plus icon each time, you do have the expand all option but this can make your page rendering section quite long.</span><br /><br /><div style="text-align: center; font-family: arial;"><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0QeTPwBuMHoqbSHoiK_-02K6uHhZTnHCQ-B7L74hf5i5mqnziUHbGFp9Y8fsTQ9f583D9HyKHEaYG8o0aLIh30w28yeN18Ss883mqzeYlfPbb3kXJ96yCTZnjwlQxb3QRFPONBrOx9fCL/s1600/apextreeview.jpg"><img style="cursor: pointer; width: 626px; height: 209px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0QeTPwBuMHoqbSHoiK_-02K6uHhZTnHCQ-B7L74hf5i5mqnziUHbGFp9Y8fsTQ9f583D9HyKHEaYG8o0aLIh30w28yeN18Ss883mqzeYlfPbb3kXJ96yCTZnjwlQxb3QRFPONBrOx9fCL/s320/apextreeview.jpg" alt="" id="BLOGGER_PHOTO_ID_5460467557352777906" border="0" /></a></div><span style="font-weight: bold;font-family:arial;" ><br /><span style="font-size:130%;">Component View</span></span><span style="font-family:arial;"><br />This view is very simple to understand, I think previously using Apex is a big part of the reason however. It’s very simple to edit any items on the page with a single click. All the items on the page are under their individual regions which makes easy viewing. Each region has a plus icon next to its header which allows you to quickly create items to go within that region.</span><br /><br /><span style="font-family:arial;">So the cons, you nearly always have to scroll to see the things at the bottom of the page. To edit your report column you first of all have to click on the link for that report and then click the edit Icon to make changes. To copy items also takes 2 clicks to first of all select copy and then choose your item.</span><br /><br /><div style="text-align: center; font-family: arial;"><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhcCsnuByWMNehNsdxRmT7D1NkaBape9aZ8sHys3V4KCnAEFkPA0ljeQ9yA-HJOiWvibnrRD4BXQKYwjJJPfUSLtYVVrm92Ac-b67T_a7rGJ5EjgNMK9_B3BPTQqFwErXj2XZOdmx_d1kLB/s1600/apexcomp.jpg"><img style="cursor: pointer; width: 637px; height: 322px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhcCsnuByWMNehNsdxRmT7D1NkaBape9aZ8sHys3V4KCnAEFkPA0ljeQ9yA-HJOiWvibnrRD4BXQKYwjJJPfUSLtYVVrm92Ac-b67T_a7rGJ5EjgNMK9_B3BPTQqFwErXj2XZOdmx_d1kLB/s320/apexcomp.jpg" alt="" id="BLOGGER_PHOTO_ID_5460449081538318626" border="0" /></a><br /></div><br /><span style="font-weight: bold;font-family:arial;font-size:130%;" >Conclusion</span><span style="font-family:arial;"><br />Initially I did find the tree view a little more daunting having used Apex in the past and it looking so different. As I’m someone who enjoys playing around with new things I looked on it more as a challenge than a problem as I imagine will most developers. For a new user it won’t make any difference at all as they won’t have used either so will have to learn both views.</span><br /><br /><span style="font-family:arial;">I will definitely be using the new tree view as it saves you vast amounts of time with the new right click menu. Your not constantly scrolling from top to the bottom of the page. The layout allows a lot more customization allowing you to view only certain elements of the page.</span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-8658815714896796887.post-9181453667722784792010-04-07T23:04:00.007+01:002010-04-08T00:36:34.945+01:00My first blog postWell where do I start. It's been a hectic last 8 months to say the least. I completed my 2nd year in university last June and left to complete a work placement year before I return this September to finish my degree.<br /><br />I started working with <a href="http://jes.blogs.shellprompt.net/">John Scott</a> and <a href="http://dgielis.blogspot.com/">Dimitri Gielis</a> from the <a href="http://www.apex-evangelists.com/">Apex Evangelists</a> in July 2009. I thought I had a reasonable understanding of Apex and SQL before I started. How wrong was I, I hadn't even touched the surface. Since then I have been working on a number of projects learning a variety of new skills and how to make Apex work for me.<br /><br />I have learned far to much to write in this post but I will try and blog some of it over the next few months.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1U3Kr6CJLmP7zl7V_GpF-VJouDXpyKhCmzkwrOkswV03IPkN-Z-gfO-Z3xc3pUwNoni1gq2kHDyepdfUzC1SSfvcFUB7n2Vgbp9l2VEcgY-vY3bsNlJLDYamuendEbuKxyypyv7d0tyKd/s1600/qdb_logo.jpg"><img style="float: left; margin: 0pt 10px 10px 0pt; cursor: pointer; width: 226px; height: 166px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1U3Kr6CJLmP7zl7V_GpF-VJouDXpyKhCmzkwrOkswV03IPkN-Z-gfO-Z3xc3pUwNoni1gq2kHDyepdfUzC1SSfvcFUB7n2Vgbp9l2VEcgY-vY3bsNlJLDYamuendEbuKxyypyv7d0tyKd/s320/qdb_logo.jpg" alt="" id="BLOGGER_PHOTO_ID_5457534913357082034" border="0" /></a>One of the most high profile projects I have been working on is the <a href="http://www.plsqlchallenge.com/">PL/SQL Challenge</a>.<br /><br />This was an idea thought up by <a href="http://www.stevenfeuerstein.com/">Steven Feuerstein</a> in association with <a href="http://www.ellebaek-consulting.com/">Finn Ellebaek Nielsen</a>. It is set to launch well in a few hours, it has been an ongoing and challenging project putting together the application and all the different elements that were associated with it. It is now ready to go and we are looking forward to the launch.<br /><br /><br />I advise everyone who knows even the basics of PL/SQL to have a go, test your knowledge and win cash prizes. It's well worth a try.<br /><br />I'm not going to talk any more now.<br /><br />I hope to post more in the near future.<br /><br />You can also catch me presenting at <a href="http://www.odtugkaleidoscope.com/">ODTUG</a> this year.Unknownnoreply@blogger.com0