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 …
Category: PL/SQL
Forms to Java migration at ODTUG
![Forms to Java migration at ODTUG]({"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"} "Forms to Java migration at ODTUG")
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 …
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 …
Solving a Sudoku with 1 SQL-statement: the Model-clause
Solving a Suduku with one SQL-statement, is that possible? A lot of people won’t believe it, but yes, it can be done.
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 …
AMIS Query – 22/5/2007: Integration between Oracle Forms and HTML Web Applications (e.g. ADF)
Tuesday, May 22nd, AMIS hosts another very interesting AMIS Query event: Wilfred van der Deijl (Eurotransplant) will demonstrate his ingenious method of integrating Oracle Forms (web forms) with HTML …
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 …
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 …
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 …
Is Jinitiator going away?
Is Jinitiator going away I am wondering for a long time. Especially now the the Sun JPI can easily be used with Web Forms. My colleague Marco pointed me …
Solving a Sudoku with Collections
If you want to write a program to solve sudokus, you can use almost any programming language. And PL/SQL too!
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 …
CTAS and IOT
This was the second time I needed to look up how to create an Index Organized Table (IOT) with a Create Table As Select (CTAS). So just a quick …
Contract-Oriented PL/SQL Coding
During the Oracle PL/SQL Programming Conference in San Francisco another session I really liked was called "Contract-oriented PL/SQL Coding". In this blog I will go over the basic principles …
Looking back at the OPP Conference: Steven's Keynote
Now that the OPP is over, it is time to look back on the most interesting things that I have heard for the last couple of days. The first …
AMIS Awarded for contribution the Oracle PL/SQL Community
During the Oracle PL/SQL Programming Conference, AMIS received an award for their contribution to the Oracle PL/SQL Programming Community. To be more specific, the award reads: "In recognition of …
OPP2007: Test-a-Thon
Can you believe it? After a full day of different presentations on PL/SQL, people just couldn’t get enough of PL/SQL. The 2 day Oracle PL/SQL Programming Conference (OPP2007) in …
Going to SF, to meet SF
At 04:30 this morning my alarm went off. I don’t like mornings, but today is different from other days. Today I flew into San Francisco for the Oracle PL/SQL …
Running Webforms without Oracle JInitiator
February 21, 2007
AMIS, IT, Oracle WebLogic Server, PL/SQL, Software Development, Software Engineering
9 Comments
A few weeks ago one of my customers told me that he lost a sales opportunity because the customer who he was trying to sell his software too had …
Testing, One, Two….
Just in time for the Oracle PL/SQL Programming Conference, OPP2007, the Code Tester for Oracle is released. I am very excited about this tool and more posts will follow. …
Writing a pure SQL based String Tokenizer
A quite common concept in many programming langiages, though perhaps strongest in Java, is the String Tokenizer. This is a utility class or function that takes a String as …
Creating XML Data Services for Reporting and ESB integration using DBMS_EPG (the internal HTTP/PLSQL Gateway) and XMLType
Today I all of a sudden found myself investigating the creation op PL/SQL based Data Services, returning XML documents with data from SQL queries to HTTP Clients. The direct …
Never Assume, always test…
Yesterday evening I started preparing for the upcoming Oracle PL/SQL Programming Test-A-Thon. I strongly believe that building your own programs to perform a functionality, which is already provided as …
My first steps with Oracle BI Publisher Enterprise Edition 10.1.3.2: create a report based on the OraBlogs rss-feed
After receiving a new, pretty powerful laptop, on Thursday and installing the Oracle BI Enterprise Edition on Friday, this weekend sees my first steps with the BI Publisher (previously …
Transaction Dependent Webservice Invocation…or how to call a webservice from a database trigger and make the call part of the transaction
One of our clients asked us to help with calling a webservice from a database trigger. This webservice would duplicate the actions done by the database in a different …
How to build an Oracle Forms application on BPEL/WF
Why Oracle Forms and BPEL? Old style Forms applications normally don’t hold much workflow functionality. Sure there is an order in which the forms should be used. The workflow …
The issue of Webforms and Internet Explorer add-ons
IE 7 Webforms jvm.dll crash
Disappearing Columns
At the site where I am currently working Oracle Designer is used. The version they have here, Designer 10, does not supprt XMLType and this posed a problem at …
Writing a Word Search puzzle solver in SQL
Brace yourself for yet another pretty useless demonstration of the unexpected wonders of SQL as well as my apparent lack of meaningful things to do with my life. Undoubtedly, …
Setting properties per record in Forms MRB
This is probably described many times before, but you just can’t have enough example code snippets. Imagine you want to restrict users to update records which end-dates are in …
Dummy data without dummy tables – just a little SQL trick with the TABLE operator
While writing useless queries for solving exotic challenges, I realized that the use of dummy tables or unions of selects against DUAL for producing a few data-rows is a …
WHEN-IMAGE-PRESSED Trigger problem in Oracle Forms 6.0
Yesterday we ran into Oracle bug 1004056 while coding a module for a customer. I hear people think "Oracle Forms 60 that’s old". Yes it is but it is …
The SQL Query to power Google Suggest
You probably know Google Suggest or one of its derivatives. An input item on a web-page or another user interface where you can enter a value that all of …
Pimp you SQL Developer
SQL Developer released a 1.1 evaluation version a couple of days ago, which you can download here, and I noticed something very familiair. In Firefox you can have search …
Generate 'Delete with Confirmation' in JHeadstart applications
November 10, 2006
IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, Tools
3 Comments
JHeadstart is one of the tools we use quite successfully here at AMIS. We have written on this blog about JHeadstart and ways to extend, enhance and optimally benefit …
Extracting Master-Detail data from an XMLType with a single SQL statement
Probably this is old news for all of you who have lots of experience with XMLDB, but for me this is something new. In order for me to remember …
OOW 2006: Keynote speech at Oracle Develop by Thomas Kurian
Yesterday (Monday) was the Keynote speech by Thomas Kurian, Oracle VP, that started the Oracle Develop event. In what can be described as a crisp, well organized presentation, Kurian …