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

1
vote
1answer
31 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
48 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
39 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
23 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
216 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
54 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
60 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
50 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
34 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
55 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 ...
0
votes
1answer
112 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
530 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
26 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
173 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
24 views

Oracle sql developer: generating “CREATE” query list from an existing database [duplicate]

Is it possible with Oracle SQL Developer? If not, any other tool were also okay.
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
101 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
325 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 ...
0
votes
0answers
51 views

Oracle DB automatic backups

I want to apologize because i believe that this question is already consumed, but please give it a chance. I've started practicing on a Oracle DB 11g XE. I'm following the tutorial from Oracle Docs ...
2
votes
3answers
112 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 ...
0
votes
1answer
1k 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
703 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
51 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
347 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 ...
0
votes
3answers
101 views

Applying data changes from one database to another

I have an application running on Oracle 9i database and I was looking for something more practical to deploy data changes (not schema changes) from the development database to production. Currently I ...
1
vote
0answers
55 views

Oracle sql developer tree shaped represantation of Explain_Plan

I want to ask what exactly happens to the following Explain_Plan table : It firsts Joins the two tables Products & Order_Items then the output is joined with Orders and then with the ...
2
votes
2answers
918 views

Why does the same query run faster the second time I run it?

I noticed when running a SQL query it is faster the second time than the first. So my question is, in Oracle SQL Developer where can you see the statistics that explain this behaviour?
1
vote
3answers
159 views

How to get SQL for DDL commands in Sql developer?

In Sql developer it is possible to get DDL for an existing table - However, how do I get SQL for operations performed through UI? For example, how do I see DDL generated when I alter the table to ...
0
votes
2answers
747 views

Which SQL Developer Version will be compatible with Oracle 9i

My Company is using Oracle 9i. I want to connect to the database. I'm planning to use SQL Developer. Which version will be compatible Oracle 9i?
2
votes
1answer
1k views

Replicate or Call java encryption function in Oracle pl/sql

I am trying to replicate encryption/decryption method present in java in Oracle DB, so that data encrypted in java can be decrypted through Oracle Function. Below is java code: package com.encr; ...
0
votes
1answer
95 views

Different time in different sessions

I am connecting to same db from 2 different machines using SQL Developer and querying a table which stores timestamp. But to my surpise the time value returned by query has a gap of one hour on ...
1
vote
1answer
137 views

Connecting to an 11g Standard Database (Local)

So i've installed 11g Standard on a VM, it's going to be connected to from other Computers/Users. Im not really used to Oracle setup/etc.. so bear with me. Anyways it installs successfully and ...
2
votes
0answers
52 views

Data not showing in English, unless you click on it - In sqldeveloper

I have installed OracleXE and imported data into it. From SQLPLUS, I can query the data and it all shows up in English. However, in SQLDEVELOPER, if I look at the data, it's in a nonsense format, ...
1
vote
2answers
4k views

SQL Developer: how to script output to query results grid

I am used to MS SQL Server Studio where I can DECLARE and SET variables and use them in my query, and then be presented with the results in a datagrid that I can copy and paste into Excel. In Oracle ...
0
votes
1answer
2k views

Why Oracle SQL Developer does not need Oracle client?

I installed Oracle SQL Developer from Oracle's web page. It seems to work without a Oracle client installed on my computer. How is that possible? I also installed Toad for Oracle and it seems to ...
1
vote
1answer
2k views

Unable to connect to Amazon RDS instance [closed]

I recently created an oracle instance on Amazon RDS. Unfortunately, I'm not able to connect to the instance using Oracle SQL Developer. The (relevant) information I have from Amazon; Endpoint - The ...
1
vote
2answers
6k views

Exporting 30 million rows to CSV

I have a query that hits multiple tables in an Oracle database (11g). I don't have access to the server itself. I use SQL Developer or SQL*Plus to connect. There are about 31 million rows, and 7 ...
1
vote
1answer
2k views

Registry error while trying to install Oracle 11g on Win 2008 R2

I am new to Oracle and trying to install Oracle database 11g Enterprise Edition on Windows 2008 Server R2 but getting this error all the time... It gives me error when updating registry key ...
-1
votes
2answers
93 views

Combine two SQL statements to a single statement [closed]

My question is related to SQL. I need to pull values from two different tables. I am not successful in doing that. I am able to join the two tables with only a single condition but not many values ...
3
votes
1answer
2k views

Where's my Network Alias list in Oracle?

I can't select any Network Alias from the Network Alias Drop-down. My TNSNames.ora file is in C:\Oracle My other machine that is a fresh install doesn't have this problem. I get an error when I ...
0
votes
1answer
587 views

can not execute LIMIT on sql Developer

I am trying to execute following on sqlDeveloper SELECT salary FROM emp ORDER BY salary DESC LIMIT 4, 1; But it is throwing following error: ORA-00933: SQL command not properly ended 00933. 00000 ...
2
votes
1answer
1k views

Can't return data from SQL/Plus and Toad but can from SQL Developer

This one has me stumped. We are running an Oracle 11g on Amazon EC2 and I can connect and query fine with SQL Developer but with Toad and SQL/Plus I can connect but when I try to do a simple select ...
0
votes
1answer
3k views

How to connect to a Database made by Oracle SQL Database?

So I am fairly new at this, so if you could keep that in mind in your answers, it would be much appreciated. I installed Oracle SQL Database on my Windows PC. It came in two zip files. I installed it ...
1
vote
0answers
269 views

PeopleSoft or Oracle App Designer Tool Alternative

We are using PeopleSoft app designer tool to manage and create projects, database objects - tables, columns, views etc in Oracle database. This tool has limitation that we cannot create tables/columns ...
0
votes
1answer
49 views

viewing Original Object under synonyms

I have certain synonyms in my schema which represent views from another schema. Now in oracle sqldeveloper, I am unable to see the actual SQL for those views but I see only an SQL like: CREATE OR ...
6
votes
2answers
2k views

SQL developer: Setup debugger for plsql

I'm trying to debug remotely pl/sql. But I can't - database returns me an error. What should I do to fix this and start debugging ? ORA-30683: failure establishing connection to debugger ...
3
votes
1answer
1k views

halt on error in a sqlplus script

I am deploying pl/sql code using several sql files that are called with @@file. If a package got a compilation error the script continues to the end. Is there a way to stop on every compilation ...
0
votes
3answers
1k views

ORA-00905: missing keyword when trying to create a synonym

I have a problem when I try to create a synonym like this: CREATE SYNONYM B2H.BILLING_USER_ACTIVITY@PACOMNET FOR B2H.BILLING_USER_ACTIVITY@PACOMNET.US.ORACLE.COM; Why does this happen and how can ...
0
votes
1answer
4k views

Need to count records and group count by date on Oracle

I have a table like the following ID created sent type ----------------------------------------------------- 0001463583000051783 31-JUL-12 1 270 0081289563000051788 ...
2
votes
0answers
636 views

Where can I find a syntax reference for Oracle SQL Developer's “Generate DB Doc” function?

Oracle SQL Developer (I'm using v3.2) has a feature called "DB Doc", which generates documentation for database objects. I mostly want to use it to generate documentation for my stored procedures, ...