This content has been marked as final. Show 16 replies
This is working for me and I don't have to select all the cells.
Select and copy cells from excel.
Click new row button several times
Select first empty row in SQL Developer
Paste. - Pasted cells go into separate columns.
If I don't have enough blank rows and i am at the end of the data, the extra cells just don't paste.
If I am not at the end of the data, the extra cells overwrite the existing data.
If I paste without creating blank rows, all the cells overwrite existing data.
Version information -
Windows Vista Business 32-bit SP2
Oracle SQL Developer 3.2.20.09
Copyright © 2005, 2012 Oracle. All Rights Reserved.
IDE Version: 18.104.22.168.37.59.48
Product ID: oracle.sqldeveloper
Product Version: 11.2.0.09.87
Java(TM) Platform 1.6.0_35
Oracle IDE 3.2.20.09.87
Versioning Support 3.2.20.09.87
Let's hope you aren't using Java 7 (most recent SDK is jdk1.7.0_17) since it is not officially supported, especially not on earlier releases like 22.214.171.124. Perhaps you downloaded the 32-bit SQL Developer 3.0.04 version that comes with it's own jdk (jdk1.6.0_11, as I recall), but just to verify what you are actually using, open
Help -> About, then look for the java.home value in the Properties tab.If it is not showing a jdk1.6.0_xx version, where xx >= 11, then at a minimum I would recommend downloading and installing the latest Java 6 update (currently jdk1.6.0_43). Update your ...\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf file so the SetJavaHome line is
depending on whether you use the 64-bit or 32-bit version of SQL Developer. It would also be a good idea to upgrade to the latest production release of SQL Developer (3.2.20.09.87). If you wish, you may keep multiple versions of SQL Developer installed, each in it's own distinct directory. It is not necessary to remove a prior version.
SetJavaHome C:/Program Files/Java/jdk1.6.0_43 or SetJavaHome C:/Program Files (x86)/Java/jdk1.6.0_43
By the way, I ran your test case against 3.0.04 32-bit with Java 6u43. The copy/paste worked fine (ctrl-V or Edit -> Paste). My case involved 3 rows and 2 columns (a NUMBER and a VARCHAR2(32)) on Windows 7 64-bit.
SQL Developer Team
So I downloaded and installed the version of sqldeveloper-3.2.20.09.87 with the packaged JDK. Properties says Java platform 1.6.0_35, Oracle IDE 3.2.20.09.87, versioning support same as Oracle IDE version.
BUT login broke. I exported the previous set of working connections as an XML file and imported it into the new version of SQLDeveloper. When I test a sample (previously working) connection, I get:
Status: Failure -Test failed: oracle.jdbc.driver.T2CConnection.t2cCreateState([BI[BI[BI[BI[BI[BI[BISI[S[BZ[J)I
I had this problem on the other version of SQL Developer I have installed, but don't recall exactly how I got around it (fuzzy memory says I found a support forum suggesting that I replace a SQL Developer Java library with another version from somewhere else). We're using OID, a couple of other things, and mandatory mixed case passwords.
There must be a conflict but, if you do not use OCI/Thick, it must be with the ojdbc6.jar rather than the ocijdbc11.dll. The following thread is a bit dated, however I imagine it may apply to your situation if we consider ojdbc6 rather than ojdbc5:
Re: Oracle SQL Developer 2.1 Patch 1 and latest instant client drivers
I copied the ojdbc6.jar file from my C:\Oracle11g\instantclient_11_2 location to sqldeveloper-3.2.20.09.87\sqldeveloper\jdbc\lib. (I didn't bother with the ojdbc5.jar file). Having done that, I can login and I can paste, so my problem (at least so far as the original thread goes) is solved. However, it introduced a new "issue". SQL Developer will no longer let me save my connections in the "USER@DB_INSTANCE" format; it says that I can't use characters not allowed on the filesystem, which is funny to me because this is the first time it has ever complained about that format....