Difference between revisions of "Issue queries"

Latest revision as of 09:56, 8 August 2012

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 information.

schema:scott

Only certain functions can be used without a table and these functions are called static functions.

Static functions can allow a user to obtain the current username, current date, current timestamp and also the version of the database being used.

SELECT CURRENT_USER, CURRENT_DATE

SELECT USER, CURRENT_DATE FROM dual

SELECT SYSTEM_USER, GETDATE()

SELECT ENVIRON('username'), DATE()

@@ 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>
-causes the response speed of the query to slow down.
 <div class='ht'>
 <div class=params>schema:scott</div>