3 Replies Latest reply on Apr 7, 2013 10:17 AM by Jim Smith

    Format output - HEADING A|B doesn't work

    1001096
      Hi,

      Why the HEADING EMPLOYEE|ID doesn't work?
      SQL> column EMPLOYEE_ID HEADING EMPLOYEE|ID
      SQL>  SELECT * FROM employees;
       
      EMPLOYEE_ID FIRST_NAME           LAST_NAME            EMAIL                          PHONE_NUMBER    HIRE_DATE   SALAR JOB_ID   MANAGER_ID DEPARTMENT_ID
      ----------- -------------------- -------------------- ------------------------------ --------------- ----------- ----- ------ ------------ -------------
              362 Tracy                Freeman              tracyf@aoltimewarner.it        0544456377      10/28/2009   8013    879          165          1100
              598 Deborah              Hutch                deborah.hutch@ceom.it          0522915345      9/11/2009    6027    927          147          2500
              282 Steve                Weber                steve.weber@lifelinesystems.de 0582564427      9/17/2012   17825    101          147          2600
              710 Shawn                Winans               shawn.w@irissoftware.li        0584555378      7/19/2004    7713    879          147          1100
              452 Marlon               Costa                marlon.costa@supplycorecom.uk  0587903317      10/24/2010   9695    354          158          1500
              198 Pamela               Dalton               pamela.dalton@innovateecommerc 0525647730      11/4/2004   20890    101          171          1100
              987 Christma             Maxwell              christmas.maxwell@spectrum.uk  0587166637      11/14/2001  18865    198          146          1700
              698 Joey                 Sweet                joey.sweet@oss.uk              0587757460      1/17/2007    8136    947          198          2100
              145 Armin                Preston              a.preston@viacom.dk            0575161830      3/22/2009   12772    735          839          1600
              159 Aida                 Rourke               arourke@clubone.uk             0574977531      8/24/2010    9779    421          453          2400
              165 Natalie              Murdock              n.murdock@fsffinancial.com     0583019470      2/28/2001    8665    354          402          1700
              158 Lynette              Kravitz              lynette.k@wyeth.hu             0523285052      1/3/2009     9344    735          734          2700
       
      12 rows selected
      Thanks
        • 1. Re: Format output - HEADING A|B doesn't work
          Jim Smith
          It works for me on version 3.2.20.09.

          What version are you using?

          Also, on the off chance that the data you have posted is real, it is probably not wise (and in some countries, illegal) to post personal information from a database in a public forum.
          • 2. Re: Format output - HEADING A|B doesn't work
            1001096
            Hi Jim,
            It works for me on version 3.2.20.09.

            What version are you using?
            I use PL/SQL Developer Version 9.0.5 1648. When I start it, I log in a window "Oracle Logon" with my password from Oracle DataBase 11g express edition.
            Also, on the off chance that the data you have posted is real, it is probably not wise (and in some countries, illegal) to post personal information from a database in a public forum.
            This is not a real data. Data generator generated some random names and emails.

            Thanks for the help.
            • 3. Re: Format output - HEADING A|B doesn't work
              Jim Smith
              998093 wrote:
              Hi Jim,
              It works for me on version 3.2.20.09.

              What version are you using?
              I use PL/SQL Developer Version 9.0.5 1648. When I start it, I log in a window "Oracle Logon" with my password from Oracle DataBase 11g express edition.
              This is the forum for Oracle's SQL Developer product. For help with PL/SQL Developer you need to ask on one of their forums (allroundautomation.com)