How can i display a column name with a '-' sign. i.e by using concat sttle i can concat two column name but is there a possiblity to display column name as "EMPLOYEE -- ID"

Questions by Samuel   answers by Samuel

Showing Answers 1 - 2 of 2 Answers

matloob Hussain

  • Oct 28th, 2005
 

by just defining the alias "EMPLOYEE--ID" in your SQL for example

select employee_id "EMPLOYEE--ID" from emp; 

  Was this answer useful?  Yes

Himanshu

  • Sep 6th, 2007
 

You just need to put as in between column name and alias.

Select sname as "s-name" from emp;

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.