macboyme95 macboyme95 - 1 year ago 98
SQL Question

SQL Fetching values with special characters

I got an Employee schema in oracle 11g.

Emp_ID,Emp_Name and SALARY.

Need to return values inserting special characters.



Is there a way to return values w/o using INSERT statement and hence not permanently changing the table contents?

Answer Source

You appear to want to concatenate several columns with a '**' delimiter separating the column values:

SELECT Emp_ID || '**' || Emp_Name || '**' || Salary
FROM   Employee
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download