Oracle 10gR2: .Net stored procedures (C#, Visual Basic .Net, Visual C++)
This weekend I read a small article in a local Dutch IT-magazine that took me by surprise. I suppose I should have seen it before, but for some reason …
Category: Database
Lots of little interesting notes on Oracle 9i & 10g – database design, DBA, architecture, performance etc. from the Tom Kyte seminar
Last week, I sat with six colleagues at the AskTom Live – seminar with Tom Kyte. You can see us sitting here in the frontrow. You may have seen …
Discussion on The Server Side: Comparing Microsoft Yukon (SQL Server 2005, Beta release) with Oracle 10g
I ran into an interesting discussion on The Server Side: Comparing Oracle 10g and SQL Server Yukon. It contains a link to a white paper: Features, strengths, and weaknesses …
Tom Kyte part II. Using what we have learned
In this post we will tune a query from being hopelessly slow to fast. We will use “explain plan” to analyze the query plan. We will see how Oracle …
Pie Charts in SQL – how pathetic can you get?
I have written a number of posts on alternative, far fetched usages of Table Functions. My all-time high thusfar was a post titled Table FUNctions: select a graph in …
Stored Java to run an OS command, copy a file and get a directory listing in Oracle
Oracle 8.1.5 introduced the ability to choose Java as a language to implement a stored procedure. One of our customers required the following functionalities from within an Oracle database: …
Courtesy of Tom Kyte: Generating rows in SQL with the CUBE statement – no dummy table or table function required
![Courtesy of Tom Kyte: Generating rows in SQL with the CUBE statement – no dummy table or table function required]({"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"http:\/\/seattletimes.nwsource.com\/ABPub\/2012\/08\/02\/2018836700.jpg","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"} "Courtesy of Tom Kyte: Generating rows in SQL with the CUBE statement – no dummy table or table function required")
In a previous post Making up records in SQL Queries – Table Functions and 10g Model clause I discussed how you can make use of either a Table Function …
Combine Oracle Toplink and the Spring Framework – Rod Johnson & Jim Clark
An interesting article Of Persistence and POJOs: Bridging the Object and Relational Worlds, by Rod Johnson and Jim Clark in Mastering J2EE Application Development Series on OTN (the Oracle …
Missed MySQL New Toolset
I apparently completely missed the new MySQL toolset, which was announced on December the 8th 2004. The MySQL database ships now with easy-to-use visual database tools: MySQL Query Browser …
Effective Oracle by Design
Title: Effective Oracle by Design – Design and Build High-Performance Oracle Applications Author: Thomas Kyte Published by: Oracle Press ISBN: 0-07-223065-7 Publication Date: 2003 Details: 664 pages, $59.99; www.OraclePressBooks.com …
Publishing PL/SQL Based WebServices
January 24, 2005
Database, IT, Java, Oracle, Oracle WebLogic Server, PL/SQL, Web HTML5 CSS3
2 Comments
This post discusses how a Web Service can be published based on a PL/SQL Package inside the Oracle Database – using Oracle 10g JDeveloper. In this article we will …
Consuming Web Services from PL/SQL – Part II: A pure PL/SQL solution using UTL_HTTP (Oracle 9i or 10g)
This post discusses how a Web Service can be consumed from PL/SQL inside the Oracle Database through the use of the UTL_HTTP supplied package. In this article we will …
Voor de liefhebbers – Postgres SQL 8.0.0 voor Windows
Er is lang op gewacht, maar hij is er nu ook voor Windows – Postgres SQL 8.0.0. Volg de volgende link voor meer informatie: http://www.postgresql.org/about/news.277
Starting with JasperReports
January 20, 2005
AMIS, Databases, Java, Oracle, Oracle WebLogic Server, Tools, Web HTML5 CSS3, Web/Java
81 Comments
My first days at AMIS I examined JasperReports (v. 0.6.3), an open source report-generating library. This tool is entirely written in Java and uses XML report templates to generate …
Consuming Web Services from PL/SQL – Part I: Using Java Stored Procedures
This post discusses how a Web Service can be consumed from PL/SQL inside the Oracle Database through the use of Java Stored Procedures. In this article, we will create …
Paper on JDeveloper as tool for PL/SQL Development
Tonight I completed a paper on using JDeveloper as a tool for Database Design and Generation as well as PL/SQL Development. This paper is in Dutch and will be …
MERGE!
When I was confronted with the challenge to import about 260 tables from two different Rdb’s into a single Oracle database (9.0.1.x) on a daily basis via a database …
Just before X-mas
On the 7th of December, I, a database administrator, had a seminar from Mr. Chris Date about “Relational Remodeled” (into the 21st century with the relational model: a technical …
XSL Transforming XML generated from SQL results using JSTL tags in JSP pages – putting JSTL to the test
While working on more advanced Statistics Reporting for our weblog, I did some investigations into JSTL and more specifically the XML and SQL tags. Yes, I know I have …
Book Review: Oracle Database 10g New Features – Oracle10g Reference for Advanced Tuning and Administration by Daniel Liu, Don Burleson, Madhu Tumma, Mike Ault
Title: Oracle Database 10g New Features – Oracle10g Reference for Advanced Tuning and Administration Authors: Daniel Liu, Don Burleson, Madhu Tumma, Mike Ault Published by: Rampant Tech Press ISBN: …
Pivoting in SQL using the 10g Model Clause
In this post we discuss pivoting of records in SQL - either splitting or merging records. Typically this is done using PL/SQL based Table Functioins, UNION (for splitting records) …
Parallelizing Table Functions (instead of paralysing)
In this post I explore the parallel execution of Table Functions. I was told it could be done, I have seen the examples and now I have tried it …
Of Data Guard and the Night Watch; a Date with Chris at the Rijksmuseum
Last Thursday evening was special. On the occasion of Chris Date’s visit to The Netherlands, the product marketing department of Oracle Netherlands had gathered some 25 odd (could also …
Oracle Open Source : SQuirreL
Not too long ago my colleague Zeger Hendrikse gave this presentation on Open Source Databases. Part of this presentation are the Tools available. One of the Tools he mentioned …
Table FUNctions: select a graph in SQL
You may seen some enthousiastic ramblings on Table Functions in earlier posts I have written. This is another one. With approximately 50 lines of code, you can select crude …
The December shipment is in: New books have arrived
Last week we received another shipment of books for our evergrowing library. Among this shipment were these titles:
JDBC database copy of table contents
For one of our projects, we wanted to copy the contents of our production database to the test database. Both databases are accessible via JDBC. After an investigation of …
Toplink’s Object to XML mapping
November 25, 2004
Databases, Java, Oracle, Oracle WebLogic Server, Tools, Web HTML5 CSS3, Web/Java
No Comments
On OTN there is an excellent online seminar (replay) on the TopLink Object-to-XML support. This feature, which will be available in the upcoming 10.1.3 release, allows converting XML files …
Tom Kyte presenting in The Netherlands – 8,9 and 10 February
On February 8, 9 and 10, Tom Kyte will present a seminar – just around the corner, in Utrecht. See Seminar Details for details. The event is organized by …
Making up records in SQL Queries – Table Functions and 10g Model clause
From time to time there is a need in my SQL queries to have access to a table with a specific number of records. Sometimes I want to explode …
Setting up Oracle JNDI Datasource on Tomcat
In one of the projects I’m involved in we have to make use of specific Oracle JDBC features. The application runs on Tomcat 5.0.27 and connects to the database …
SQL Script to empty out/cleanse a user schema
OK, it is a fairly trivial task. But when you have to prepare for workshops etc. it may take a lot of time to purge/cleanse/empty all student’s schemas without …
Interesting articles on various subjects
November 5, 2004
Database, IT, Java, Oracle, Oracle WebLogic Server, PL/SQL, Web HTML5 CSS3
1 Comment
In this post I collect references to interesting articles on a variety of topics – Java, SQL, Business Intelligence, Web Services, HTML/CSS, JavaScript – that I have come across. …
Oracle (finally) announced release of Enterprise Planning and Budgeting
From both the Oracle website as well as Mark Rittman’s weblog the release of Oracle’s new enterprise level Business Intelligence product Enterprise Planning and Budgetting was announced. This tool …
Hidden PL/SQL Gem in 10g: DBMS_FREQUENT_ITEMSET for PL/SQL based Data Mining
Data Mining in PL/SQL applications – Supplied Package DBMS_FREQUENT_ITEMSET (new in 10gR1) Resource: Oracle 10g Supplied Packages – dbms_frequent_itemset. This package exposes some part of the Data Mining capability …
Talk on Open Source Databases
Thursday the 7th of October a presentation was given on Open Source databases during an Amis (Server Development and Programming Languages) Knowledge Center meeting. The aim was to present …
DDL Wizard – freeware to extract DDL from Export-files (dump-files)
Thanks to Mark Rittman’s blog: The Oracle Export File DDL Extract Wizard What Does the DDL Extract Wizard Do? The DDL Extract Wizard will reverse engineer Oracle Export files …
A single POJO persistence model to replace JDO and take over much of EJB??
Java and persistence are hot. And continue to be hot. If I read things correctly, Sun – through Linda DeMichiel and Craig Russell Specification Leads, JSR-220 and JSR-243 – …
Analytical SQL Functions – theory and examples – Part 2 on the Order By and Windowing Clauses
To understand how Analytical Functions are used in SQL statements, you really have to look at the four different parts of an Analytical ‘clause’: the analytical function, for example …
Analytical SQL Functions – theory and examples – Part 1 on the Partition Clause
To understand how Analytical Functions are used in SQL statements, you really have to look at the four different parts of an Analytical ‘clause’: the analytical function, for example …