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
1answer
7k 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 ...
1
vote
1answer
79 views

Oracle Triggers - before any UPDATE or DELETE or INSERT

I am trying to create a database trigger in Oracle SQL Developer that would fire before any UPDATE, DELETE, or INSERT statement occurs on the sessions table. My sessions table: CREATE TABLE sessions ...
0
votes
1answer
30 views

Return output of Oracle query

How to change below query to see results of my_sql (now I see only query, not it results) in SQL Developer? DECLARE my_sql VARCHAR(1000); BEGIN FOR t IN (SELECT t.table_name, t.owner FROM ...
0
votes
1answer
112 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
286 views

How to call an oracle stored procedure in sql developer tool

I have written an Oracle procedure like below: create or replace procedure Sp_emp(cv_results out sys_refcursor) is begin open cv_results for select * from employee; end; / ...
3
votes
1answer
357 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 ...
1
vote
1answer
34 views

Importing .dmp file into SQL developer: Do I need to import seperately for each table?

I have a large .dmp file which I would like to import into SQL developer. This contains all the data I want to import across several Schemas. Do I need to split this up into each separate table in ...
4
votes
1answer
3k 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 ...
1
vote
1answer
52 views

no more data read from socket error with triggers

I have created one trigger that calls one procedure, using oracle sql developper. Here is the code for trigger : CREATE OR REPLACE TRIGGER noteTrigger BEFORE INSERT OR UPDATE OF valoare OR ...
0
votes
0answers
38 views

Sql developer how to copy to another tablespace [duplicate]

When copying database using SQL Developer it complaints that the source tablespace does not exist on destination database. How can I copy schema and data from Database A tablespace t1 into Database B ...
0
votes
0answers
16 views

Oracle SQL Developer 3.2.09 is consuming lot of memory on windows 7

Oracle SQL Developer Version 3.2.09 is consuming lot of memory on windows 7. I can see, after 1/2 days of usage and without closing the this application, the memory consumption is going upto 700 MB. ...
0
votes
1answer
64 views

ORA-00942: table or view does not exist- Can it be solved by granting privileges to user?

I am creating a Java application that connects to an Oracle Database. In the application I connect to the DB as User A, which works as intended. I then try to access tables in Schema 1 and Schema ...
0
votes
0answers
47 views

How could I improve speed of fetch in Oracle?

I've got a table of taxi GPS trajectory records with approx 60 million rows, including date, time, ID, longitude, latitude, speed, bearing etc., which were imported from .csv files with setting each ...
0
votes
1answer
24 views

Can't get update one prompt for same variable over multiple tables

I've tried using the following: select * from TABLE1 where COLUMN= :VAR union select * from TABLE2 where COLUMN= :VAR; I'm getting the following error message back: [Teradata Database] [TeraJDBC ...
0
votes
1answer
135 views

Does PL/SQL code run differently in sql plus vs sql developer?

Today, I stumbled upon a question someone posted about the / character and ; character. The Answer doesn't seem to be down-voted, so I questioned it a little more as to why it wasn't down-voted. ...
0
votes
1answer
51 views

What is the name of the default schema in Oracle?

When you create an object in Oracle, and do not specify a schema (object prefix), is there a name for that default schema? I see in Oracle SQL Developer, that a newly created object shows up in the ...
2
votes
4answers
2k 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 ...
2
votes
1answer
689 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). ...
0
votes
1answer
77 views

ORA-29913 and ORA-30653 error selecting an external table

I created an external table using a .tbl file and now Im trying to select all rows from that table, using: select * from users_load; But Im getting this error: ORA-29913: error in executing ...
0
votes
1answer
139 views

Load data from flat file into oracle table [closed]

I created a new database, then created a table "users". Now, I'm trying to load data to this table from a flat file called 'users.tbl', that has some records with the following format: ...
0
votes
0answers
97 views

DBeaver launch script from file

I'm trying to find a good alternative to SQL Developer for performing queries and scripts on Oracle instances. I find DBeaver to be an interesting tool, it has a lot of great features, BUT it seems ...
0
votes
0answers
23 views

How to get data using 2 different set of date range for 2 different case conditions

I am trying to get "FCR" from a date range of Jan 24th to Jan 31st and R1 & R2 from Date Range greater than Jan 24th. I tried to use case statement to create a flag called as "First" in the select ...
0
votes
1answer
84 views

How do I kill a non-running impdp job?

I am trying to run an import operation into an Oracle 11G R2 database from a .dmp file using SQL Developer 4.1's Data Pump Import Wizard. I set everything up with IMMEDIATE start, but then the job ...
0
votes
0answers
106 views

How do I open Data Pump Import Wizard in SQL Developer 4.1?

How do I find and open the Data Pump Import Wizard in SQL Developer 4.1? I opened the Help search tool in SQL Developer 4.1 and searched for Data Pump, and found directions that include: 1.) ...
3
votes
1answer
94 views

Global command to destroy all disconnected data files in Oracle 11g

Is there a global command to delete/purge all disconnected .bdf files in an Oracle 11g R2 database? Here is the scenario: Every user-defined user and user-defined tablespace was deleted from an ...
0
votes
1answer
88 views

How can I launch SQL Developer?

I recently installed Oracle 11g R2 on a Windows 8.1 machine, but for some reason SQL Developer does not seem to launch easily. What specific steps do I need to take in order to launch a working SQL ...
0
votes
0answers
29 views

varray and cursor..need help on counter

DECLARE type ABC is array(10) OF number; v2 abc; CURSOR c1 ISSELECT employee_id FROM employees WHERE rownum<10; v2 :=abc(); counter :=1; BEGIN for i IN 1...10 loop ...
1
vote
1answer
48 views

Need help to construct query/pl-sql block to get DB table column name and query result as key-value pairs

I have a DB table has more than 50 columns. I am querying this table, it should return only one row any time. as below image from sqldeveloper. here I need to construct query/pl-sql block, to find ...
-1
votes
1answer
37 views

function execution related question

Create or replace function funleap(a number) return varchar2 is b2 number(5); b3 number(5); b4 number(5); begin b2:=mod(a,4); b3:=mod(a,100); b4:=mod(a,400); if ((b2=0 and ...
1
vote
1answer
140 views

SqlDeveloper: ora-12505 TNS listener does not currently know of SID given in connect descriptor

Info connection name: ziv username:sys password: xxxxxxx connection type: basic role: sysdba host name : localhost.localdomain port: 1522 sid: ziv The QUAST is to connect to the database ...
1
vote
1answer
41 views

/ Character in a stored procedure

I am trying to recompile/update a stored procedure in SQL Developer that uses a few division operations to populate tables. A sample section looks like this: Insert Into Production(A, B, C) ...
-2
votes
1answer
48 views

plsql block not executing

I am unable to execute this block. it just compiles. what statement I have togive to see output. where I am doing error ? I clicked on output button also
-1
votes
0answers
32 views

Get the sum of Total Churn_MTD(Current+2015+<2015) [duplicate]

how to declare 8 variables and get the total Sum,as you can see from the picture i created the 3 store procedures but dont know how to do the ...
0
votes
2answers
94 views

unable to connect to oracle in linux terminal in oracle VM ,TNS listner not connected

i installed oracle VM , new to oracle vm. Can some help me in connecting to oracle in Linux termial and TNS listner is not responding with IO failure on sql developer when pressing test button ...
2
votes
1answer
2k 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; ...
6
votes
2answers
194 views

Precision of NVARCHAR2 column is 1.5 times lower than displayed by desc command

I wanted to update precision of an nvarchar2 column and came across an interesting case. I have tried to replicate it below: create table test_table1 (col1 nvarchar2(100)); table TEST_TABLE1 ...
2
votes
1answer
15k 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 ...
2
votes
3answers
8k 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 ...
2
votes
1answer
52 views

I need to update a Oracle procedure via a .sql script

I need to update a Oracle procedure via a .sql script. I know the procedure works because it is currently running on our server, but I need to update the procedure on a client's box. I need to be ...
3
votes
1answer
106 views

In Oracle SQL Developer, how do I create or update a procedure and have the schema name be a variable:

In Oracle SQL Developer, how do I create or update a procedure and have the schema name be a variable: define my_schema_name = 'schema_1'; CREATE OR REPLACE PROCEDURE ...
0
votes
1answer
627 views

Oracle 11g: SQLDeveloper |status: failure-test failed: IO error. connection reset|

part 1 new / select database connection info connection name: ziv username:oracle password: xxxxxxx connection type: basic role: sysdba host name : localhost.localdomain port: 1158 sid: ...
1
vote
1answer
50 views

Set uncommitted read as default in Oracle SQL Developer with DB2 database

I am using SQL Developer with a IBM DB2 database. I am only querying the data for analytical purposes - never making any updates, additions or deletions. I was wondering if there is a way to ensure ...
3
votes
1answer
967 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, ...
1
vote
2answers
50 views

Fetching recent/historical queries run on a database from an application

I'm getting some database errors from an application related to unique constraints however none of the records have any duplicate values so I want to check what query was run that produced the error. ...
1
vote
1answer
28 views

Find out where length semantics gets changed

I've code to create tables that doesn't specify length semantics: CREATE TABLE CHAR_TEST ( CHAR_TEST_ID NUMBER(*,0) NOT NULL, FOO VARCHAR2(6) NOT NULL, BAR VARCHAR2(6) NOT NULL, ...
0
votes
0answers
181 views

PL/SQL to find Special Characters in multiple columns and tables

I am trying to come up with a script that we can use to locate any special characters that may exist in a column of data except for period, dash or underscore, and using variables. My Data - ...
2
votes
1answer
6k views

sqldeveloper ORA-12505. TNS: listener does not currently know of SID given in connect descriptor

There are similar questions asked and answered in this network related to the error message given in the question, however this problem is a little different from each. I have installed oracle 12c in ...
-1
votes
1answer
73 views

Oracle program “lsnrctl” is missing after the installation of Oracle SQL Developer [closed]

I recently downloaded Oracle SQL Developer and when making a new connection inorder to start my own DB I was unable to due to this error below: IO Error the Network Adapter could not establish ...
0
votes
1answer
59 views

Oracle 11g: SQLDeveloper

How would I use the pre-installed SQLDeveloper that comes packaged within Oracle 11g if I am invoking it with a user that has no oracle or admin rights on linux? Would it be enough just to change ...
3
votes
2answers
6k views

Disable autocommit for SQL Server connection in Oracle SQL Developer

I am using Oracle's SQL Developer to execute queries against my SQL Server 2008 database as I simply can't work with SSMS as long as it doesn't support Ctrl + Return to execute statements... Anyway, ...