<?xml version="1.0" encoding="UTF-8"?><!-- generator="WordPress/2.9" -->
<rss version="0.92">
<channel>
	<title>Radino's blog</title>
	<link>http://radino.eu</link>
	<description>Focusing on interesting SQL and PL/SQL problems</description>
	<lastBuildDate>Mon, 12 Jan 2009 09:43:20 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	
	<item>
		<title>Parsing CSV string</title>
		<description><![CDATA[Parsing a CSV string is something very trivial, but often many people choose an inefficient approach usually based on this pseudo-code:
loop
  if the CSV list is empty then break
  copy the first value to some variable
  remove the first value from the CSV list
end loop

There&#8217;s lots of unnecessary work hidden in the [...]]]></description>
		<link>http://radino.eu/2009/01/01/parsing-csv-list/</link>
			</item>
	<item>
		<title>How to implement sleeping</title>
		<description><![CDATA[There are few approaches how to implement sleeping in PL/SQL:

DBMS_LOCK.SLEEP procedure (precision: hundredths of a second)
DBMS_BACKUP_RESTORE.SLEEP (precision: seconds)
java.lang.Thread.sleep method mapped by PL/SQL procedure (precision: milliseconds)
Autonomous transaction (In fact, this Tanel&#8217;s post inspired me to write this) (precision: seconds)

Of course, I belive there are some other aproaches.
Using DBMS_LOCK has some disadvantages. DBMS_LOCK is a powerful package. [...]]]></description>
		<link>http://radino.eu/2008/12/25/how-to-implement-sleeping/</link>
			</item>
	<item>
		<title>Rafting in Čuňovo 2004/09</title>
		<description><![CDATA[
]]></description>
		<link>http://radino.eu/2008/10/04/rafting-in-cunovo-200409/</link>
			</item>
	<item>
		<title>High Tatras 2008/08</title>
		<description><![CDATA[I will add some description, soon.
]]></description>
		<link>http://radino.eu/2008/09/01/tatry-200808/</link>
			</item>
	<item>
		<title>Bitwise OR Aggregate Function</title>
		<description><![CDATA[A few months ago I was working on an application which used bits to store some flags in one number. In this approach the bit value in the number indicates whether a flag is on (1) or off (0). In my case a flag was tied with a column of a front-end table. If the [...]]]></description>
		<link>http://radino.eu/2008/05/31/bitwise-or-aggregate-function/</link>
			</item>
	<item>
		<title>SimpleFlickr Plugin</title>
		<description><![CDATA[I&#8217;ve already installed the SimpleFickr plug-in for WordPress.
Here is a sample gallery:
UPDATE (31st May 2008):
 I&#8217;ve uninstalled SimpleFickr plug-in, because I decided to not pay Flickr pro account.
I&#8217;ll use NextGen Gallery for my pictures.
]]></description>
		<link>http://radino.eu/2008/05/08/simpleflickr-plugin/</link>
			</item>
	<item>
		<title>First Post</title>
		<description><![CDATA[So, this is my first post and I hope not the last one  . I&#8217;m going to share some knowledge and experience here. I&#8217;m not going to post regularly, but I hope you will enjoy my posts.
The main topic will be Oracle database &#8211; database administration, PL/SQL and SQL snippets of interesting problems. I&#8217;m [...]]]></description>
		<link>http://radino.eu/2008/05/04/hello-world/</link>
			</item>
</channel>
</rss>
