Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to change Line after select a column in sqlplus

elenadApr 2 2008 — edited Apr 14 2008
Hi all,
I would like to know how can I change line after a column in my query:
For Example:
Select
'begin' --change line
--empty line
'Employee Name: '||empname, -- change line
'Employee Number: '||empno, -- change line
'end ' --change line
--empty line

Thanks a lot for your prompt feedback
Regards
Elena
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 12 2008
Added on Apr 2 2008
13 comments
871 views