<?xml version="1.0" encoding="UTF-8"?><rss version="0.92">
<channel>
	<title>Beautiful Data</title>
	<link>http://perumal.org</link>
	<description>Data is a precious thing that lives forever.</description>
	<lastBuildDate>Fri, 16 Jul 2010 17:00:48 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	<!-- generator="WordPress/3.0" -->

	<item>
		<title>Row Source Operation: CREATE TABLE STATEMENT</title>
		<description><![CDATA[Description Operation denotes the creation of a table. Version This sample script developed and executed on SQL&#62; SELECT banner FROM v$version WHERE rownum = 1; BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi Script SQL&#62; CREATE TABLE old 2  ( 3  id NUMBER 4  ); Table created. SQL&#62; EXPLAIN PLAN FOR CREATE [...]]]></description>
		<link>http://perumal.org/row-source-operation-create-table-statement/</link>
			</item>
	<item>
		<title>Row Source Operation: INDEX BUILD NON UNIQUE</title>
		<description><![CDATA[Description Operation builds a non-unique index.  Version This sample script developed and executed on SQL&#62; SELECT banner FROM v$version WHERE rownum = 1; BANNER                                                                          ----------------------------------------------------------------                Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi                Script SQL&#62; CREATE TABLE t (id NUMBER); Table created. SQL&#62; EXPLAIN PLAN FOR CREATE INDEX t_id ON t(id); Explained. Execution Plan [...]]]></description>
		<link>http://perumal.org/row-source-operation-index-build-non-unique/</link>
			</item>
	<item>
		<title>Row Source Operation: CREATE INDEX STATEMENT</title>
		<description><![CDATA[Description Operation denotes the execution of create index statement.  Version This sample script developed and executed on SQL&#62; SELECT banner FROM v$version WHERE rownum = 1; BANNER                                                                          ----------------------------------------------------------------                Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi                Script SQL&#62; CREATE TABLE t (id NUMBER); Table created. SQL&#62; EXPLAIN PLAN FOR CREATE INDEX t_id ON t(id); [...]]]></description>
		<link>http://perumal.org/row-source-operation-create-index-statement/</link>
			</item>
	<item>
		<title>Row Source Operation: SORT CREATE INDEX</title>
		<description><![CDATA[Description Sort operation is performed during the creation of an index.  Version This sample script developed and executed on SQL&#62; SELECT banner FROM v$version WHERE rownum = 1; BANNER                                                                          ----------------------------------------------------------------                Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi                Script SQL&#62; CREATE TABLE t (n NUMBER, CONSTRAINT t_pk PRIMARY KEY (n)); Table created. SQL&#62; EXPLAIN [...]]]></description>
		<link>http://perumal.org/row-source-operation-sort-create-index/</link>
			</item>
	<item>
		<title>Row Source Operation: INDEX BUILD UNIQUE</title>
		<description><![CDATA[Description Operation builds an unique index.  Version This sample script developed and executed on SQL&#62; SELECT banner FROM v$version WHERE rownum = 1; BANNER                                                                          ----------------------------------------------------------------                Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi                Script SQL&#62; CREATE TABLE t (n NUMBER, CONSTRAINT t_pk PRIMARY KEY (n)); Table created. SQL&#62; EXPLAIN PLAN FOR ALTER INDEX t_pk [...]]]></description>
		<link>http://perumal.org/row-source-operation-index-build-unique/</link>
			</item>
	<item>
		<title>Row Source Operation: REMOTE</title>
		<description><![CDATA[Description Part of the statement is performed in a REMOTE database. Version This sample script developed and executed on SQL&#62; SELECT banner FROM v$version WHERE rownum = 1; BANNER                                                                          ----------------------------------------------------------------                Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi                 Script SQL&#62; CREATE TABLE t (id NUMBER, status VARCHAR2(1)); Table created. SQL&#62; CREATE DATABASE LINK rperumal_dblink   [...]]]></description>
		<link>http://perumal.org/row-source-operation-remote/</link>
			</item>
	<item>
		<title>Row Source Operation: MERGE STATEMENT REMOTE</title>
		<description><![CDATA[Description UPSERTs row(s) into a table in a remote database. Version This sample script developed and executed on SQL&#62; SELECT banner FROM v$version WHERE rownum = 1; BANNER                                                                          ----------------------------------------------------------------                Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi                 Script SQL&#62; CREATE TABLE t (id NUMBER, status VARCHAR2(1)); Table created. SQL&#62; CREATE TABLE q (id NUMBER, [...]]]></description>
		<link>http://perumal.org/row-source-operation-merge-statement-remote/</link>
			</item>
	<item>
		<title>Row Source Operation: MERGE STATEMENT</title>
		<description><![CDATA[Description UPSERTs row(s) into the table. Version This sample script developed and executed on SQL&#62; SELECT banner FROM v$version WHERE rownum = 1; BANNER                                                                          ----------------------------------------------------------------                Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi                 Script SQL&#62; CREATE TABLE t (id NUMBER, status VARCHAR2(1)); Table created. SQL&#62; CREATE TABLE q (id NUMBER, status VARCHAR2(1)); Table created. [...]]]></description>
		<link>http://perumal.org/row-source-operation-merge-statement/</link>
			</item>
	<item>
		<title>Row Source Operation: SELECT STATEMENT REMOTE</title>
		<description><![CDATA[Description SELECTs row(s) from the table on a remote database. Version This sample script developed and executed on SQL&#62; SELECT banner FROM v$version WHERE rownum = 1; BANNER                                                                          ----------------------------------------------------------------                Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi                 Script SQL&#62; CREATE DATABASE LINK rperumal_dblink   2       CONNECT TO rperumal IDENTIFIED BY rperumal   3       [...]]]></description>
		<link>http://perumal.org/row-source-operation-select-statement-remote/</link>
			</item>
	<item>
		<title>Row Source Operation: SELECT STATEMENT</title>
		<description><![CDATA[Description SELECTs row(s) from the table. Version This sample script developed and executed on SQL&#62; SELECT banner FROM v$version WHERE rownum = 1; BANNER                                                                          ----------------------------------------------------------------                Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi                 Script SQL&#62; CREATE TABLE t   2  (   3  id NUMBER   4  ); Table created. SQL&#62; EXPLAIN PLAN FOR [...]]]></description>
		<link>http://perumal.org/row-source-operation-select-statement/</link>
			</item>
</channel>
</rss>
