APEX

APEX

Help text as a modal dialog

TweetShareSharePin0 SharesTo continue on the theme of help text in APEX, let’s take a look at showing it in a modal popup dialog in this post and then finish off the subject in next post with customizing how help can be shown. For completeness I’ll include a short section towards the end about how it works in non modal too. In the last post I show how to show help text inline on a page and on the one before […]

APEX

Help text in APEX in-line with page

TweetShareSharePin0 SharesSetting up help text in APEX is not hard but I often see it not done at all or implemented using regions with static content and then toggled on or off. That is unfortunate when there is declarative support for providing help texts. In the last post I show how to set up a specific page to be the landing page for showing help text for any page in the application. In this post I’ll show how to get […]

APEX

Too much chrome

TweetShareSharePin0 SharesYou know how it is, when you have that feeling. You are on top of your game. You have a few quick brush strokes to add to a system to make it more dynamic. You have all the small needed changes in your head and you know it is just gonna work. You sit down for some quality time with your computer and with the application builder. It’s gonna be fun and you will get to bask in the […]

SQL, PL/SQL, Oracle, APEX

The power of using records in APEX III

TweetShareSharePin0 SharesIn this post I’ll finish up the CRUD implementation using records, procedures and views. This series of blog posts started with this post which was followed by this. At this point we have a working report that links to a form. The report is based on a view and the form is based on a procedure. At this point the form is only loading the record in using a procedure that uses a record in its signature. In this post […]

APEX

The power of using records in APEX II

TweetShareSharePin0 SharesIn this post I follow up on the post where I started talking about records in APEX. In this post I’ll show how to add a page in front of the form created in that post. Thus this post will show a report and let you navigate to the form where the selected record is displayed. Pretty basic stuff, but it allows better testing of the form and it sets the stage for showing how to make the form […]

PL/SQL, APEX

The power of using records in APEX

TweetShareSharePin0 SharesDo you use forms based on procedures in APEX? If not, why not?Do you use records in the procedures you use for forms in APEX? If not, why not? I like procedures and records and with APEX I like them even more. Why you say? Should you not just point forms against tables and let the APEX magic take care of it all? No, I do not think you should. The reason is that I love that feature for […]

APEX, SQL, Performance, Oracle, OOW, DBA

OOW 2010 Develop Keynote

TweetShareSharePin0 SharesYes, this post is a little out of order as it clearly didn’t take place after the Thursday afternoon sessions. I missed it during the conference so I had to catch up on it later on the on demand site. I thought it was interesting enough to write up a few notes. It was held by Tom Kyte and the subject was “What’s new in database development”. It’d be more correct to say Oracle development than database development as […]

SQL, Performance, Oracle, OOW, APEX

OOW 2010 Thursday Morning

TweetShareSharePin0 SharesThe day starts with a presentation b6 Tom Kyte about “What else can you do with system and session data”. Tom starts with reviewing the history of tuning an Oracle database. The prehistoric era (v5) required writeing debug code as that was the only way to get any information about what the code did. The dark ages followed (v6) and now Oracle introduces: Counters/ratios bstat/estat SQL Trace The first few (7?) v$-views are introduced In the renaissance era (v7) […]

OOW, Oracle, APEX

OOW 2010 Wednesday Morning

TweetShareSharePin0 SharesWednesday starts off with a presentation about a new feature in APEX 4.0 that I have not had a chance to look into. It is how you use and develop plugins. The presentation was held by Patrick Wolf who is also the developer of the plugin feature. Scott began by showing how a plugin is used (that is using a plugin compared to developing it). You install a plugin by selecting plugins in the shared components section, and then it […]