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
6k 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
558 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). ...
-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 ...
3
votes
1answer
261 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
112 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
38 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
27 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
48 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
153 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 ...
1
vote
1answer
12k 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
6k 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
42 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
75 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
180 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
36 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
922 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
35 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. ...
0
votes
1answer
78 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; / ...
1
vote
1answer
24 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
27 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
1k 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
52 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
58 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, ...
-6
votes
1answer
6k views

primary key, foreign key relationship between the department and employee tables How do I install? (sql_developer) [closed]

Employees table: Column names: EMPLOYEE_ID EMPLOYEE_NAME EMPLOYEE_LASTNAME JOB EMPLOYEE_BUSINESS_PHONE EMPLOYEE_GSM SALARY HIRE_DATE E_MAIL DEPARTMAN_NO NOTE: For this table EMPLOYEE_ID is ...
0
votes
1answer
19 views

how i can extract a table data to a binary file

I´m new in oracle, i try to get data from a table of oracle and I only find how to extract to a csv, i want to know if someone knows how to extract in a binary file, im already try with sql developer ...
0
votes
1answer
48 views

Including a SQL file within a SQL query

In Oracle SQL Developer, is there any way to include a SQL file within a SQL query? Like the command \include{myfile.tex} in LaTeX. Example: file1.sql contains FROM my_table; file2.sql contains ...
0
votes
2answers
337 views

Exporting results of a query in SQL developer without having to execute the query twice

Is there anyway to export the results of a query in Oracle SQL Developer without having to execute the query twice? Running a SQL query in worksheet, then Right click on Result Set window -> Export ...
0
votes
1answer
42 views

SQL developer - procedure just for a session

Is it possible to create a bunch of procedures just for the SQL developer session, so when the session ends the procedures are deleted?
1
vote
3answers
2k 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?
1
vote
1answer
37 views

Replace 2 spaces by 1 space in all values of a column

I need to replace 2 spaces by only 1 space for all entries of 1 column in an Oracle database. I found this and tried it: SELECT REGEXP_REPLACE('MODEL', '[[:space:]]{2,}', ' ') new_string FROM ...
1
vote
1answer
130 views

SQLPlus “no listener” only with a remote connection from Windows

The Oracle database is running on a linux server. The lsnrctl service is running. Locally, I can connect to database from sqlplus and sql developer. Remotely, from windows, I can't connect. sqlplus ...
0
votes
0answers
22 views

How can I edit the prediction query to pass the parameters from a GUI?

I have created a data mining in Oracle SQL Developer and I got the the following query using the "Apply" node. I have to use this to predict the values for the class variable when the values for the ...
1
vote
0answers
174 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
31 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
98 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
91 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 ...
2
votes
1answer
673 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 ...
0
votes
1answer
428 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
58 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
34 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
153 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
51 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
61 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 ...
3
votes
0answers
644 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, ...
2
votes
0answers
1k 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
72 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
90 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 ...