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
3answers
132 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 ...
1
vote
2answers
3k 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 ...
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, ...
2
votes
0answers
588 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, ...
2
votes
0answers
190 views

Oracle sqldeveloper Database Diff - not seeing indexes/sequences

I am using Oracle SQL Developer's database diff tool to compare schemas. (SQL developer version : 3.2.09) It works great on some environments, but in one, I can only see differences in tables - the ...
2
votes
0answers
396 views

SQL Developer Data Modeller and Data Dictionary question

I'm not a DBA but I am a (mostly!) competent SQL report writer. Can I trouble you DBAs for some pro-knowledge, please? I can connect SQL Developer to Oracle XE's data dictionary without any problem, ...
1
vote
0answers
54 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 ...
1
vote
0answers
251 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 ...
1
vote
0answers
153 views

Can not open oracle 10g database when migrated from oracle sql developer 1.5x to 3.1x

I have migrated from Oracle sql developer tool 1.5x to 3.1x and imported my connection settings with database 10g. When I try to open a connectionstring in the developer tool I get this message: ...
0
votes
0answers
18 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
0answers
18 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 ...
0
votes
0answers
48 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 ...
0
votes
0answers
23 views

how to read nested object?

In the following code premium_codes_object_type is an object and this object having nested object and this object send from other schema procedure. CREATE OR REPLACE PROCEDURE modify_sync_prod ( ...