<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:wfw="http://wellformedweb.org/CommentAPI/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	xmlns:atom="http://www.w3.org/2005/Atom"
	xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
	xmlns:slash="http://purl.org/rss/1.0/modules/slash/"
	>

<channel>
	<title>Różności ... &#187; Skrypty SQL i PL/SQL</title>
	<atom:link href="http://www.jaceksen.pl/wordpress/?cat=28&#038;feed=rss2" rel="self" type="application/rss+xml" />
	<link>http://www.jaceksen.pl/wordpress</link>
	<description>czyli moje notki</description>
	<lastBuildDate>Sun, 14 Nov 2021 16:21:49 +0000</lastBuildDate>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
	<generator>http://wordpress.org/?v=3.0.3</generator>
		<item>
		<title>Using PL/SQL Loops and Control Structures</title>
		<link>http://www.jaceksen.pl/wordpress/?p=3596</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=3596#comments</comments>
		<pubDate>Wed, 22 Feb 2012 18:07:51 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[PL/SQL]]></category>
		<category><![CDATA[Programowanie]]></category>
		<category><![CDATA[Skrypty SQL i PL/SQL]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=3596</guid>
		<description><![CDATA[http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/controlstructures.htm]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=3596</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>PL/SQL &#8211; przykład prostych procedur</title>
		<link>http://www.jaceksen.pl/wordpress/?p=1727</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=1727#comments</comments>
		<pubDate>Fri, 31 Dec 2010 08:47:31 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Skrypty SQL i PL/SQL]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=1727</guid>
		<description><![CDATA[create or replace procedure sfis_owner.wsp_kwadratow(numer varchar) AS CURSOR id_obszaru IS select obsz_id from sfis_owner.fis_obszary where obsz_kod like numer&#124;&#124;'%' and obsz_rodzaj_obszaru='FAO'; BEGIN dbms_output.put_line('Podany numer ' &#124;&#124; numer); FOR rekord IN id_obszaru LOOP -- trzeba ustawic 'set serveroutput on' na kliencie dbms_output.put_line(rekord.obsz_id); END LOOP; END / DATA TYPE: composite (nested table of numbers): create or replace procedure [...]]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=1727</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Oracle &#8211; sesje użytkowników.</title>
		<link>http://www.jaceksen.pl/wordpress/?p=43</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=43#comments</comments>
		<pubDate>Thu, 23 Dec 2010 15:44:32 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Bazy danych]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[Skrypty SQL i PL/SQL]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=43</guid>
		<description><![CDATA[Aby wyświetlić aktywne sesje użytkowników w bazie danych Oracle: select b.Username, b.Osuser, b.Process, b.Machine, a.Spid, b.Program, b.Sid, b.Serial# from v$process a, v$session b where a.Addr = b.Paddr ORDER BY b.Machine /]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=43</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
	</channel>
</rss>
