On Saturday, September 15, 2012 8:31:27 AM UTC-6, Serious_Developer wrote: > > How can I concatenate tab character with 2 fields ? > > SELECT last_name||char(9)||job_id AS "Employees" > FROM employees >
Don't use char(); the function in Oracle is chr(): SELECT last_name||chr(9)||job_id AS "Employees" FROM employees; will get you what you want. David Fitzjarrell -- 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