1 Reply Latest reply: May 23, 2011 12:24 PM by Ganesh Srivatsav RSS

    CHR(13)/CHR(10)/CHR(9)

    733256
      What is CHR(13),CHR(10),CHR(9) ?

      How its used in oracle sql..(insert a in a table and retrieve from the table) ???? plzzzzzzzz help me???+
        • 1. Re: CHR(13)/CHR(10)/CHR(9)
          Ganesh Srivatsav
          CHR(9) -- Horizontal tab

          CHR(10) -- Line feed

          CHR(13) -- Carriage return.

          You can use them in insert like this,
          INSERT INTO table_name (columne_name)
          VALUES ('ABC' || CHR (9) || 'DEF' || CHR (10) || 'GHI' || CHR (13) || 'JKL')
          Here is the complete list of ascii values

          http://www.asciitable.com/

          G.