Error with this Oracle 10g Express Edition query

220 pts.
Tags:
Oracle 10g
Oracle 10g administration
Oracle 10g Express
Oracle 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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following