Oracle SQL Developer is a free tool for SQL & PL/SQL development and reporting similar to Quest's Toad or Allround Automations' PL/SQL Developer.

learn more… | top users | synonyms

2
votes
0answers
15 views

sql error on script execution. try deleting repository before creating repository

I want to migrate my mysql databse to oracle. I have followed the migration demo from this url http://www.oracle.com/technetwork/database/migration/connect-step-mysql-1946352.html but I got this ...
2
votes
0answers
34 views

How to import export.sql in sql developer?

In SQL Developer, from the top menu choose Tools > Data Export. This launches the Data Export wizard. So that is export. It creatres export.sql file. Now how to do import ? I am usgin SqlDeveloper ...
0
votes
3answers
41 views

SQL developer licensing [closed]

SQL developer is free or do you require license for oracle database to use the sql or pl/sql developer? Also, Is it secure to connect to the oracle database since it connects to the db over a remote ...
2
votes
2answers
47 views

Oracle Autotrace vs Explain

My team uses Oracle 11 and SQL Developer. I've been relying heavily on explain plans lately to try and determine the most efficient way to solve various problems. Recently, a coworker pointed out ...
0
votes
1answer
23 views

SQL Developer text of status bar

My version of SQL Developer (4.0.2.15) has white text on a light blue background (see below). I have been unable to find in the preferences to change this so that it is more readable. Does anybody ...
0
votes
1answer
42 views

SQL Developer code formatting

I have just cut 'n' paste some SQL code into SQL developer (4.0.2.15). I have a right margin set and selected CTRL+F7 to format it. However I have two problems The code is wider that the right ...
0
votes
0answers
13 views

SQL developer security concerns

What security risks are there when I connect to the database using SQL developer? I've been restricted to use it to access the database from my desktop because it connects to the db over a remote ...
0
votes
1answer
84 views

SQLDeveloper set default linesize

As per title, how to set Oracle SQL Developer default linesize so that I don't have to set it every time I open the program?
2
votes
0answers
25 views

Procedure to update tables when the difference of values is less than 10% [closed]

I use Oracle database. I have 2 tables. Table1 with the following details: Table-1 emp.no | salary 1 | 2000 2 | 3000 3 ...
0
votes
0answers
9 views

How to fix an ORA-12505 error? [duplicate]

How to fix this error in SQL Devloper. Status : Failure -Test failed: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect ...
0
votes
1answer
53 views

How to create an Oracle Database Link when the password has special characters

I'm trying to create a DBLink. SQL Developer is the client I'm using. The password to my remote user has *'s in it. I'm having trouble figuring this out. This syntax isn't working: CREATE DATABASE ...
1
vote
2answers
33 views

Causing ORA errors in a program using JDBC. How can I find what's causing them?

So I'm building a java app to interface with the company's database. Whenever it causes an ORA error, it just prints something like the following to system output: ORA-00911: invalid character Is ...
0
votes
0answers
95 views

Why is there a difference in CSV Export Results of Oracle SQL Developer and SQL Plus Spool

When I export data from SQL Developer GUI, setting format: csv, left enclosure: ", right enclosure: ", and Encoding: UTF8, I get data exactly the way that I need it for processing in Python. ...
4
votes
1answer
73 views

Microsoft SQL linked server to Oracle data not updating

I need to pull data from an Oracle database running on a remote machine and use it on my sql server instance. I need to check these tables periodically for updated or new records. I have created a ...
0
votes
2answers
91 views

Connect to Oracle using SQLDeveloper using OS Authentication on a remote machine

I reach my database server from my MacBook via SSH. You can login into this database as by using OS authentication. MacBook:~ mangeles$ ssh oracle@10.10.1.64 oracle@10.10.1.64's password: Last ...
0
votes
0answers
46 views

How to connect to a |Database from SQL Script, in SQL developer

Hi i am trying to connect to a DB using a connection string mentioned in a Script file.. in SQL developer. I am using the below format Connect USERNAME/PASSWORD@HOSTNAME:PORT/Service_name.. But its ...
0
votes
0answers
49 views

Insert Unique Records into Linked Server Table (from SQL to Oracle)

My issue is that I am trying to load only unique primary key records into oracle from sql. In the insert into stored proc statement I tried doing it by where primary key does not equal primary key ...
0
votes
0answers
37 views

connecting to database on ec2 Virtual Machine from sql developer

I am using Oracle SQL Developer 4 to connect to databases . We are running an Oracle 11g on Amazon EC2 Virtual Machine (not RDS) and I can’t connect remotely. inside the Virtual Machine as local ...
0
votes
1answer
64 views

Database Design / ER Diagram - Help Needed

Please take a look at this ER Diagram that I started. I just don't know if I've set it up correctly (I have not made any relationships yet). I just want to know if I have the appropriate "Tables" or ...
0
votes
1answer
13 views

Numeric cell with 0 not null

I have the following query (in a Oracle Database): SELECT SUM (CANTITATE) FROM ANEXA2A_TABEL2_ROWS WHERE TIP_ACTIUNE = 'COLECTATE' AND TIP_AMB = ...
0
votes
1answer
48 views

Oracle Database Migration using Oracle SQL Developer

I've 2 Oracle database on different machines [I connect to them via oracle SQL Developer Now I am planning to have machine 3 which will consolidate both Oracle instances on one new node Question ...
2
votes
1answer
312 views

Make Oracle SQL Developer to act like PL/SQL Developer

Is it possible to configure Oracle SQL Developer v 4.03 to automatically displays tables while im typing it names like in PL\SQL Developer? [update] Second question: How to make output grid loks ...
1
vote
0answers
104 views

ORA-01861 - Input seems ok and FX/FM modifiers not used

Using SQL Developer 4, I am getting an ORA-01861 exception when I do the following (and BTW, I ticked 'Ignore NLS Definitions'): alter session set nls_date_format = 'DD-MON-YY'; alter session set ...
1
vote
1answer
270 views

SQLDeveloper.exe itself is getting access denied

Installed Oracle 11g and the 11g client. Everytime I start SQLDeveloper it prompts for the java.exe and again which files to associate. It must be trying to save this in registry (or maybe disk). ...
4
votes
3answers
893 views

TNS-12541 Error

I have grid installed in my pc but the problem is LISTENER does not start automatically. I have to start listener manually and then only LISTENER get started. But before starting listener if you check ...
2
votes
1answer
2k views

Unable to connect to Oracle from SQL Developer

below is the error Status : Failure -Io exception: The Network Adapter could not establish the connection It's connecting from my system but unable to connect from other systems on the ...
0
votes
0answers
29 views

How to import to UNIX the results from a select query?

After a select query i get around 14k records.Rather than exporting them as insert statements into a file and then executing from UNIX, i want to import them to UNIX directly and insert so as to save ...
1
vote
1answer
416 views

Stop on error in PL/SQL developer or Oracle SQL Developer

At this time I am using TOAD to apply SQL*Plus scripts and there is an option to stop on the first error. After it I can fix the script and apply the remaining part. Due to license issues we can't ...
1
vote
1answer
83 views

Question about the workflow/design process/tools used by professional database designers

I hope this in the right place, as it's really more a question about database design software than the philosophy and practise of database administration. I'm a masters student doing an "introduction ...
0
votes
1answer
339 views

sql or hql query to find all parents of a particular record

I need a sql or hql query to find all parents of a particular record, that should work in oracle as well as mysql, for eg if I have the id: 201, the parents would be: 188, 187, 1. any help would ...
0
votes
0answers
216 views

Not able to create or modify tables using Oracle SQL Developer with psql driver

So I would like to use the Oracle SQL Developer for managing my postgresql database. Connecting to that database works fine with SQL developer 4.0.3. I am using this psql driver: JDBC41 Postgresql ...
0
votes
0answers
108 views

Insert a Date or Timestamp into the Editor of SQL Developer

In my Textmate texteditor I can type isoD and hit TAB which results in having the current Date inserted into the carrets current position. I use it a lot when commenting code like // ...
0
votes
1answer
4k views

Can't connect to a Oracle db instance via SQLDeveloper

When I set the connecting information on the GUI in SQLDeveloper I get the following error (everytime!) Status : Failure -Test failed: IO Error: The Network Adapter could not establish the ...
0
votes
1answer
3k views

How to grant permissions for User defined type in Oracle

This is probably easy but i can't seem to figure it out. I created my user-defined type as CO_ADMIN. However, the application using the type runs using GS_USER database account. I have granted ...
0
votes
1answer
358 views

How to check if current SQL session has uncommited changes?

Say you are in SQL Developer and want to check if the current user session (i.e. your connection) has uncommitted changes. If you quit SQL Developer, it does such a check and displays a dialog box ...
2
votes
1answer
75 views

What is this view being used in my query?

I'm running EXPLAIN PLAN on this query: SELECT DISTINCT l.item_num, l.repl_code FROM item_w l JOIN item i ON l.item_num = i.item_num LEFT JOIN item_w r ON l.item_num = r.item_num AND l.repl_code = ...
0
votes
0answers
207 views

Tablespace used on a create table statement

In Oracle SQLPLUS - If I create a table using the statement below via sqlplus logged on as user 'Fred' CREATE TABLE joe.tablename (tablename_columnname CHAR(1)) ; Which tablespace will the table ...
0
votes
2answers
182 views

Which tool enables using SQL query result sets as temporary tables for further analysis and set operations? [closed]

For examples, lets say I need to do set operations and joins on below 3 result sets. I don't want to write a composite query or use temporary database tables. Something which would enable faster data ...
2
votes
1answer
1k views

What does a green icon mean and why do the package bodies not expand when they have it?

In SQLDeveloper 4 some 10g PL/SQL packages have a regular crate while others have a green dot. Those with the green dot do not expand their bodies (might be just a coincidence). What is the ...
0
votes
1answer
7k views

Connecting to SQL Server using Oracle SQL Developer

I am using oracle sql developer to manage my oracle database. I recently added third party database jdbc drivers to be able to connect to my new MySQL and SQL Server installations. I need help with ...
0
votes
0answers
56 views

Debugging long Oracle queries and identifying offending data for 'Expression type does not match a required type' error

I have a long running query with a large number of complex XQueries. This queries used to work but more recently it is giving me Expression type does not match a required type error. I suspect ...
2
votes
1answer
750 views

Does Oracle run queries to completion after SQLdeveloper disconnects?

The query is a CREATE TABLE t as SELECT .....; statement. Can I reliably count on Oracle to complete this after I disconnect? After I re-connect, how can I check on the status of this query?
0
votes
0answers
23 views

Oracle XE 11g (ORA-12514: TNS:listener does not currently know of service requested in connect descriptor ) [duplicate]

I have already seen the questioned in the stack overflow that might relate to my problem but let me emphasize that none of them could resolve my issue. issue is: when I wanted to integrate OWASP ...
1
vote
2answers
115 views

How to Move All tables from one Database into Different Database?

I am using Oracle SQL Developer and I have ten tables. Now I want to move all 10 tables from Oracle into a SQL Server 2008 R2 database. Is there any easy solution for this task?
1
vote
2answers
609 views

Oracle becomes too slow after system crash [closed]

I am using Oracle 11.2 as a database for my application. For this purpose I should import my data (around 100m records) to this database. For this purpose I used SQL Developer. Unfortunately at the ...
2
votes
3answers
528 views

Oracle SQL Developer 4: how to tell under which user I connected

I'm using Oracle SQL Developer 4 to connect to multiple databases at the same time, sometimes using different credentials that those saved in connection properties. So I have multiple tabs in main ...
1
vote
1answer
4k views

Oracle tsping.exe - where to get/download it

I have recently downloaded latest version of Oracle SQL Developer (4.0.0.13), and my idea was that thsping.exe should go along with it - but this is not the case. Also I was surprised that SQL ...
-2
votes
6answers
989 views

Missing import function in SQL Developer like MS Access has

At my work we used to use MS Access now we are forced to use SQL developer to create queries and export the data. Details: We can only query to the database We cannot create a new database We use ...
2
votes
1answer
93 views

Sometimes getting quotes in Oracle spool sometimes not

Using Oracle SQL Developer, I do: spool c:\temp\file1.csv select /*csv*/ id, version, key, pattern, name from mydatabase.edition; spool c:\temp\file2.csv select /* csv */ id, version, amount, item ...
1
vote
1answer
605 views

Automatically schema backup in Oracle

I am working with an Oracle Database and I have a user (called XY) with permissions R/W. I would like to to do automatic backups of the user schema XY. I don't own the server and I don't know if the ...