Gert Poel

Author

I try to use subtypes as much as I can and after reading the “All Things Oracle” article of Patrick Barel on PL/SQL subtypes, I want to add something to his article about the use of subtypes. Booleans are a PL/SQL datatype and doesn’t exist in SQL. This means that when your PL/SQL function returns a boolean, you can’t use… Continue Reading →

All Things Oracle Full Articles, Database Development, Oracle Database, PL/SQL

In part one of “Generating XML from SQL and PL/SQL“, I explained how to generate XML from SQL. In this second part I’ll show you how you can generate XML from table data in PL/SQL. The datatype to hold XML in PL/SQL or in the database is XMLTYPE. So you can use the generated XML in PL/SQL, store it in… Continue Reading →

All Things Oracle Full Articles, Database Development, Oracle Database, PL/SQL, Uncategorized

From time to time you’ll have to represent your data stored in a database in an XML format, eg. to exchange it between systems, to send it to external parties, etc. In this introduction, I’ll show you step by step using small examples how you can easily generate XML from tables. SQL There are some SQL functions available to generate… Continue Reading →

All Things Oracle Full Articles, Database Development, Oracle Database, PL/SQL

Last weeks I ran into some issues with APEX, so let’s take some time to write something about them. The most recent is about heterogeneous services (also referenced as HS). Here is the case: We have an Oracle DB instance with some APEX applications and in one of those applications I need data from a MS SQL server database. Not… Continue Reading →

APEX, Application Development, Database Development

Some time age one of my colleagues, An V., played with the idea to start a company magazine. Everybody liked the idea and our manager gave a green light to create “De Poreiflash”. Why it’s called “De Poreiflash” is a long story and I have to kill you when you don’t work for iAdvise and I tell you this. But… Continue Reading →

PL/SQL

Forms was a great tool and stood for fast and easy development.  You could create nice data entry applications in no time.  But now some people think Forms is dead, it doesn’t have a future or it is at the end of its lifecycle.  In this article I hope to prove they’re wrong.  And unlike the first sentence to prove… Continue Reading →

All Things Oracle Full Articles, Application Development, Database Development, Oracle Database, Oracle Forms

Oracle Forms Survey

Gert Poel on 23 September 2011 with 0 comments

Posted by Gert Poel on the the iAdvise blog: I want to call all Oracle Forms developers and administrators to fill in this online survey about Oracle Forms. The results will be published during Oracle Open World. I’m interested in this topic (Forms and Forms Modernization) and I will be delivering a presentation at Oracle Open World about Oracle Forms(session… Continue Reading →

Oracle Database