DBConsole 11g (part 1) – An introduction of the new version
Thinking about my first post on Oracle 11g (Beta) I realized that I didn't mention another great addition to the Oracle (DBA) toolset. OK, of course, it isn't new …
Category: Database
Presenting: the freeware Quest CodeGen Utility – great for PL/SQL (and for other database and non-database related development) (AMIS Academy, 27-jun-2007)
![Presenting: the freeware Quest CodeGen Utility – great for PL/SQL (and for other database and non-database related development) (AMIS Academy, 27-jun-2007)]({"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"} "Presenting: the freeware Quest CodeGen Utility – great for PL/SQL (and for other database and non-database related development) (AMIS Academy, 27-jun-2007)")
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 …
Oracle 11g: New sql.bsq structure
Probably one of the oldest database scripts around is the sql.bsq file. First comments described in the heading of this file date from 1994 (“anori – 11/17/94 – ADT …
SQL Challenge – Planning a Conference Schedule
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 …
Oracle 11g – First Impressions
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 …
How to calculate the Easter date in PL/SQL
Ever wondered how they Easter date is determined? And, even more important, how it is to be maintained in you application. Manually updating the date every year is an …
Four Dutch Experts in ODTUG Kaleidoscope Expert Panel Session
June 19, 2007
AMIS, Databases, Development Tools, IT, Java, Oracle, Software Development, Tools, Web HTML5 CSS3
No Comments
From different posts on this blog it should be clear by now: the ODTUG Kaleidoscope conference has taken off. I am writing this post as I am attending the …
ODTUG 2007 – Two Best Paper Nominations for the AMIS crew
June 16, 2007
Database, IT, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, SOA
1 Comment
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 …
invalid oraInventory in Oracle e-Business Suite
When running the http (CPU April 2007) patch on the Oracle EBS 11.5.9, I received some errors…It seemed the oraInventory was not valid, at least the http entry was missing. …
Countdown for release Oracle 11g has started
According to the post of Eddie Awad, Oracle 11g will be released at the 11th of Juli, 2007. So the time we actually can post about it comes near. …
AMIS Technical Session: A closer look at Oracle Toplink (aka EclipseLink) – donderdag 7 juni, 18.00 uur
Oracle and Java are two of the main areas of our (at AMIS) expertise. They come together in many different ways, but particularly in Oracle Toplink. Peter Ebell, a …
Are Index Scans always good……
During my work a lot of times I have heard the same rumour. Lots of people are stating that when a system is doing index scans the system is …
Why I sometimes hate GUI’s…
Hate? Let’s say it is a love / hate thing, but I can’t help myself. I am a script nerd and probably always will be, but even I have …
Introducing the Oracle PL/SQL Pseudo Code Compiler !?? – 3rd Oracle SQL Quiz – Smokin' Water – All new, all intriguing – Come and participate: 20th June@ODTUG Kaleidoscope
For the third year running, Alex and I will present the Oracle SQL Quiz on the ODTUG conference. This Quiz has a dozen or so questions on Oracle SQL …
Getting started with Derby – The java database bundled with Java 6
May 24, 2007
Databases, DBA Oracle, Java, Software Development, Tools, Web HTML5 CSS3, Web/Java
1 Comment
I often need a database to perform some quick tests. I usually start my Oracle instance. This takes some time and for most things it’s overkill. So a database …
Donderdag 31 mei (17.00 uur): AMIS Mini-Conferentie – zes presentaties: SQL Quiz, ADF & Maven, .Net Windows Forms, Oracle BPEL & Workflow, Implementing a SOA Infrastructure, AJAX in ADF Faces
May 24, 2007
Database, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, SOA
No Comments
Next month, the ODTUG 2007 Kaleidoscope Conference takes place in Daytona Beach, Florida. 125 presentations on Oracle Development tools related topics – database, SOA, BI, ADF, JEE 5, AJAX, …
Annoying pop-up’s (CiD adware) and the security equilibrium
I believe I am careful when I am on the internet. My personal laptop is almost a fortress regarding protecting me from internet scum, so I try to protect …
Remembering the days…
Thanks Doug, for pointing out one of the first Oracle 30th anniversary links: http://www.oracle.com/oramag/profit/07-may/p27anniv_timeline.pdf. I had the privilege to meet Mr. Jacobs in person for two times now. Two …
Creating a shuttlebox in Apex
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 …
Made to order: Eirik’s Hi-Lo Chart in SQL – extending the SQL Chart Palette (Pie, Stacked Bar Chart, Gauge, Gantt,…)
With the series on SQL based Charts, I can now safely commit any crime in the firm knowledge that an insanity plea will undoubtedly be accepted. After spending way …
Autoconfig templates ?
The company I work right now uses autoconfig. No problem off course, but they also have a lot off custom templates. Autoconfig uses templates to generate the configuration files …
Gauge charts in SQL or How to produce the world's ugliest speedometers
I may be at JavaOne 2007, the important work still has to go on. Hence the latest in a series of SQL powered charts and graphs: the Gauge or …
Creating a Gantt-chart in SQL
There are many things that can help make this world a better place. A pure SQL-based Gantt-chart is not one of them. However, that is exactly what this article …
Brilliant use of XML in the relational database
A great example of how one could use the Oracle XMLDB functionality in a unforeseen way in your relational world, is being demonstrated by Laurent Schneider in his article …
Year 2000 problems…
Last year our firm (AMIS) celebrated its 15th anniversary. This year Oracle celebrates its 30th year of its existence. In that reflective light, I remembered a nice “Easter egg” …
EBS advanced topologies: Sharing APPL_TOP, ORACLE_HOMEs, err… heck, why don’t we share it all?
Implementing a shared APPL_TOP with E-Business Suite is common practice these days. Since 11.5.10, there is also support for a shared technology stack (8.0.6 and iAS ORACLE_HOMEs). But what …
SAN, SUN and SOA, better run and hide – Likes and dislikes of Anjo Kolk – report of an inspiring AMIS Query on Performance
Last night, we hosted an inspiring and thought provoking AMIS Query, with some 70 developers, project managers and primarily DBAs. The presentator was well known performance expert ("I just …
Why you should never ever copy code – An example of complete chaos
April 18, 2007
Architecture, DBA Oracle, Java, Oracle, PL/SQL, Software Development, Software Engineering
4 Comments
It seems innocent, a few lines of code used twice in the same application. But before you know know it those lines appear 272 times in your application! You …
How to trace a java application through a connection pool using DBMS_MONITOR
April 4, 2007
Database, DBA Oracle, Development Tools, Java, Oracle, Oracle WebLogic Server, PL/SQL, Web/Java
3 Comments
Much has been written on how to trace database sessions through a java application in all sort of different techniques. Since Oracle 10g a new technique is added to …
How upgrading to Apex 3.0 spoiled my weekend!
Allright, that is an exaggeration. Hugely. But it cost me some headache before I realised what was my problem. I still had HTML DB 1.6 running and I thought …
AMIS Query: Anjo Kolk (Miracle Benelux, Oak Table Network) – How the Middle Tier is Slowing Down Your Database
AMIS is proud to announce our next AMIS Query (free technical seminar), targeted at Oracle Database Architects and Database Administrators How the Middle Tier is Slowing Down Your Database …
About hierarchical queries, filling the gaps and doing stuff in ApEx
Sometimes you are writing some codes and things really come together well. Let’s imagine, you are writing a little tool in ApEx for registering hours on a project. The …
Oracle E-Business Suite R12 with OEM10G
After configuring the Oracle EBS 11.5.10 environment in OEM10G, it was time to also configure the new Oracle EBS R12 environment in OEM10G. Before I could configure R12 in …
Best practices suck!
I know, it’s a little bit of an aggressive statement, but if you think about it, it gets to you… Regarding performance and “best practices”. Let’s do this, a …
Installing Oracle E-Business Suite Release 12 with shared APPL_TOP on CFS
As soon as EBS Release 12 became available, I started with the installation, eager to find out what the differences were compared to 11i. I had had the opportunity …
Great start of Hotsos 2007
I got up at 5 o’clock (CET) in the morning on Saturday and made my way to Schiphol airport, so Gerwin and I could take our plane to Dallas, …
About JR, Sue-Ellen and Hotsos 2007
I will be attending HOTSOS 2007 next week; and to be honest, I am not really into it yet. Despite, I guess and hope the great presentations, keynotes and …
New XML(DB) related whitepapers available from Ken Atkins
During OPP 2007, two presentations by Ken Atkins where given regarding XML(DB) items, featues and best practices. My collegae Alex Nuijten was also attending, and presenting, and hinted me …
First patch for Oracle E-Business Suite R12
This morning I downloaded my first patch for the new Oracle EBS R12. Already there are 2 high priority patches for the new EBS, and I downloaded one of …
Removing double records (and keeping one of them)
Assume you have a table with contaminated data (in this example: non-unique values on col1 and col2), for instance because no unique key was implemented. col1 col2 value 2 …