Gossip Burst

Home / updates

Unable to add Tab Space using chr(9) in Select statement in Oracle 11G XE

William Clark |

I am trying to insert a tab between two vales/expressions in a select query using the below SQL. But this is not working.Tab is not coming in the output.

`select first_name||chr(9)||last_name Name from worker;'

Find below output.

Output of SQL

2 Answers

The syntax works fine.
It seems it is your client tool that does not display the tabs.

SQL Fiddle

SQL Developer doesn't show all characters in the grid, including tabs. However, if you double-click in a cell, you will see them:

enter image description here

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

You Might Also Like