People will commonly ask me this question, which has a very wide range as the answer. You can get an app build on oDesk for nearly free - i.e. $2000 or less. Will it provide the functionality you need? It might! Do you need a website that does the same thing? Do you need a database (i.e. something beyond the app) to store your data for your customers?
Our first round of apps (more...)
When I first heard about Amazon's offering called CloudFront I really didn't understand what it offered and who would want to use it. I don't think they initially called it a content delivery network (CDN), but I could be wrong about that. Maybe it was just something I didn't think I needed at that time.
Amazon states it well today (as you might expect). The offering "gives developers and businesses an easy way to distribute (more...)
A recent question on the Oracle-L mailing list was about generating dates in a given period. If you had a string like 'MWF', all Mondays, Wednesdays and Fridays between the from- and to-dates should be generated.
That reminded me of a quiz on plsqlchallenge.com
I did on using DBMS_SCHEDULER.EVALUATE_CALENDAR_STRING. I had created a table function to test calendar expressions - that might be useful for something similar to what was asked on the (more...)
It's Christmas time... It's a time for giving... It's a time for warm-hearted feelings...
But there are people battling for their lives against cancer, who may not have much energy left to enjoy the holidays. Almost everybody has family or friends whose life has been impacted by cancer. Let us all reach out however we can, help wherever we can, and let good thoughts go out to the victims.
All cancer is terrible - but (more...)
It's amazing how much work goes into a one page website these days! We've been working on our new version of our website (which is basically one page) for the last month or so. The content is "easy" part on one hand and the look and feel / experience is the time consuming part. To put it another way, it's all about the entire experience, not just the text/content.
Since we're a video company, it's important that they (more...)
Most every startup that I've watched (and been part of) has grand plans of virality. Build it and they will not just come to you, but they will flock to you! There is a dream that what you have built is going to change the world and it's going to be so obvious to everyone that they will want to share the news with all of their friends. It's a good dream and there is (more...)
Nikolay Savvinov hat vor einiger Zeit einige Artikel veröffentlicht, die sich damit beschäftigen, dass DML-Operationen für Blocks einer Größe von 4K eine deutlich schlechtere Performance liefern als entsprechende Operationen für Blocks der Standardgröße (8K). Hier eine Liste der Artikel:
Ich spare mir eine detaillierte Zusammenfassung der Artikel und springe gleich zur Pointe, die der Titel des letzten (more...)
Since we dropped our beta out of SQLDeveloper 4.1
and announced SDSQL
, we've been busy getting some of the new things out to users. We support SQL*plus editing straight out of the box, but one thing that was always annoying was the time when you make a mistake and can't fix it to you have finished typing to go back and add a line like this.
This was always the way as console (more...)
The questions in the quiz were, of course, all trick questions.
Question 1: Answer D
SELECT * FROM T1 LEFT NATURAL JOIN T2;
SELECT * FROM T1 NATURAL LEFT JOIN T2;
The second example shows the correct syntax for a natural outer join. In the first example, LEFT is interpreted as a table alias for T1 and so an inner join is used.
QUESTION 2: Answer E
SELECT * FROM T1 INNER JOIN T2 ON (more...)
I’m on my way to UKOUG Tech14, where I will present Database 12c MATCH_RECOGNIZE: Beating the Best Pre-12c Solutions on Tuesday at 3 P.M., room 4B. With all the Oaktable ACE Directors presenting at the same time, I don’t expect a big crowd but I’ll do my best for those who do turn up. This is my […]
First things first: Thou shalt not explicitly set AQ_TM_PROCESSES=0 ! Unless, of course, you want to disable the Queue Manager Process (QMNC in Oracle 11.x). Which you may want to do during database upgrades to prevent Streams or Advanced Queueing from interfering with the upgrade process. However, if you don’t reset this parameter afterwards, you might run […]
Learning, relearning or unforgetting…
What value is there in a DISABLEd constraint?
This was a question on the OTN forums this week and a) my first reply was wrong and b) I couldn’t find a clear demonstration elsewhere.
The documentation is clear.
The ETL process commonly verifies that certain constraints are true. For example, it can validate all of the foreign keys in the data coming into the fact table. This means that (more...)