Tips & Tricks | Inside Oracle APEX by Patrick Wolf

Resetting pagination of a Master-Detail Report in Oracle APEX

24. September 2007

After the “Oracle APEX round table talk with Mike Hichwa” I was asked an interesting question by another attending developer. Is there a possibility to reset only the pagination of the detail report, when you have a master- and a detail report on the same page in an Oracle Application Express (APEX) application?

Checking if a Page Item has been rendered or not

8. September 2007

Comments Off

Did you ever have had the requirement that a validation should only fire if the page item has been rendered (eg. if you have defined a condition or authorization)? As long as you set the “Associated Item” property in the validation to the page item you want to check, you are fine. Oracle Application Express [...]

Add colors or images to your select list

19. August 2007

7 Comments

Some time ago I was asked if it’s possible to set the background color of the entries of a select list. Sure why not! I thought I had already answered the question before, so I searched on the OTN forum but didn’t find my posting. No problem, shouldn’t be too hard to find the solution [...]

Using tooltips in Oracle APEX applications

15. August 2007

8 Comments

That’s maybe an old tip and probably everybody already knows it, but because I just answered that question on the OraFAQ forum, I wanted to share it with you in case you didn’t know. Maybe you have already noticed that in the Oracle APEX Builder at some pages a tooltip is used. For example for [...]

Enable "Add picture" for the HTML editor

6. July 2007

8 Comments

The new HTML editor widget which was introduced in Oracle APEX 3.0 is a big enhancement compared to the old one in APEX 2.x and it works with all browsers. The HTML editor is based on the open source editor FCKeditor. A few features have been removed, because they would require some server side code. [...]

How to run Javascript code for a PPR Report?

3. July 2007

10 Comments

Maybe you have already used a PPR (Partial Page Rendering) report, by setting the “Report Template” property to “template: 7. Standard (PPR)”. That’s quite a nice feature, because not the hole page is rendered when you are paginating through the report, just the report itself is refreshed with an AJAX call. But what happens if [...]

Some interesting postings

28. June 2007

1 Comment

In the past few weeks there have been a few interesting APEX related postings I want to share with you. Anthony Rayner started his own APEX blog and did an interesting posting about AJAX retrieval using Javascript Object Notation (JSON). Something I also want to integrate into one of the next versions of my ApexLib [...]

Highlight current Tree Node

7. June 2007

11 Comments

During the DOAG SIG workshop I was asked how to create a treeview in Oracle APEX where the current selected tree node is highlighted. After a quick thought about the problem, it turned out that there is a quite simple solution for it if you combine the treeview query with some HTML code.

Opening URL in a new window

9. May 2007

20 Comments

You want to create a button or a navigation list entry where you want to open an URL in a new browser window? With plain HTML you would normally just write <a href="http://url/" target="_blank"> but how to specify the target=”_blank” in Oracle APEX, where you just have the property “URL Target” which just allows you [...]

Sending a SMS to a mobile phone

4. May 2007

10 Comments

Today I read an article on Grant Rolands blog about sending a SMS from Oracle Forms through a Web-Service. I thought it would be nice to have the same in APEX and PL/SQL, too. For example if you have a system failure or get a new order in your shop…

Archive | Tips & Tricks RSS feed for this section