Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

4.0 EA2 - Column Width in SQL Editor

JasonBatzlaffSep 13 2013 — edited Sep 13 2013

I execute the following simple sql:

SELECT 1, 2, 3, 4

FROM dual;

In SQL Developer 3 and 4.0 EA1, the columns displaying the data were as small as possible to fit the data/column name

In SQL Developer 4 EA2, the columns are expanded so that the 4 columns consume the entire width of the screen.  I am not able to make all 4 columns smaller.  When I make column 1 smaller, then columns 2, 3, and 4 all increase in size.

Is there a setting to control this behavior?

Thanks,
Jason

Comments

gdarling - oracle
Answer
MSDAORA doesnt have a 64 bit version. You'll need to either switch the app to 32 bit and use a 32 bit Oracle client, or use a 64 bit client and oledb provider instead (Ie, Oracle's provider - ORAOLEDB.ORACLE)

Hope it helps,
Greg
Marked as Answer by 730380 · Sep 27 2020
730380
Hello,
thanks for your answer. I downloaded the oracle provider set and changed it in my source code. now it works.
984544
Can you give me the link where you download and how you changed
Tridus
You can download from here: http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html

The simplest change is in the connection string for your application. If you're lucky, no other changes will be required. Need to do testing to verify that for your code though. :)
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 11 2013
Added on Sep 13 2013
1 comment
237 views