HTML code for sharing source code

Log in

04 May 2009

← Back to dump

HTML Copy To Clipboarddone!

<div class="highlight" style="background: #f8f8f8"><pre style="line-height: 125%"><div id="lc1"><span style="color: #008000; font-weight: bold">SELECT</span> billing.personal_account(conn.client_id, conn.conn_id), to_char(conn.stage_date, <span style="color: #BA2121">&#39;DD.MM.YYYY&#39;</span>), ct.conn_values <span style="color: #008000; font-weight: bold">AS</span> connection_date
</div><div id="lc2"><span style="color: #008000; font-weight: bold">FROM</span> billing.connections <span style="color: #008000; font-weight: bold">AS</span> conn, billing.conn_templ <span style="color: #008000; font-weight: bold">AS</span> ct
</div><div id="lc3"><span style="color: #008000; font-weight: bold">WHERE</span> conn.current_stage <span style="color: #666666">=</span> <span style="color: #666666">25</span> <span style="color: #008000; font-weight: bold">AND</span> ct.conn_id <span style="color: #666666">=</span> conn.conn_id <span style="color: #008000; font-weight: bold">AND</span> ct.res_code <span style="color: #666666">=</span> <span style="color: #BA2121">&#39;DATESTART&#39;</span>;
</div></pre></div>
<p style="padding: 0; margin: 2em 0 1em 0; font-size: 0.8em; color: #666;"><span style="padding: 0 1em; background-color: #f5f5f5;"> Colored with <a style="color: #333" href="http://dumpz.org">dumpz.org</a></span></p>

BBCODE Copy To Clipboarddone!

Light HTML Copy To Clipboarddone!

That method generates HTML with CSS classes. Hence you'll need the style sheet file

<div class="highlight"><pre><div id="lc1"><span class="k">SELECT</span> <span class="n">billing</span><span class="p">.</span><span class="n">personal_account</span><span class="p">(</span><span class="n">conn</span><span class="p">.</span><span class="n">client_id</span><span class="p">,</span> <span class="n">conn</span><span class="p">.</span><span class="n">conn_id</span><span class="p">),</span> <span class="n">to_char</span><span class="p">(</span><span class="n">conn</span><span class="p">.</span><span class="n">stage_date</span><span class="p">,</span> <span class="s1">&#39;DD.MM.YYYY&#39;</span><span class="p">),</span> <span class="n">ct</span><span class="p">.</span><span class="n">conn_values</span> <span class="k">AS</span> <span class="n">connection_date</span>
</div><div id="lc2"><span class="k">FROM</span> <span class="n">billing</span><span class="p">.</span><span class="n">connections</span> <span class="k">AS</span> <span class="n">conn</span><span class="p">,</span> <span class="n">billing</span><span class="p">.</span><span class="n">conn_templ</span> <span class="k">AS</span> <span class="n">ct</span>
</div><div id="lc3"><span class="k">WHERE</span> <span class="n">conn</span><span class="p">.</span><span class="n">current_stage</span> <span class="o">=</span> <span class="mi">25</span> <span class="k">AND</span> <span class="n">ct</span><span class="p">.</span><span class="n">conn_id</span> <span class="o">=</span> <span class="n">conn</span><span class="p">.</span><span class="n">conn_id</span> <span class="k">AND</span> <span class="n">ct</span><span class="p">.</span><span class="n">res_code</span> <span class="o">=</span> <span class="s1">&#39;DATESTART&#39;</span><span class="p">;</span>
</div></pre></div>
<p style="padding: 0; margin: 2em 0 1em 0; font-size: 0.8em; color: #666;"><span style="padding: 0 1em; background-color: #f5f5f5;"> Colored with <a style="color: #333" href="http://dumpz.org">dumpz.org</a></span></p>

Habrahabr.ru HTML Copy To Clipboarddone!

Use that HTML for publications on habrahabr.ru

<blockquote><code><font color="#008000"><strong>SELECT</strong></font>&nbsp;billing.personal_account(conn.client_id,&nbsp;conn.conn_id),&nbsp;to_char(conn.stage_date,&nbsp;<font color="#BA2121">&#39;DD.MM.YYYY&#39;</font>),&nbsp;ct.conn_values&nbsp;<font color="#008000"><strong>AS</strong></font>&nbsp;connection_date
<font color="#008000"><strong>FROM</strong></font>&nbsp;billing.connections&nbsp;<font color="#008000"><strong>AS</strong></font>&nbsp;conn,&nbsp;billing.conn_templ&nbsp;<font color="#008000"><strong>AS</strong></font>&nbsp;ct
<font color="#008000"><strong>WHERE</strong></font>&nbsp;conn.current_stage&nbsp;<font color="#666666">=</font>&nbsp;<font color="#666666">25</font>&nbsp;<font color="#008000"><strong>AND</strong></font>&nbsp;ct.conn_id&nbsp;<font color="#666666">=</font>&nbsp;conn.conn_id&nbsp;<font color="#008000"><strong>AND</strong></font>&nbsp;ct.res_code&nbsp;<font color="#666666">=</font>&nbsp;<font color="#BA2121">&#39;DATESTART&#39;</font>;
</code></blockquote><p><font color="gray">Colored with <a href="http://dumpz.org">dumpz.org</a></p>