<?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; SQL</title>
	<atom:link href="http://www.jaceksen.pl/wordpress/?cat=26&#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>JOINS</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4166</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4166#comments</comments>
		<pubDate>Wed, 07 May 2014 06:43:45 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Bez kategorii]]></category>
		<category><![CDATA[SQL]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4166</guid>
		<description><![CDATA[references = foreign key equijoin = inner join]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4166</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>regular expressions</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4144</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4144#comments</comments>
		<pubDate>Wed, 09 Apr 2014 12:34:01 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Programowanie]]></category>
		<category><![CDATA[SQL]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4144</guid>
		<description><![CDATA[http://docs.oracle.com/cd/E11882_01/appdev.112/e17125/adfns_regexp.htm#ADFNS232 Precedence: 1. Arithmetic (pemdas) 2. Concat 3. Comparisons 4. is null, like, between 5 not between 6. not equal 7. not 8. AND 9. OR]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4144</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>case decode</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4125</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4125#comments</comments>
		<pubDate>Wed, 12 Mar 2014 06:58:40 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[SQL]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4125</guid>
		<description><![CDATA[]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4125</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Oracle read consistency.</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4103</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4103#comments</comments>
		<pubDate>Tue, 04 Mar 2014 05:44:24 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Oracle]]></category>
		<category><![CDATA[Programowanie]]></category>
		<category><![CDATA[SQL]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4103</guid>
		<description><![CDATA[Read consistency is an automatic implementation. It keeps a partial copy of the database in the undo segments. The read-consistent image is constructed from the committed data in the table and the old data that is being changed and is not yet committed from the undo segment. When an insert, update, or delete operation is [...]]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4103</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>joins</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4044</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4044#comments</comments>
		<pubDate>Mon, 17 Feb 2014 05:30:08 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Bazy danych]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[Programowanie]]></category>
		<category><![CDATA[SQL]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4044</guid>
		<description><![CDATA[NATURAL JOIN INNER JOINS SELECT employee_id, last_name, department_name FROM hr.employees JOIN hr.departments USING (department_id) ; SELECT l.city, d.department_name FROM locations l JOIN departments d USING (location_id) WHERE location_id = 1400; SELF JOIN Sometimes you need to join a table to itself. To find the name of each employee’s manager, you need to join the EMPLOYEES [...]]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4044</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>group_by</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4035</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4035#comments</comments>
		<pubDate>Thu, 13 Feb 2014 05:57:10 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Bazy danych]]></category>
		<category><![CDATA[Programowanie]]></category>
		<category><![CDATA[SQL]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4035</guid>
		<description><![CDATA[group by AVG COUNT MAX MIN STDDEV SUM VARIANCE]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4035</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>NVL NULL, to_date, to_char</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4027</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4027#comments</comments>
		<pubDate>Wed, 12 Feb 2014 05:47:22 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Oracle]]></category>
		<category><![CDATA[SQL]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4027</guid>
		<description><![CDATA[to_char]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4027</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>SQL &#8211; duplicates</title>
		<link>http://www.jaceksen.pl/wordpress/?p=3470</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=3470#comments</comments>
		<pubDate>Wed, 23 Nov 2011 11:06:31 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[SQL]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=3470</guid>
		<description><![CDATA[Here&#8217;s a handy query for finding duplicates in a table. Suppose you want to find all email addresses in a table that exist more than once: SELECT email, COUNT(email) AS NumOccurrences FROM users GROUP BY email HAVING ( COUNT(email) &#62; 1 ) You could also use this technique to find rows that occur exactly once: [...]]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=3470</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>(SQL) select with translation table</title>
		<link>http://www.jaceksen.pl/wordpress/?p=3373</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=3373#comments</comments>
		<pubDate>Tue, 18 Oct 2011 09:03:18 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Programowanie]]></category>
		<category><![CDATA[SQL]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=3373</guid>
		<description><![CDATA[CREATE TABLE HR.JS_TAB1(MIASTO VARCHAR2(20), ULICA VARCHAR2(20)); SELECT * FROM HR.JS_TAB1; CREATE TABLE HR.JS_TRANS1(ULICA_Z VARCHAR2(30), ULICA_NA VARCHAR(30)); SELECT * FROM HR.JS_TRANS1; INSERT INTO HR.JS_TAB1 VALUES(&#8216;GDYNIA&#8217;,'NAGIETKOWA&#8217;); INSERT INTO HR.JS_TAB1 VALUES(&#8216;GDYNIA&#8217;,'SWIETOJANSKA&#8217;); INSERT INTO HR.JS_TAB1 VALUES(&#8216;GDANSK&#8217;,'KOLOBRZESKA&#8217;); INSERT INTO HR.JS_TAB1 VALUES(&#8216;GDANSK&#8217;,'MALBORSKA&#8217;); INSERT INTO HR.JS_TRANS1 VALUES (&#8216;KOLOBRZESKA&#8217;,'CHLOPSKA&#8217;); INSERT INTO HR.JS_TRANS1 VALUES (&#8216;SWIETOJANSKA&#8217;,'WLADYSLAWA IV&#8217;); SELECT MIASTO, ULICA FROM HR.JS_TAB1; SELECT MIASTO, Nvl((SELECT [...]]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=3373</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Oracle notes &#8211; PL/SQL basics</title>
		<link>http://www.jaceksen.pl/wordpress/?p=1552</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=1552#comments</comments>
		<pubDate>Tue, 28 Dec 2010 11:16:39 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Bazy danych]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[PL/SQL]]></category>
		<category><![CDATA[SQL]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=1552</guid>
		<description><![CDATA[PL/SQL Procedural Language SQL anonymous blocks &#8211; bez nazwy procedures/functions &#8211; stored in data dictionary packages &#8211; zgrupowane procedury i funkcje Data Types - scalar (binary_integer, integer, string &#8230;) - composite (nested tables, varrays, record &#8230;) r employees%rowtype; nested tables of numbers: TYPE &#8211; określamy jakiego jest typu linia 5 &#8211; konstruktor &#8211;  przypisujemy konstruktor [...]]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=1552</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Oracle notki, constraints, sequences, views</title>
		<link>http://www.jaceksen.pl/wordpress/?p=1540</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=1540#comments</comments>
		<pubDate>Tue, 28 Dec 2010 10:56:26 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Bazy danych]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[PL/SQL]]></category>
		<category><![CDATA[SQL]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=1540</guid>
		<description><![CDATA[alter table person add constraint pk_person primary key(id); compound primary key &#8211; złożony &#8211; na więcej niż jednej kolumnie. create table citeis(city varchar(30), state char2(2), constraint pk_cities primary key(city,state)); obydwie kolumny będą widziane jako NOT NULL &#8211; ale to wcale nie znaczy że są primary_keys select * from USER_CONSTRAINTS; select * from DBA_CONSTRAINTS; aby dowiedzieć [...]]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=1540</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Oracle notki &#8211; installation.</title>
		<link>http://www.jaceksen.pl/wordpress/?p=1530</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=1530#comments</comments>
		<pubDate>Tue, 28 Dec 2010 10:29:22 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Bazy danych]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[PL/SQL]]></category>
		<category><![CDATA[SQL]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=1530</guid>
		<description><![CDATA[database configuration assistant: c:&#62; dbca (w windowsach) aby zapisać konfigurację bazy danych w windowsach i ewentualnie puszczać tworzenie instancji automatycznie: c:\database&#62; setup -record -destinationFile c:\database\basic.rsp (jest to tzw. response file) uruchomi się instaler, ale na samym końcu nie nalży instalować tylko dać cancel potem: c:\database&#62; setup -silent -responseFile c:\\database\basic.rsp tworzenie bazy danych od podstaw: najpierw [...]]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=1530</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Oracle &#8211; notki, SQL, PL/SQL</title>
		<link>http://www.jaceksen.pl/wordpress/?p=1524</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=1524#comments</comments>
		<pubDate>Tue, 28 Dec 2010 10:16:42 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Bazy danych]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[PL/SQL]]></category>
		<category><![CDATA[Programowanie]]></category>
		<category><![CDATA[SQL]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=1524</guid>
		<description><![CDATA[sql&#62; host &#8211; aby dostać się do promptu hosta c:&#62; echo %oracle_sid% lub echo $oracle_sid$ c:&#62; exit sql&#62; po zalaogowaniu można wydać komendę: sql&#62; define i wyświetlą się parametry informujące o tym jako kto jesteśmy podłączeni będąc podłączonym można podłączyć się jako inny user sql&#62; connect sys as sysdba Sprawdzenie jakie tabele są w schemacie [...]]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=1524</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
	</channel>
</rss>
