Quest has recently aquired Qnxo which they will make available for free on ToadWorld.com. They have also renamed the product to from Qnxo (Quality iN, eXcellence Out) to Qcgu (Quest Code Generation Utility). Since the acronym doesn’t sound too good, it will probably be referred to as CodeGen. I have been testing the new version […]
Read moreCategory Archives: PL/SQL
Time 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 moreCleanup after yourself
When working with your own arrays in Qnxo, you end up with all kinds of views in the schema that you actually don’t want to be left there. For one because they don’t serve any purpose, except for the CGML code generation, and you don’t want any other code to depend on them, because they […]
Read moreFunctions returning Collections
Suppose you have a table and this table contains only one row, for instance a record with some application settings. You have the QDA packages in place and you want to retrieve this single row. But you don’t know what the primary key will be. On your development system it can be something else than […]
Read moreQDA reduces code…
At my office we are building and supporting software for an insurance company. We have chosen for an architecture where there is one request record. This is connected to one or more variance records, which are in turn connected to the type of insurance. There is also a connection to a number of employees connected […]
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 moreCascading Delete
An option that has been around for a long time in the Oracle Database is ‘ON DELETE CASCADE’ on a foreign key. I almost never use this option, because the front-end takes care of this. But, since there are going to be more types of front-ends to the same database it’s a good idea to […]
Read moreSudoku Solver in PL/SQL
In my previous post I wrote about a Sudoku solver in SQLServer and I thought it wouldn’t take long to have Sudoku solver in PL/SQL. Actually, when I told this to Steven Feuerstein, he told me he got an email from someone who has already done this. He put his solution on his website with explanation […]
Read moreQute
Steven Feuerstein has release a new version of Qute. This time he has added a raffle when you tell what you like and dislike about the product. I think this means that Qute will become production ready really soon.
Read moreGuids as primary keys
Steven Feuerstein wrote a blog post on using Guids in Oracle. One of the things Guids could be used to create a primary key value for a record in the table. How does using this kind of primary keys relate to the speed of your queries. I could imagine that using guids can be slower […]
Read more