As written before, I am currently trying out some things on Oracle 11G after a presentation by Lucas and Alex of Amis. One of the new features they talked about was the virtual columns option in Oracle. This a column based on an expression that doesn’t really exist in the database.
Read moreCategory Archives: SQL
Oracle 11G – Follows in Trigger
I’ve seen a presentation on the 11G new features from Alex and Lucas at Amis. One of the questions posed there was when you are using the new follows option in triggers, what would happen if you have two triggers following the same one. A bit like the way it”s done right now.
Read moreUsing inline views to achieve SPOD
If you are wondering what SPOD is, then check out this blog post by Steven Feuerstein. Suppose you want to create a SQL statement (for a view or cursor or something else) where you want the value of one mathematical function to be used as input for another mathematical function. For simplicity reasons I am just using some […]
Read moreQDA on tables…
When you are implementing the QDA in an existing application, you may want to know what tables have the QDA implemented and what tables don’t have it implemented yet. I have created two SQL statements that retrieve this information from the data dictionary.
Read moreOracle errors…
I’m sure everybody ran into an error of some sort when using Oracle. Some errors are really obvious, you are trying to select a column that doesn’t exist, assigning a variable that hasn’t been declared, that kind of errors. But there are also errors that you don’t run into that often, maybe it’s even the […]
Read moreNot much happening…
Lately I’ve been doing lots of production work at the customers site, so there’s not really much that involves new techniques etc. I did however come up with a nice solution to a small problem I faced. Order results by the last character. In normal SQL you can do an Order by to order by […]
Read moreAnsi SQL vs Oracle SQL
Today I was wondering about whether we should be using Ansi SQL instead of the 'normal' Oracle SQL. Ansi SQL has been supported in Oracle since version 9i, but since we are still developing applications on Oracle 8i we haven't really given it much thought until now. We are migrating our development database to Oracle9i […]
Read moreOracle SQL Developer also for MySQL
This post on Download Squad pointed me to trying Oracle SQL Developer to connect to my MySQL database on this website. After unpacking the download, I tried to connect but apparently I needed some extra software to connect to MySQL. This link on the Oracle site shows the following table. It appears that the needed jar files […]
Read moreTime spent in queries
I was working on a problem with one of our reports. The customer said it took too long to get results in the report, something like 5 minutes or more. Of course they want to see their results in the blink of an eye, but seeing the kind of calculation and querying that has to […]
Read moreDefaults
Oracle 9i and up provide you with a new keyword: DEFAULT. This means you can get to the default values of a column when doing an insert or update. I have tried some things with this on my 10G XE database and I have come up with the following script to test it all (a […]
Read more