Oracle-sqlplus

Question

Hi All, I am using set colsep'|' in sqlplus.However,It appends the pipe(|) column-sperator in between two columns only not at the begining and the end of the column.Example-It give output like this- emp_name|emp_department|emp_salary

I want the out put like this(Append "|") in the begning and end also: |emp_name|emp_department|emp_salary| How can i acchieve this in oracle using sqlplus,Pls. help me out...ur early response can ease my nerve!!!

Answer 1

Hi, I don't think sqlplus let you do that. As you know, separators columns are here for, well.. separe two columns. You can always do your request like that :

select '|' || col1, col2, col3, col4 || '|'
from myTable