Saturday, April 10, 2010

SELECT * FROM spreadsheet (or How to parse a CSV file using PL/SQL)

›
I recently needed to retrieve/download a comma-separated values (CSV) file from a website, and insert the data in an Oracle database ta...
34 comments:
Tuesday, April 6, 2010

Using TRUNC and ROUND on dates

›
Maybe this is old news to some, but I recently became aware that it is possible to use TRUNC and ROUND not just on a NUMBER, but also on a D...
3 comments:
Sunday, March 7, 2010

jQGrid Integration Kit for PL/SQL and Apex

›
I started developing applications back in the good (?) old client/server days. I was fortunate enough to discover Delphi quite early. Even...
26 comments:
Thursday, February 11, 2010

REF Cursor to JSON

›
REF Cursors are cool. They allow you to encapsulate SQL queries behind a PL/SQL package API. For example, you can create a function called ...
37 comments:
Thursday, February 4, 2010

My first Apex 4 plugin: Flight Info from Web Service

›
One of the exciting new features in Apex 4 is the support for plugin regions and items. This feature has huge potential, and will make deve...
4 comments:
Wednesday, January 27, 2010

ODP.NET minimal, non-intrusive install

›
This might be of interest for those who use .NET to connect to Oracle databases. (Including yours truly, who wrote the Thoth Gateway , a mod...
10 comments:
Sunday, December 27, 2009

Using Google Translate from PL/SQL

›
UPDATE, JANUARY 2013: Google no longer offers the Translate API for free: " Google Translate API v1 is no longer available as of Decem...
12 comments: