I had the same problem and solved it by copying the MSVCR100.dll file from sqldeveloper\jdk\jre\bin to the sqldeveloper\sqldeveloper\bin folder. Credit goes to Erik Anderson from SQL Developer failed to start Note that different versions of SQL Developer need different versions of MSVCR*.dll. Various comments below have offered which versions worked for them.
It seems that SQL Developer thinks that you are running a plain DML (data manipulation) script, not a DDL (data definition). It also thinks that :new.id is a bindable variable. Why this happens, I don’t know; I can’t reproduce it in Oracle SQL Developer 2.1. Try to open a new SQL worksheet window in the … Read more
https://forums.oracle.com/forums/thread.jspa?threadID=447344 The pertinent section reads: There’s no setting to fetch all records. You wouldn’t like SQL Developer to fetch for minutes on big tables anyway. If, for 1 specific table, you want to fetch all records, you can do Control-End in the results pane to go to the last record. You could time the fetching … Read more
This tutorial should help you: Getting Started with Oracle SQL Developer See the prerequisites: Install Oracle SQL Developer. You already have it. Install the Oracle Database. Download available here. Unlock the HR user. Login to SQL*Plus as the SYS user and execute the following command: alter user hr identified by hr account unlock; Download and … Read more
control-shift-L should open the log(s) for you. this will by default be the messages log, but if you create the item that is creating the error the Compiler Log will show up (for me the box shows up in the bottom middle left). if the messages log is the only log that shows up, simply … Read more
The ‘oracle sqldeveloper’ stores all the connection details in an xml file ie. connections.xml. If you want to have a backup for the connection details, you will have to navigate to In windows XP C:\Documents and Settings\<YourUserName>\Application Data\SQL Developer\systemX.X.X.X.X\o.jdeveloper.db.connection.X.X.X.X.X.X.X\ In Windows 7 C:\Users\<YourUserName>\AppData\Roaming\SQL Developer\systemX.X.X.X.X\o.jdeveloper.db.connection.X.X.X.X.X.X.X\ and take a backup of connections.xml . Later, if you need … Read more
If you want to make your PK auto increment, you need to set the ID column property for that primary key. Right click on the table and select “Edit”. In “Edit” Table window, select “columns”, and then select your PK column. Go to ID Column tab and select Column Sequence as Type. This will create … Read more
DBMS_OUTPUT is not the best tool to debug, since most environments don’t use it natively. If you want to capture the output of DBMS_OUTPUT however, you would simply use the DBMS_OUTPUT.get_line procedure. Here is a small example: SQL> create directory tmp as ‘/tmp/’; Directory created SQL> CREATE OR REPLACE PROCEDURE write_log AS 2 l_line VARCHAR2(255); … Read more
Coming late to the party, but… With oracle 11.2.0.1 there is a semantic hint that can do this: IGNORE_ROW_ON_DUPKEY_INDEX Example: insert /*+ IGNORE_ROW_ON_DUPKEY_INDEX(customer_orders,pk_customer_orders) */ into customer_orders (order_id, customer, product) values ( 1234, 9876, ‘K598′) ; UPDATE: Although this hint works (if you spell it correctly), there are better approaches which don’t require Oracle 11R2: First … Read more
I found my java.exe that worked for SQL Developer at C:\ORACLE11G\product\11.2.0\client_1\jdk\bin where C:\ORACLE11G is my Oracle Home. The client that I have installed is 11.2.0. Hope this helps.