Connor at 08:56, 8 August 2012

2012-08-08T08:56:11Z

Connor: Created page with "
Here you are shown how to issue queries without using a table.

This is done in different ways across different platforms but all of them will give a single row of in..."

2012-08-08T08:52:44Z

Created page with "<p>Here you are shown how to issue queries without using a table.</p> <p>This is done in different ways across different platforms but all of them will give a single row of in..."

New page

<p>Here you are shown how to issue queries without using a table.</p>
<p>This is done in different ways across different platforms but all of them will give a single row of information.</p>
causes the response speed of the query to slow down.
<div class='ht'>
<div class=params>schema:scott</div>
<source lang=sql class='tidy'></source>
<source lang=sql class='setup'></source>
<div>
<p>Only certain functions can be used without a table and these functions are called static functions.</p>
<p>Static functions can allow a user to obtain the current username, current date, current timestamp and also the version of the database being used.</p>
</div>
<source lang='sql' class='def'>SELECT CURRENT_USER, CURRENT_DATE</source>
<source lang='sql' class='def e-oracle'>SELECT USER, CURRENT_DATE FROM dual</source>
<source lang='sql' class='def e-sqlserver'>SELECT SYSTEM_USER, GETDATE()</source>
<source lang='sql' class='def e-access'>SELECT ENVIRON('username'), Date()</source>

<div class="ecomm e-oracle" style="display: none">For oracle you can use:
SELECT USER, CURRENT_DATE, CURRENT_TIMESTAMP,
(SELECT banner FROM v$version WHERE ROWNUM = 1),
DBMS_RANDOM.RANDOM(), SYS_GUID()
FROM dual</div>
<div class="ecomm e-mysql" style="display: none">For mysql you can use:
SELECT CURRENT_USER, CURRENT_DATE, CURRENT_TIMESTAMP,
VERSION(), RAND(), UUID()</div>
<div class="ecomm e-sqlserver" style="display: none">For sqlserver you can use:
SELECT SYSTEM_USER, CAST(CAST(GetDate() AS INT) AS DATETIME),
GetDate(), @@VERSION, RAND(), NEWID()</div>
<div class="ecomm e-postgres" style="display: none">For postgres you can use:
SELECT CURRENT_USER, CURRENT_DATE, CURRENT_TIMESTAMP,
VERSION(), RANDOM()</div>
<div class="ecomm e-access" style="display: none">In access you have to create a new database,
then create a query in that database and then run the function given in the example in SQL view.
</div>
</div>

{{Hacks Ref}}

@@ Line 1: / Line 1: @@
 <p>Here you are shown how to issue queries without using a table.</p>
 <p>This is done in different ways across different platforms but all of them will give a single row of information.</p>
 <div class='ht'>
 <div class=params>schema:scott</div>

Issue queries - Revision history

Connor at 08:56, 8 August 2012

Connor: Created page with "Here you are shown how to issue queries without using a table. This is done in different ways across different platforms but all of them will give a single row of in..."

Connor: Created page with "
Here you are shown how to issue queries without using a table.

This is done in different ways across different platforms but all of them will give a single row of in..."