<div style="margin: 12px 0px; font-family: arial; color: #333333; background: #ffffff; border: solid 4px #e5e5e5; width: 100%; clear: left;"><div class="CM_CTB_Content_Wrap" style="margin: 0px; padding: 0px;background-color: #ffffff;"><div style="border-bottom: solid 1px #dcdcdc; white-space: nowrap; margin-bottom: 8px; background-color: #eeeeee ;background-image: url(http://clipmarks.com/images/source-bg.gif); background-repeat: repeat-x; height: 24px; line-height: 24px; vertical-align: middle; padding-bottom: 4px; color: #666666; font-size: 10px;" ><a href="http://clipmarks.com/clip-to-blog/" title="see clips that are hot right now"><img src="http://content.clipmarks.com/blog_embed/50b11cc1-cd9c-41c8-b9e5-228c22624850/5EBFA03D-04DA-4D9A-9634-D66BFA595987/" alt="" width="19" height="19" border="0" style="vertical-align: middle; margin: 0px 4px; display: inline; border: none; float:none;" /></a>clipped from <a title="http://www.shift-the-oracle.com/sql/structured-query-language.html" href="http://www.shift-the-oracle.com/sql/structured-query-language.html" style="font-size: 11px;">www.shift-the-oracle.com</a></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.shift-the-oracle.com/sql/structured-query-language.html"><H3 id="content_1_1">データ定義言語 / DDL (Data Definition Language） <A id="DDL" class="anchor"></A></H3></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.shift-the-oracle.com/sql/structured-query-language.html"><BLOCKQUOTE><P class="quotation">DDL コマンド一覧</P></BLOCKQUOTE> <UL class="list1"><li style="margin-left:16px;padding-left: 0px;">ALTER ～ すべて (＝セッション、システム制御文を含むかどうかわかりません)</LI> <li style="margin-left:16px;padding-left: 0px;">ANALYZE</LI> <li style="margin-left:16px;padding-left: 0px;">ASSOCIATE STATISTICS / DISASSOCIATE STATISTICS</LI> <li style="margin-left:16px;padding-left: 0px;">AUDIT</LI> <li style="margin-left:16px;padding-left: 0px;"><DIV>COMMENT </DIV> <BR /></LI> <li style="margin-left:16px;padding-left: 0px;">CREATE ～ すべて</LI> <li style="margin-left:16px;padding-left: 0px;">DROP ～ すべて</LI> <li style="margin-left:16px;padding-left: 0px;">TRUNCATE</LI> <li style="margin-left:16px;padding-left: 0px;">FLASHBACK ～ すべて</LI> <li style="margin-left:16px;padding-left: 0px;">PURGE</LI> <li style="margin-left:16px;padding-left: 0px;"><DIV>RENAME </DIV> <BR /></LI> <li style="margin-left:16px;padding-left: 0px;">GRANT</LI> <li style="margin-left:16px;padding-left: 0px;">REVOKE</LI> <li style="margin-left:16px;padding-left: 0px;">NOAUDIT</LI></UL></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.shift-the-oracle.com/sql/structured-query-language.html"><H3 id="content_1_2">データ操作言語 / DML (Data Manipulation Language） <A id="DML" class="anchor"></A></H3></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.shift-the-oracle.com/sql/structured-query-language.html"><BLOCKQUOTE><P class="quotation">DML コマンド一覧</P></BLOCKQUOTE> <UL class="list1"><li style="margin-left:16px;padding-left: 0px;"><A title="SELECT " href="http://www.shift-the-oracle.com/sql/select.html">SELECT (≠ Manipulate)</A> ／ <A title="SELECT FOR UPDATE " href="http://www.shift-the-oracle.com/sql/select-for-update.html">SELECT FOR UPDATE</A></LI> <li style="margin-left:16px;padding-left: 0px;"><A title="INSERT " href="http://www.shift-the-oracle.com/sql/insert.html">INSERT</A></LI> <li style="margin-left:16px;padding-left: 0px;"><A title="DELETE " href="http://www.shift-the-oracle.com/sql/delete.html">DELETE</A></LI> <li style="margin-left:16px;padding-left: 0px;"><A title="UPDATE " href="http://www.shift-the-oracle.com/sql/update.html">UPDATE</A></LI> <li style="margin-left:16px;padding-left: 0px;"><A title="MERGE " href="http://www.shift-the-oracle.com/sql/merge.html">MERGE <IMG title="Oracle 9i" alt="Oracle 9i" src="http://image.shift-the-oracle.com/9i.png" /></A> <BR /></LI> <li style="margin-left:16px;padding-left: 0px;">CALL</LI> <li style="margin-left:16px;padding-left: 0px;"><DIV>LOCK TABLE </DIV> <BR /></LI> <li style="margin-left:16px;padding-left: 0px;"><A title="EXPLAIN PLAN " href="http://www.shift-the-oracle.com/sql/explain-plan.html">EXPLAIN PLAN</A></LI></UL></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.shift-the-oracle.com/sql/structured-query-language.html"><H3 id="content_1_3">データ制御言語 / DCL (Data Control Language) <A id="DCL" class="anchor"></A></H3></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.shift-the-oracle.com/sql/structured-query-language.html">マニュアルにおいて DCL という文言は（おそらく）存在していない。</blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.shift-the-oracle.com/sql/structured-query-language.html">「美しくない」＆「後追いの標準化によって面倒」</blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.shift-the-oracle.com/sql/structured-query-language.html"><H4 id="content_1_4">トランザクション制御文 <A id="TRANSACTION" class="anchor"></A></H4></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.shift-the-oracle.com/sql/structured-query-language.html"><BLOCKQUOTE><P class="quotation"><A title="トランザクション " href="http://www.shift-the-oracle.com/transaction/">トランザクション</A>制御文 ＝ 一般的に DCL に含まれているもの。</P></BLOCKQUOTE> <UL class="list1"><li style="margin-left:16px;padding-left: 0px;">COMMIT</LI> <li style="margin-left:16px;padding-left: 0px;">ROLLBACK</LI> <li style="margin-left:16px;padding-left: 0px;">SET TRANSACTION</LI> <li style="margin-left:16px;padding-left: 0px;">SAVEPOINT</LI></UL></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.shift-the-oracle.com/sql/structured-query-language.html"><H3 id="content_1_5">セッション制御文 ( ALTER SESSION / SET ROLE ) <A id="SESSION" class="anchor"></A></H3></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.shift-the-oracle.com/sql/structured-query-language.html"><P class="quotation">セッションのプロパティを設定する。(暗黙コミットは発生しない)</P></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.shift-the-oracle.com/sql/structured-query-language.html">ALTER SESSION </blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.shift-the-oracle.com/sql/structured-query-language.html"><H3 id="content_1_6">システム制御文 ( ALTER SYSTEM ) <A id="SYSTEM" class="anchor"></A></H3></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.shift-the-oracle.com/sql/structured-query-language.html">ALTER SYSTEM </blockquote></div><div style="margin: 0px 6px 6px 4px;"><table style="font-size: 11px;border-spacing: 0px;padding: 0px;" cellpadding="0" cellspacing="0" width="100%"><tr><td style="background:transparent;border-width:0px;padding:0px;">&nbsp;</td><td align="right" style="background:transparent;border-width:0px;padding:0px;width:107px" width="107"><a href="http://clipmarks.com/share/5EBFA03D-04DA-4D9A-9634-D66BFA595987/blog/" title="blog or email this clip"><img src="http://content9.clipmarks.com/images/c2b-foot.png" border="0" alt="blog it" width="107" height="17" style="border-width:0px;padding:0px;margin:0px;" /></a></td></tr></table></div></div>

New from the makers of Clipmarks:  Amplify.com - Don't just share the news...Amplify it!