It’s been instructive to observe our progress as a creative group at Oracle as we strive to integrate our video department into the creative work process.
Well this is my first post. The aim of this blog is to share tips and tricks in SQL tuning, PL/SQL programming and APEX development in Oracle. I will be posting as I come across things in my day-to-day work and also documenting some things that I’ve already been doing for a while. This blog [...]
Although Oracle Application Express has excellent out-of-the-box options for authenticating users, it is sometimes necessary to write custom authentication schemes to meet specific requirements. Such was the case for one client I worked with, a large government contractor with several Oracle Database instances already deployed and some fairly restrictive requirements, specifically
I recently had a client pose the following question to me.
We have a system that generates pdf's based upon data from our Oracle database. The pdf's are then stored in a BLOB column in a table. We recently realized that at least one of those pdf's was corrupt. Is there a way within Oracle to determine if others are corrupt?
Apparently where there's Tweets, there's fire. Twitter may or may not have a business model (management claims it does), but traditional software vendors are apparently convinced there's money to be made in them thar' streams.
It's been a while since I made a real post, one that has some technical merit. This one just barely qualifies.
There is a nice classic report type "Function Returning a SQL Query" which allows you to write a block of code that returns a select statement. That select statement is the basis for the report. I often use it to simplify building a where clause. It might look something like this:
l_q varchar2(32767); -- This is the return variable. It will hold a select statement
Just a few more hours and then I’m heading out to Collaborate 09. In a break with tradition I’m actually flying out a bit later than usual and flying back a bit earlier (pressure of work and all that!), but I’m looking forward to it immensely.
If you’re looking for information about APEX sessions at Collaborate, [...]
I came across this function in the APEX 3.2 API Reference Guide (Part #E13369-01):
To read the entire article at its source, please refer to Returning a Value from a Popup Page
ately I'm working a lot with XDB.
At the same time, having some spare time to investigate a few outstanding "issues", i decided to search the web for information about alert log messages like the following: