The following SQL pattern can be used to tranform the CSV file into a HTML table by utilizing the XQUERY functionality.
create or replace directory tmp as '/tmp';
create a word.csv file.
CREATE TABLE CSV_FILE (csv_str VARCHAR2(3000))
First, every result of a function or query for which result cache is enabled has its own dependencies.
Second, all dependencies are tracked while the function/query is being executed.
Third, the PL/SQL function result cache and the SQL result cache internals are the same.
Fourth, if you have a function within a query, for which result cache hint is used, the dependencies for the query result will include the dependencies on the objects accessed by the function.
This has several consequences.
1. One function may have different dependencies for different input arguments. Let’s look at the following example:
--drop table (more...)
Oracle Magazine January-February 2012: Flash versionHTML version
is on the 17th place TIOBE Index
It's was 32nd in February last year (February 2011)!
In 2008 and 2007 in February it was in 13th position in the index.
Quest Software released
the 6.6 version of SQL Navigator. Mainly it corrects some bugs
The most usefull new feature is in the history search (where you can search the runned scripts/commands for an expression) to filter the commands by type.
Check the Release Notes
and the Known Issues List
is on the 14th place TIOBE Index
It's was 23st in November last year.
It was in 13th in 2008 and 2007 in the same month!
Oracle Magazine November-December 2011: Flash versionHTML version
jumped to the 12nd placeTIOBE Index
It's was 20st in November last year.
The site samplecode.oracle.com was decommissioned recently. I was hosting a number of projects there including “Logger”, my PL/SQL instrumentation package. Until I find a new home, here’s a temporary link to the latest release (1.4) or if you just want to view the readme use this link. I’ll update this post when I decide on [...]
Oracle Database 11g Release 2 Express Edition (Oracle Database XE) final version is available. It's "an entry-level, small-footprint database based on the Oracle Database 11g Release 2 code base. It's free to develop, deploy, and distribute; fast to download; and simple to administer." DownloadDocumentation
Do not forget to check the Open Bugs and Known Issues
is again in the 22nd place TIOBE Index
It's was in 21st last month.
Quest Software site has recently make available a new section in its website called QuestTV
with several videos about its services and products. Some of these videos are also available in Quest Software Channel in YouTube
Most interesting videos for PL/SQL developers:
Using Toad for Oracle with Oracle Instant Client (this series is helpful even for people that do not use TOAD but want to install and configure Oracle Instant Client.
Steven Feuerstein (renowned PL/SQL (more...)
A couple of weeks ago we talked about Flash on Android via Oracle APEX. Today let’s check the competitor’s offer. Unfortunately Apple products don’t support Flash. The good news however is that they do support SVG, as do most web browsers (IE7/8 is pluginable and IE9 is going to support it properly). I first came [...]
In my previous blog
post I explained how to call a database procedure using only a few lines of Java code. I already hinted that it is possible to use custom types and tables, etc. Let's see an example of that in more detail.
Suppose we have the (more...)
I mentioned a while ago that this book was nearing completion but I have just been advised that it has now been published.
You can get the full description and buy a copy here…
Oracle Application Express 3.2 – The Essentials and More
Well done Matthew and Arie!
In this post I will demonstrate how to extract plain text from Microsoft Open Office XML Format (DOCX) documents stored as a BLOB data type in an Oracle database. It is part one of two posts concerning how to extract and index unstructured content stored in DOCX files. I found (more...)
Recently I was developing an oracle database application and had the requirement to send out an email with an attachment. Initially it sounded pretty easy. I’ll just use the APEX_MAIL package and its all handled for me. But then I remembered, this was not an APEX application I was developing. So then I thought, no problem, I’ll just use the UTL_MAIL package. There is an API to add attachments. But wait, you can only add VARCHAR and RAW attachments and there is a max length of 32K on them. Not very useful if you want to send a multi-megabyte document (more...)
Like many other languages, PL/SQL has its own "dot notation". If we assume that most people can intuit or easily look up things like the syntax for '''IF/THEN/ELSIF''', that means that first-timer users might quickly run into dots and want to understand their significance.The authoritative docs on the dots is in the Oracle Database 11g PL/SQL Language Reference, in particular Appendix B, How PL/