Application Development

Category

Here’s a simple trick you can play on your friends. Ask them to pick a number from 1 to 10, and tell them you’ll read their mind and magically extract from it the number they’ve chosen. Don’t give them too long to choose; then put on your best imitation of a magician and say… 7. I don’t know why, but… Continue Reading →

All Things Oracle Full Articles, Application Development, Database Development

The first time you consider it, it may seem a strange idea to put a database into source control but, on reflection, it makes sense. The reason to do so is the same reason that you put anything else in source control: to be able to revert to previous releases with minimal effort. Imagine that, after you release version 1.0… Continue Reading →

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

Database replay was introduced in Oracle 11g R1, and it allows you to capture workloads on a Production system and replay them in your Development or test environments while maintaining the unique characteristics of the workload. This enables the user to test a variety of system changes such as hardware/software migration, operating system/ database upgrade, patches, database config changes etc…. Continue Reading →

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

The below content is based on a David Peake‘s presentation at OOW 2012 and APEX World 2013. As the Oracle Database 12c is not out yet at the time of writing, note that things might be different in the final product. The Oracle Database 12c is a major release in Oracle history, as it contains a complete redesign of the underlying architecture. Two… Continue Reading →

12c, APEX, Database Development

Prerequisites A local database, for development SQL Developer version 3.2.20.09.87 or higher (Download) Wallet Manager Getting started To get started, we first need an account on the Oracle cloud. So go to Oracle Cloud, login with your OTN account and request a trial period. You will need to enter a credit card for verification, but it will not get charged… Continue Reading →

All Things Oracle Full Articles, APEX, Application Development, Oracle Cloud, Oracle Database, PL/SQL

Console Wrapper 1.0.4 is officially out. You can download it from the project page: https://code.google.com/p/js-console-wrapper/ The only change for this release was to resolve an IE 9/10 issue which I previous blogged about. If you’re using any of the ClariFit plugins you may want to update the $console_wrapper.js file that’s included with each plugin. I’ll be sure to include the update file for each of… Continue Reading →

Application Development

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