Home » RDBMS Server » Server Administration » SELECT without FROM in Oracle 8
SELECT without FROM in Oracle 8 [message #371020] Wed, 09 August 2000 09:34 Go to next message
Reuben Allott
Messages: 1
Registered: August 2000
Junior Member
In MS SQL Server one can return a single row in a procedure by simply using:

SELECT Val1 as Col1, Val2 as Col2, Val3 as Col3...etc

How is this done on Oracle?

Thanks
Reuben Allott
Re: SELECT without FROM in Oracle 8 [message #371021 is a reply to message #371020] Wed, 09 August 2000 11:11 Go to previous message
Geraldo Viana de Paula Ju
Messages: 8
Registered: August 2000
Junior Member
Look at this: select 'Laurent' name, to_number('29') age, to_date('04-04-1964','dd-mm-yyyy') birthday from dual;

When you want create a select list from no table, just the list, you must use the public table "dual" that returns only one row. It's not possible in Oracle terms, to make a select without a table. But this feature is not bad at all.
Previous Topic: Re: How to find the 4th maximum sal?
Next Topic: ORA-0600 [12333]
Goto Forum:
  


Current Time: Fri Oct 30 03:24:54 CDT 2020