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 Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en