This content has been marked as final. Show 2 replies
Just checked on SQL Developer 3.2.2 patch (3.2.20.09.87) 32-bit against DB 220.127.116.11 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.
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.
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.