{"id":7,"date":"2009-03-27T15:06:35","date_gmt":"2009-03-27T14:06:35","guid":{"rendered":"http:\/\/hslomka.de\/techno\/?p=7"},"modified":"2009-03-27T15:06:35","modified_gmt":"2009-03-27T14:06:35","slug":"sqlplus-variablen-definieren-und-verwenden","status":"publish","type":"post","link":"https:\/\/techno.slomka.biz\/?p=7","title":{"rendered":"SQL*Plus Variablen definieren und verwenden"},"content":{"rendered":"<p>Um SQL Statements dynamischer zu gestalten, sind oft Abfragen zu generieren, deren Wert von einer Variablen abh\u00e4ngen. In SQL werden Variablen \u00fcber das Kommando <i>DEFINE<\/i> definiert und mit <i>&amp;VARIABLE<\/i> abgefragt.<\/p>\n<p><em>SQL Statements:<\/em><br \/>\n<code><br \/>\nSET VERIFY OFF<br \/>\ndefine col=TABLESPACE_NAME<br \/>\nselect &amp;col from dba_tablespaces;<br \/>\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Um SQL Statements dynamischer zu gestalten, sind oft Abfragen zu generieren, deren Wert von einer Variablen abh\u00e4ngen. In SQL werden Variablen \u00fcber das Kommando DEFINE definiert und mit &amp;VARIABLE abgefragt. SQL Statements: SET VERIFY OFF define col=TABLESPACE_NAME select &amp;col from dba_tablespaces;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12,13,18],"tags":[86,92,93],"class_list":["post-7","post","type-post","status-publish","format-standard","hentry","category-oracle","category-oracle-datenbank","category-shell-scripting","tag-script","tag-sql","tag-sqlplus"],"_links":{"self":[{"href":"https:\/\/techno.slomka.biz\/index.php?rest_route=\/wp\/v2\/posts\/7","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/techno.slomka.biz\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/techno.slomka.biz\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/techno.slomka.biz\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/techno.slomka.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7"}],"version-history":[{"count":0,"href":"https:\/\/techno.slomka.biz\/index.php?rest_route=\/wp\/v2\/posts\/7\/revisions"}],"wp:attachment":[{"href":"https:\/\/techno.slomka.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techno.slomka.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techno.slomka.biz\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}