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.
This week I attended a webinar by Cary Millsap, organized by Red Gate. It was called "Real Developers DO use Tools" and was focussed on, well, tools. At the end of Cary's talk, James Murtagh showed a demo of their Schema Compare tool. The demo wasn't flawless, but he recovered nicely :) (note to self: don't do live demo's). And this - the demo, not the occuring error - triggered a memory that I wanted to write a blog on the Schema Compare tool.If you missed the webinar you can find it on the website of Red Gate here: (more...)
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
I've been asked by one of my architects whether there is a quick way of see a list of file existing in the random folder on the server. The first response was - NO, because all file system communication should go via DIRECTORY object (starting 10g).
But I recalled that (more...)
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.
, or more properly NTLMSSP
is a protocol used on Microsoft Windows system as part of the so-called Integrated Windows Authentication
Integrated Windows Authentication is also known as HTTP Negotiate authentication, NT Authentication, NTLM Authentication, Domain authentication, Windows Integrated Authentication, Windows NT Challenge/Response authentication, or simply Windows Authentication.
In Microsoft Internet Information Server (IIS), the system administrator can protect a website or folder with "Integrated Windows Authentication". When you browse to this website or folder, you must enter your Windows (domain) username and password to get access (although Internet Explorer will, depending on your security settings, send your credentials (more...)
I've just uploaded a new version
of the Alexandria Utility Library for PL/SQL
Updates include both small bug fixes and some major new features (which I'll return to in another post).
Among the improvements are:
- Additional functions in OOXML_UTIL_PKG for working with Excel 2007 and Powerpoint 2007 files.
- Kris Scorup has contributed improved CSV parsing to the CSV_UTIL_PKG. It now handles double quotes and separator characters inside strings.
- Anton Scheffer's packages for building PDF and XLSX files have been included in the library.
- The PL_FPDF library by Pierre-Gilles Levallois is a port of the FPDF library for PHP. Pierre-Gilles Levallois (more...)
These days, the use of database stored procedures is regarded by many as a bad practice
Those that dislike stored procedures tend to regard them as incompatible with the three-tier architecture
By breaking up an application into tiers, developers only have to modify or add a specific layer, rather than have to rewrite the entire application over. There should be a presentation tier, a business or data access tier, and a data tier.
This is illustrated as follows:
Note that the "tiers" in the figure should actually be labelled "layers", for as the accompanying Wikipedia article says:
The concepts (more...)
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...)
is again in the 21st place TIOBE Index
It's was in 22nd last month.
Amazon S3 is part of Amazon's Web Service offering and the name is an abbreviation for Simple Storage Service
"Amazon S3 provides a simple web services interface that can be used to store and retrieve any amount of data, at any time, from anywhere on the web. It gives any developer access to the same highly scalable, reliable, secure, fast, inexpensive infrastructure that Amazon uses to run its own global network of web sites. The service aims to maximize benefits of scale and to pass those benefits on to developers."
A few months ago, Jason Straub
published an (more...)