Archive for the 'Developer' Category

The future of SQL Developer - the end of Designer?

Wednesday, July 16th, 2008 by Roel

Last month Oracle released a statement of direction for SQL Developer (here it is). Apart from the enhanced testing capabilities the most important feature will be the support of graphical logical and physical data modeling - just like you normally would do using Oracle Designer - using the acquired CDW4ALL extension. This modeling can be [...]

Popularity: 330 points

Extending SQL Developer with Designer data

Thursday, June 26th, 2008 by Roel

Using the Preferences of SQL Developer you can register a User Defined Extension (UDE). This UDE is just a small XML file containing a command or query. If your Oracle Designer Repository is queriable by the user you use for your connection, you can show the Table Definitions in Designer alongside the definitions in the [...]

Popularity: 268 points

Who is still using Forms with Headstart 3.4.2?

Thursday, April 26th, 2007 by Bart

and wants to upgrade to Forms 10g without the fuss of upgrading Headstart 3.4.2 to 6.5.4?
At our Oracle Competence we run a succesfull Designer/Developer migration solution in which we had to upgrade a Designer 1.3.2 repository to 10g, including the use of the latest version of Headstart.
It’s no fun to modify all the Forms code [...]

Popularity: 404 points

Running Oracle WebForms like ‘a Client-server application’

Thursday, April 26th, 2007 by Bart

At our Oracle Competence we run a succesfull Designer/Developer migration solution in which we upgrade Forms from version 3.0-9i to 10g. Every now and then one of our customers raises the question if it’s possible to run Oracle Webforms in client-server mode “like they used to do”.
The arguments against running webforms in a browser are [...]

Popularity: 723 points

How to create neatly formatted Excel documents using PL/SQL?

Wednesday, July 19th, 2006 by Roel

If there is a requirement to produce output from an application into Excel, you would probably create a CSV (Comma Separated File) with the data and start Excel to show the data - at least that’s what I did…until now. The drawback of this solution is that you could only produce data and no nice [...]

Popularity: 756 points

Oracle’s plans for Forms 11

Monday, June 12th, 2006 by Roel

I found a nice blog where the future of Forms is described. Click here for the complete article.
Popularity: 282 points

Popularity: 282 points

Dramatic performance boost using TEXT_IO instead of CLIENT_TEXT_IO

Tuesday, March 14th, 2006 by Roel

Last week we encoutered the problem that reading a 10,000 record csv-file took 45 minutes from a location in Belgium. From The Netherlands it took about 20 minutes. The Application Server and Database Server is located in the UK. The difference is due to available band width.
The performance from both locations were not acceptable. How [...]

Popularity: 334 points