Dev Corner

You can add special characters to an Oracle SQL query by using the CHR function. For example, to add a Tab character, you can use CHR(9). Where 9 is the ASCII code for the Tab character.

SELECT first_name || CHR(9) || last_name
  FROM employee;

You can use this approach to add other special characters to Oracle query.

Back to Oracle Database Tips
.