text:  15, 2012 9:04 PM by
  645301
  Issue with column alignment in Script Output
  645301
  Nov 15, 2012 7:00 PM
  I just installed 3.2.2 64bit (upgraded from 3.0.2 32 bit due to weird behavior in the SQL worksheet where I was unable to use carriage return for a new line as I had previously - I suspect it occured after I installed Windows updates today, but who knows).
  Issue I am having when I write a query in worksheet then Run Script (F5) and view results in Script Output.
  Column headings appear to be the full length of the data type, but it looks like the full length is not used in output - except when the value is null (the it uses the full length).
  Its kind of a headache to look at. I searched through settings in preferences but cannot find anything that seems to fit.
  if it matters, DB is 10g.2, SQL developer is 3.2.2 64bit, system is windows 7, jdk v 6.035
  This content has been marked as final.
  Show 2 replies
  1.
  Re: Issue with column alignment in Script Output
  Gary Graham-Oracle
  Nov 15, 2012 9:00 PM
  (
  in response to
  645301
  )
  Hi,
  Just checked on SQL Developer 3.2.2 patch (3.2.20.09.87) 32-bit against DB 11.2.0.1 and did not see any alignment issues. My environment is Windows 7 64-bit using jdk1.6.0_37 32-bit. Formatting worked fine both when displaying to Script Output tab or spooling to a file.
  select * from customers; -- Ran against the OE schema.
  That table has a
  cust_address
  column of data type
  cust_address_typ
  which has a width of 2000. Alignment worked fine.
  I believe there was a formatting bug fix between 3.2.1 and 3.2.2. Are you sure you picked up the latest patch release? Do you see the issue with a specific data type or all types? My test included Varchar2, Number, Date, SDO_Geometry, and a couple of user-defined types.
  Regards,
  Gary
  SQL Developer Team
  Edited by: Gary Graham on Nov 15, 2012 12:53 PM
  Actually columns using a TYPE data type, or something like SDO_Geometry, format to a width of 2000 in script output even if not needed, but you can override the width with standard SQL*Plus style column formatting.
  2.
  Re: Issue with column alignment in Script Output
  645301
  Nov 15, 2012 9:04 PM
  (
  in response to
  Gary Graham-Oracle
  )
  Gary - Thanks.
  I rebooted, and imagine that, the issue was resolved.
  I initially had issue today with carriage return (3.0.2). All I can think of was something with Windows Update. I adjusted font preferences. Then deleted SQL Developer folders and installed 3.2.2. It may have been imported preferences (font) from previous install.
  Go to original post
  Actions