Generate rows - Revision history

Connor: Created page with "
Here you are shown how to generate rows without the use of tables

schema:scott

2012-08-08T14:34:19Z

Created page with "<p>Here you are shown how to generate rows without the use of tables</p> <div class='ht'> <div class=params>schema:scott</div> <source lang=sql class='tidy'></source> <source ..."

New page
<p>Here you are shown how to generate rows without the use of tables</p>
<div class='ht'>
<div class=params>schema:scott</div>
<source lang=sql class='tidy'></source>
<source lang=sql class='setup'></source>
<div>
<p>You can use single value <code>SELECT</code> to generate tables</p>
<p>You can use them when you need a small table for your query but
you don't have permission to create tables in the database itself.</p>
</div>
<source lang='sql' class='def'>
SELECT x centigrade, x9/5+32 fahrenheit
FROM (SELECT 0 x UNION SELECT 10 UNION SELECT 20
UNION SELECT 30 UNION SELECT 40) t</source>
<source lang='sql' class='def e-oracle'>
SELECT x centigrade, x9/5+32 fahrenheit
FROM ( SELECT 0 x FROM dual
UNION SELECT 10 FROM dual
UNION SELECT 20 FROM dual</source>
UNION SELECT 30 FROM dual
UNION SELECT 40 FROM dual) t
<div class="ecomm e-oracle" style="display: none">In oracle you can not miss the <code>FROM</code> in a query so therefore
FROM dual has to be used.</div>
</div>

{{Hacks Ref}}