I'm not sure there is a tab per se Serious_Developer. But you can mimic a
tab by using a string literal;
------------
SELECT last_name
|| ' '
|| job_id AS "Employees"
FROM employees
-----------
There's 11 spaces in the string literal.
1 space to appear after last_name
9 spaces that you want
1 extra space (to appear before job_id is displayed)
On Saturday, September 15, 2012 9:31:27 AM UTC-5, Serious_Developer wrote:
>
> How can I concatenate tab character with 2 fields ?
>
> SELECT last_name||char(9)||job_id AS "Employees"
> FROM employees
>
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
