Application Development

Category

Article #3 in my ongoing series covering SQL statistic functions in Oracle Database is now up. The topic is the median: MEDIAN: For When You Don’t Really Mean It Median is useful in typifying a data set when the data might be skewed, or in the presence of extreme outliers. For example, the U.S. Census Bureau reports median household income… Continue Reading →

Application Development, Database Administration, Database Development, Oracle Database, PL/SQL, Uncategorized

When working with APEX, you also need a number of tools to improve the efficiency of your work. It isn’t enough to just have the APEX IDE at your disposal. Besides the APEX IDE for the application development, you may use a bunch of other tools. This is what I mean by the APEX ECO-System. For the PL/SQL development and… Continue Reading →

APEX, Database Administration, Database Development

I’ve just put up the second in an ongoing series (I hope!) of articles on Oracle SQL’s built-in statistical functions. The topic is standard deviation. I introduce the concept and show one use of it in detecting wide variations that otherwise go unseen in summarized data. Here’s a link to the article: #2. STDDEV: Standing Sentinel on Your Data It… Continue Reading →

Application Development, Database Development

Speed, performance, optimization: time is of the essence when you’re waiting for an operation to complete. Our Oracle tools — Schema Compare, Data Compare and now Source Control for Oracle —all need a database model filled with schema objects and their properties. They also need to figure out object dependencies so they can do their jobs with accuracy — all the… Continue Reading →

All Things Oracle Full Articles, Application Development, Database Administration, Database Development, Oracle Database, Performance Tuning, PL/SQL, Troubleshooting

  Trust is a great force multiplier. – Tom Ridge When you build a web application you have two choices for the pages: they can either be public or protected. Mostly you will build applications using a combination of the two. Some pages will be publicly available, like the landing page of your application, but there will also be pages… Continue Reading →

All Things Oracle Full Articles, APEX, Application Development

This video is a follow up to the webinar broadcast by Red Gate on 14th November 2012. Please leave a response and ask questions at the bottom of the page. Watch video Summary The journey of a team-developed database, from initial development to successful deployment to production, involves many stages. Regardless of the specific development methodology employed (ITIL, Scrum, etc.)… Continue Reading →

Application Development, Database Development, Webinar

Greatness is a transitory experience. It is never persistent. – Collected Sayings of Muad’Dib by the Princess Irulan In the previous article we saw how we could have different version of the code in different editions of the schema. But what about the tables? They are not editionable? This article will show you how to work ‘around’ that. Data Most… Continue Reading →

All Things Oracle Full Articles, Application Development, Database Development, Oracle Database

We’re interested in knowing which Version Control Systems Oracle database teams use to store their database scripts, please help us by taking our quick poll: What is Source Control? Source control (or version control), is a system which tracks and retains an incremental history of changes to a set of files. Source control systems can be used in many types… Continue Reading →

Application Development, Database Administration, Database Development, Polls

Having used Oracle APEX since its first appearance on the Early Adopter Platform I finally got my hands on the real thing and installed in on my test-system. This Post tries to give you a summary of the big changes in Oracle APEX 4.2 (compared to 4.1.1) from a datamodel/view/API Point of view. If you are coming from APEX 4.0… Continue Reading →

APEX

In part 1 I explained how to duplicate a single instance database using RMAN. This article will focus on converting the single instance to RAC. 2. Convert Single instance to RAC We have migrated the database successfully from Non-ASM to ASM using RMAN; the database is still running as single instance.  Now we need to convert the single instance database… Continue Reading →

10g, 11g, All Things Oracle Full Articles, Application Development, Database Administration, Oracle Database, Uncategorized