SELECT without FROM in Oracle 8 [message #371020] |
Wed, 09 August 2000 09:34 |
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 |
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.
|
|
|