Error with this Oracle 10g Express Edition query
SET HEADING OFF;
SELECT 'Song Name: ', S.TITLE
FROM SONG S
I don want to display heading in the result table. I need result like:
Song Name: Mungaru Male
Song Name: Titanic
Song Name: Milana
But the Statement "SET HEADING OFF;" results in a result
Software/Hardware used:
Oracle 10 g express edition
ASKED:
November 24, 2010 6:07 AM
UPDATED:
November 24, 2010 4:37 PM
Answer Wiki:
The question is not very clear.
You might want to try something like this:
<pre>SELECT 'Song Name: ' || s.title
FROM song s;</pre>
If this is not whay you need, or you are getting errors, please provide more details.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
