Subscribe: René Nyffenegger on Oracle
http://www.adp-gmbh.ch/rss.xml
Added By: Feedage Forager Feedage Grade B rated
Language: English
Tags:
creating  data oracle  data  emulating tables  emulating  file  function  importing data  joins inner  member  oracle  procedure  sql  tables 
Rate this Feed
Rate this feedRate this feedRate this feedRate this feedRate this feed
Rate this feed 1 starRate this feed 2 starRate this feed 3 starRate this feed 4 starRate this feed 5 star

Comments (0)

Feed Details and Statistics Feed Statistics
Preview: René Nyffenegger on Oracle

René Nyffenegger on Oracle



Hello! I am René Nyffenegger and this is the site where I write articles on Oracle. I hope that, if time permits and I am not on holidays, I can write at least one article per week.



Last Build Date: Sat, 14 Nov 2009 11:10:00 GMT

Copyright: Copyright 2005 René Nyffenegger
 



On DAO and ODBC with Oracle

Sat, 14 Nov 2009 11:10:00 GMT




On XML Queries

Thu, 08 Oct 2009 15:15:00 GMT







On including files in SQL*Plus

Sat, 15 Mar 2008 22:30:00 GMT




On setting commit_write

Tue, 11 Mar 2008 22:00:00 GMT







Jobs at ADP

Sun, 29 Jul 2007 19:00:00 GMT




Emulating tables with PL/SQL (Part III)

Sun, 22 April 2007 10:45:00 GMT




sprintf and printf in PL/SQL

Sat, 14 April 2007 08:15:00 GMT










On finding changed values in a table with flashback

Sun, 31 December 2006 11:45:00 GMT




On parametrizing views with contexts

Sat, 3 December 2006 13:10:00 GMT




On creating an AJAX Application with Oracle

Thu, 30 November 2006 9:10:00 GMT




Beware of NOT IN and NULLS

Wed, 29 November 2006 03:10:00 GMT







On generating HTML output with SQL*Plus

Sat, 19 August 2006 12:15:00 GMT




On out parameters

Sun, 13 August 2006 12:50:00 GMT




Comments, finally!

Sun, 04 June 2006 15:45:00 GMT







On solving workspace conflicts

Tue, 09 May 2006 23:15:00 GMT







On emulating tables with PL/SQL (Part II)

Fri, 24 Mar 2006 12:30:00 GMT




On reading trace files with PL/SQL

Sun, 05 Feb 2006 00:00:00 GMT




On a breakable Oracle

Tue, 24 Jan 2006 21:30:00 GMT




On emulating tables with nested tables

Sun, 8 Jan 2006 23:50:00 GMT







On comparing mulitple SQL statements' statistics

Mon, 26 Dec 2005 23:45:00 GMT







On triggers, sequences, autonumbers and failing inserts

Mon, 19 Dec 2005 23:30:00 GMT

Is a sequence increased when I use a trigger and a sequence to generate autonumbers and an insert fails?



On a table's first five rows

Sun, 11 Dec 2005 23:30:00 GMT

Using rownum to select the first n rows does not always return the same records



On identifiying "periods of activity"

Mon, 28 Nov 2005 22:50:00 GMT

I have a table that logs what items were bought at what time from a vending machine. Now, I want to find periods of activity on this machine.



On creating bitmaps with pure PL/SQL

Tue, 22 Nov 2005 23:40:00 GMT

Out of idle curiosity, I wanted to know if it is possible to create bitmaps (BMPs) with pure PL/SQL alone. And it is!



On reading blobs from and writing blobs to a file

Sun, 20 Nov 2005 23:30:00 GMT

Writing blobs to a file and reading them from a file is too tedious for my liking. Therefore, I have written a package to faciliate these tasks. It comes with a procedure (to_file) which writes a blob to a file, a function (from_file) which reads a file into a blob and returns it and a procedure(from_file) that copies a file into the blob passed as parameter.



On mixing outer joins with inner joins

Wed, 16 Nov 2005 23:15:00 GMT

A few ways to combine an outer joins with an inner join in a select statement.



On improving a better describe

Sat, 12 Nov 2005 13:55:00 GMT

Recently, I presented



On eliminating outliers in avg() queries

Fri, 4 Nov 2005 23:10:00 GMT







On storing hierachical data

Mon, 17 Oct 2005 23:30:00 GMT




On generating ERDs with desc_table and neato

Mon, 3 Oct 2005 21:45:00 GMT




On a better describe

Sun, 25 Sep 2005 21:15:00 GMT




On the missing product() aggregate function

Mon, 22 Sep 2005 21:50:00 GMT




On using dbms_utility.name_resolve

Mon, 19 Sep 2005 20:10:00 GMT




On solving a sudoku with Oracle

Tue, 06 Sep 2005 22:00:00 GMT

A



On a member function calling a member procedure

Sat, 30 Aug 2005 21:30:00 GMT

I was very surprised when I tried to call a member procedure from a member function because I got a PLS-00363: expression 'SELF' cannot be used as an assignment. Why this is and how to avoid this.



On an integer not always being an integer

Sat, 27 Aug 2005 10:19:10 GMT

Until recently, I believed that an integer is a number that can only store whole numbers. Unfortunately, that is not always the case with Oracle.



On max and group by

Mon, 22 Aug 2005 16:22:48 GMT

This article presents three different ways to group a select's result set and find each group's record whose column is max().






On storing objects in tables

Tue, 16 Aug 2005 20:03:30 GMT

In this article, I want to demonstrate how to achieve a parent-child relationship with PL/SQL objects stored in tables.



On tracking data changes in a table

Mon, 08 Aug 2005 23:52:14 GMT