MYSQL Error #1932 Table doesn’t exist in engine
Today I ran into a strange MySql (MariaDB) error. Strange because I’m working with Oracle databases since 1991, so I’m […]
Today I ran into a strange MySql (MariaDB) error. Strange because I’m working with Oracle databases since 1991, so I’m […]
The site www.w3schools.com published a great SQL Tutorial, but unfortunately no PL/SQL Tutorial on w3schools.com exists. Ok, I understand that
On Oracle Reports and Forms calls, for security reasons, Reports user should not see the Oracle Reports URL with Userid
We’re using Oracle Forms source control outside of Forms. Currently we’re very happy with our VSS setup. So we are
With the function TO_CHAR, Oracle converts a number or date to a string. The to_char Oracle syntax is: to_char( value,
Für SQL gibt es diverse Standards, somit kann eine SQL Befehle Übersicht relativ umfangreich werden. Glücklicherweise halten sich die meisten
Oracle Serice Bus (OSB) XQuery Exception: FORG0005: expected exactly one item, got 0 items OSB-Aktion “Ersetzen” beim Aktualisieren der Variable
Part of my Oracle Service Bus Tutorial: Building a dbAdapter on a Master-Detail table or view. JDeveloper offers two ways
The Oracle Sum fuction is very useful. Also analytical Oracle Sum functions are available. Using sum(<column>) over (partition by <column>):
Ok, the main information page about Oracle Service Bus documentation is on Oracle’s technet isself: http://www.oracle.com/technetwork/middleware/service-bus/overview/index.html and on the Oracle