0

maybe this is an already answered question, but I am relatively new to Oracle DB and couldn't find my answer around the Internet. So I have created a table in Oracle and when running the SELECT statement the output shows me columns like this:

Oracle SQL Developer

Please if anyone can explain how to rearrange the columns so, the values from CITY column go under the City column, and the Customer_Name goes under that output column. Thanks in advance!

1
  • Look at the format command IIRC? Please read this. You could check out the articles in my profile on how to ask a question on these forums. They are a great resource and you will get all the more out of them if you follow the guidelines! p.s. welcome to the forum! :-) p.p.s. see here.
    – Vérace
    Commented Apr 14, 2019 at 15:01

1 Answer 1

1

This is not an Oracle or SQL Developer problem.

The problem is the font you use. It is variable-width and there is just no way to properly align output with that. Use a fixed-width (monospaced) font and alignment just works out of the box.

https://en.wikipedia.org/wiki/List_of_monospaced_typefaces

1
  • Yes, you're right. I was using the default font and that was the problem. Thank you very much, sir. I marked your answer as accepted. Commented Apr 14, 2019 at 8:47

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.