Category: Languages
Most of the presentations for the sessions presented at Oracle Open World 2007, last week in San Francisco, can be downloaded from the Content Catalog at: http://www28.cplan.com/cc176/catalog.jsp. You will …
The Oracle 11g PL/Scope feature allows us to have the PL/SQL compiler generate information on all identifiers used in our PL/SQL code. Using the information generated and available from …
The November 1st presentation that Alex and I did on 11g – focusing on features and functionality that are of particular interest for developers – is finally available for …
Next week, I am doing two presentations at Oracle Open World, both on Thursday. One is on ADF – more on that later. The other one is The Great …
There are times when a challenge presents itself. Often for no logical reason and without any direct benefit. Like doing a crosswords. I have this unconscious part of me …
At last notice. Next week, Harm and I, will give an AMIS Query about the practical use of XMLDB.In short, I will give an introduction into the XMLDB Features like …
The past days have been really interesting. During last Wednesday (november 24) we finished the XML topic, covering Generating XML from an Oracle Database, Managing XML data in an Oracle Database, …
Puzzelen met SQL – Testdata Generatie Anton Scheffer en Alex Nuijten Dit artikel is de on-line tegenhanger van de rubriek Puzzelen met SQL die verschijnt in de Optimize, …
Yesterday was nice. Alex and I had two presentation ‘gigs’, the second of which was in the Amsterdam Arena, the AJAX Amsterdam stadium: It was sold out! Well, our …
We have been playing with Oracle 11g for quite some time now. Walking around in the toy-store if you like. Trying out many new features, trying to push them …
Oracle 11g introduces Virtual Columns. “What do we need Virtual Columns for, aren’t real ones more useful?” you might wonder. And what are they to begin with? A virtual …
Some time ago I’ve been experimenting with the Apex 3.0 feature that migrates entire Access applications to Application Express. It took me a lot of time because I found …
The live demo presented by Carl Backstrom as presented to the attendees of the Apex European Training Days is now publicly available! You can review at Carl’s blog , …
This week Patrick Sinke and I attended the first edition of the European Application Express Training (EAET). With only a few months of experience with Oracle Application Express (APEX) …
It is nagging… I got an email from that you are able to download the handouts from ODTUG until half September (download them now, 1/2 September they will be …
I just came across this website "I love PL/SQL, and…", one of Steven Feuerstein’s website. If you ever attended a seminar given by Steven, you already know that he …
This (for this site) is a strange post… I am looking for a consultancy job. Nothing new here, but only a strange way to make this visible to the …
Today I was configuring a message driven bean to listen to an AQ queue. The tutorials and examples I found had me create the queue like this: dbms_aqadm.create_queue_table( queue_table=>'MY_QUEUE_TABLE' …
The other day one of my colleagues asked me if it is possible to create a copy of a table with all the content in it. He wanted to …
If you are a regular user of the FORALL statement, you are probably also familiar with this message: PLS-00436: implementation restriction: cannot reference fields of BULK In-BIND table …
A new feature in the Oracle 11g database is the ‘Function Result Cache’. When you create a function with the new clause ‘RESULT_CACHE’ the result of the function is …
Why bother using Google if you know you will find the answer on this blog anyway? It would be a nice feature if you could search directly from your …
In Oracle 11G the supplied package DBMS_SQL is extended with two new procedures: to_cursor_number, which transfers a refcursor to a "dbms_sql cursor" to_refcursor, which transfers a "dbms_sql cursor" to …
Oracle SQL Developer offers the ability to create reports with graphs in it. A number of reports are included with the tool, unfortunately a report which shows information based …
Dit artikel is de on-line tegenhanger van de rubriek Puzzelen met SQL die verschijnt in de Optimize, het vakblad voor Oracle ontwikkelaars in Nederland. In dit on-line artikel kunnen …
What is the most common way of testing PL/SQL code? I think it is using DBMS_OUTPUT and manually verifying the results. Is it the best way of testing code? …
A nice little trick on Oracle 11G is using XMLQuery as an eval function: SQL>l 1 select substr( sys_connect_by_path( level, '*' ), 2 ) || ' = ' …
The PL/SQL compiler in Oracle 11g will give you a warning if it encounters a when others exception without a raise or raise_application_error. SQL> alter session set plsql_warnings='enable:all'; Session …
Last week I made my first steps with XML-Publisher 5.6 Desktop and I am very pleased with the simplicity you can create a report in such a short time. When …
A minor new PL/SQL feature in Oracle 11g is the new statement ‘continue’. With the continue statement you can skip to the next iteration in a loop. A small …
Some months ago, Oracle announced its plans to donate the high end Object Relational Mapping Framework TopLink to the open source community. To be more specific: under the EclipseLink …
Last week six of us at AMIS attended the ODTUG Kaleidoscope conference in Daytona Beach, FL. I always need some time to digest all the information that was presented …
Wednesday 27th June, during the 4th AMIS Academy, Patrick Barel from VDA will present an introduction on QCGU, Quest CodeGen Utility – a freeware utility from Quest, inspired and …
Coming Wednesday, we organize the fourth AMIS Academy (Wednesday 27th June – free mini-conference at our place), a mini-conference with 16 presentations in four consecutive timeslots. One of our …
The official launch is at hand. In less then 3 weeks Oracle 11g will be presented at the world during a, probably, great launch event in New York. AMIS …
Although the presentations at ODTUG this year cover the entire spectrum of Oracle-based application development, from Forms and PL/SQL to ADF, SOA Suite and APEX, the ODTUG crowd is …
The ODTUG 2007 Kaleidoscope conference is just around the corner, starting in two days time. AMIS will attend with a team 6, doing a grand total of 9 presentations …
Solving a Suduku with one SQL-statement, is that possible? A lot of people won’t believe it, but yes, it can be done.
Did you know that when you put the @XmlRootElement annotation on any class you can have an XML representation of that class? When I first saw Java 6 I …
The changelog of Apex 3.0 mentions something about featuring shuttleboxes. Don’t get too enthousiastic, you still have to do a lot of work yourself. And it’s pretty limited, because …
![Oracle 11g for Developers – 60+ slide presentation]({"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"} "Oracle 11g for Developers – 60+ slide presentation")