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

0
votes
0answers
24 views

would you help me understand errors and bad exercise containing in the query?

A customer called technical support for a DBMS, saying that the DBMS had a severe bug and was crashing the operating system. On investigation, it was found that the ‘crash’ always happened when a ...
0
votes
0answers
42 views

Issues with SQL Developer

SQL developer is giving me errors of Network adapter could not establish the connection error Telnet is working from the local machine to the target (scan is in dns) nslookup from local machine is ...
2
votes
1answer
47 views

DBMS_METADATA.GET_DDL not displaying complete DDL for big tables

While generating the DDL for a schema, big tables' DDL are getting truncated. After displaying close to 110 rows I am getting an ellipsis (...). I am using SQL developer to run: SELECT ...
0
votes
1answer
25 views

Run a script as a sheduled job using sql developer scheduler GUI

I have a script Alter Trigger TEST.LIVE_DELETE Disable; Alter Trigger TEST.LIVE_UPDATE Disable; ----------Running the comparison script---------------- var scanid number; SET SERVEROUTPUT ON ...
0
votes
1answer
30 views

need to get data from Global Temp Table from db1 to db2 and show the data in Oracle form

I need to get data from Global Temp Table from oracle db1 to db2 and show the data in an Oracle form. In db1, a stored procedure is populating data in the GTT and showing it on Oracle forms as this ...
1
vote
1answer
28 views

Identify records with one identical field, but different timestamp

I am trying to process some data, stored in an Oracle DB, for a machine learning model I am working on. My current query uses this line in the SELECT statement to identify records that have a field ...
0
votes
1answer
29 views

Moving data from one DB to another where the table/column structure is identical

Question about the import / export process. I know is SQL Developer I can export all the columns from a table and import into the same table on another server. My question is - what happens with the ...
1
vote
0answers
38 views

SPOOLing gives extra rows, copy-paste does not

I am using oracle sql developer. My table has 58484 rows, but exporting to a csv gives 58532 rows! First I used this command (and tried fiddling with the set options for a bit to see what happened): ...
3
votes
1answer
52 views

Segmenting data by percentage of a column total

I need to separate a list of records by the percentage of a column when they are summed to all records larger than the current record until a MAX percentage. Records are sorted DESC in column A, and ...
2
votes
0answers
55 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
48 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
49 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
53 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
29 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
65 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
17 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
209 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
34 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 ...
1
vote
1answer
133 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
36 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
130 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
91 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
133 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 ...
1
vote
0answers
74 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
59 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
50 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
68 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
51 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
378 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
117 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
318 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
990 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
492 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
88 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
397 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
228 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
113 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
403 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
219 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
206 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
8k 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
58 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 ...