This article is about functions and how to get more out of them if you combine them with record structures. Functions are the instrument in the Oracle Database to execute code and return a value. Nothing new here, everybody who develops in PL/SQL on the database knows that. In case you’re just starting with Oracle and want to know more about… Read more
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 us… Read more
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 generat… Read more
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… Read more
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 prov… Read more
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… Read more