Oracle- SELECT statement

[drkestrel]

With some other DB, something like

SELECT 'something'

would output the word something into server buffer.

This is not allowed in Oralce. Is it true I could use something like

SELECT something INTO ACONSTANT

to do this? If so, what's the constant.

I would rather not use

dbms_output.put_line()

as it makes the buffer rather ugly!

 

[stevecal]

Try this for size

Select 'something' from dual;

 

[drkestrel]

That's Cool

Select 'value' from Dual;

returns

'VALU
-----
value

One more tiny cosmetic thing though, can I get rid of the Column heading??

Column 'value' heading '';

doesn't work!

 

[nontrad]

before your select statement write

set heading off ( I don't think a ; is required)

This will turn off the printing of column headings