Questions tagged [oracle-sql-developer]

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.

Filter by
Sorted by
Tagged with
0
votes
0answers
23 views

Easy way to display HTML results from Oracle (SQLDeveloper) in Browser?

I'm curious, if there is an easy way to display any kind of html reports generated in SQL-Developer by packages like e.g. dbms_sqltune.report_sql_monitor() in an external browser like Firefox etc. ...
0
votes
2answers
21 views

REGEXP_SUBSTR to split delimited values

I have a field called FREQUENCY and it has values like '10,0;30'. How do I write a regular expression to get the result like this: FREQUENCY 10 0 30
1
vote
1answer
32 views

Concatenating only desirable values with LISTAGG

In the Oracle DB there is a table with data "YEARS", see a table/image below +-----+-----------+------------------+ | FID | I0 | BJA | +-----+-----------+-----------------...
-1
votes
1answer
54 views

How do I log in to SQL Developer for the first time?

I just installed Oracle 19c and SQL Developer. I open SQL Developer and try to establish a new connection but I get "Listener refused the connection with the following error:ORA-12505, TNS:...
0
votes
2answers
230 views

Where can I find old versions of SQL Developer (4.x)? [closed]

I need a version that works with 11.2.0.4 driver or lower. In Oracle site there is the current version 20.4.1 and a link to the previous one. Each previous version you click has a link to the previous ...
0
votes
1answer
307 views

How to view databases and tables after 'imp' import using Oracle SQL developer

Maybe that's a wrong form of answer... The problem is: I've got an Oracle database dump file (very old, created with imp utility) At last, I've imported it. The command was imp file=E:\Downloads\...
4
votes
1answer
2k 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 ...
3
votes
1answer
293 views

Keystroke duplicating in data grid [closed]

The issue that I am experiencing is easy to reproduce. When attempting to update the data of a row using the data tab of SQL Developer the cell will receive the first letter twice. This happens "...
0
votes
2answers
274 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 is ...
0
votes
0answers
11 views

Search table data based on attribute and storing the output in nested table collection which is traversed through ref cursor

CREATE OR REPLACE PACKAGE BODY search_pkg IS /* PROCEDURE TO SEARCH PURCHASE DATA INPUT IS PURCHASE ID INPUT : PURCHASE_ID OUTPUT : DATA IS STORED IN THE COLLECTION DECLARED IN ...
0
votes
2answers
940 views

See other schema's tables in SqlDeveloper

When I connect to an Oracle DB with user XXX I see the tables, packages, etc. in schema XXX. Is there a way so that I can connect with user XXX and see things in another schema YYY? When I browse ...
0
votes
1answer
6k views

Not all variables bound ORA-01008: not all variables bound error

I am using Oracle SQL developer. I am running a query on employees table which is by default, having columns like first_name, last_name, employee_id, email, phone_no, hire_date, job_id, salary, ...
1
vote
1answer
875 views

Oracle SQL Developer: Copy paste tables, with 2 different instances, with different table structure

Here I have 2 difference instances, one is called DEV and one is called SIT2. I created a public database link, called DBLINKSIT2(Basically just to create a bridge between DEV and SIT2) and I need to ...
0
votes
1answer
17 views

Export mutliple query output into one excel sheet using Redshift and SQL Developer

I am connected to Redshift from SQL Developer 19.2.1. I have a requirement to export multiple query output into a single excel sheet, one query output should be in one Tab. Please advise on how to ...
14
votes
4answers
27k views

Script out Oracle DDL in an automated fashion

Oracle SQL Developer is able to export DDL through Tools -> Database Export... This works very well, but requires manual intervention. I know of DBMS_METADATA.get_ddl(), but have found that the ...
0
votes
1answer
546 views

Oracle - Query to join fact table to bridge table and show bridge group rows in one row?

I have a data warehouse with a One-To-Many relationship: "Fact" table contains: Product_Group_ID "Product_Bridge" table contains: Product_Group_ID, Product_ID "Product" table contains: Product_ID, ...
0
votes
0answers
22 views

SQL developer cannot connect to external databases. Only local ones

IO error: The Network Adapter could not establish the connection. Local databases work fine, but external one are returning me this error. I reinstalled once Oracle DV, and in the first time I ...
0
votes
1answer
67 views

How can I use COUNT in the same query with ROUND() and AVG()?

I need to write a query where I need to first count the tickets sold for spectacles in a theater, then calculate the average number of tickets sold in each theater and to be round it to two decimal ...
5
votes
1answer
1k 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, ...
0
votes
1answer
160 views

Migration from MySQL to Oracle generates empty tables

I'm using SQL Developer to migrate a database from MySQL 5.7 to Oracle 18c XE. The problem is that the tables are generated but empty, even though I'm specifying that the data should move online. I ...
0
votes
1answer
120 views

Cannot connect to 19c with SQL Developer though database is mounted and opened, error ORA-01034

I have recently had a server crash that is hosting both an 11g and 19c databases. Upon restart by IT staff, I discovered that one of the two 19c instances was idle. The 11g instances are all mounted, ...
1
vote
1answer
2k views

Cannot connect to Oracle database server through SQL Developer but Test works OK

I am new to Oracle (from a SQL server and MySQL background) and have just installed Oracle 11g2 Express Edition. I have downloaded SQL developer which appears to be the Oracle world's equivalent to ...
0
votes
1answer
1k views

Can't connect through sqldeveloper because locale not recognized even though my language/regional settings are English/US

On a certain machine I consistently cannot connect to an oracle db due to the locale not being recognized: Other people have noted the locale or language settings may not be compatible with the ...
0
votes
1answer
790 views

sqldeveloper file open dialog freeze

When I try to open a file using the file open dialog, sqldeveloper freezes for almost a minute. After that the dialog opens at the user temp folder. I think it is trying to access some unavailable ...
1
vote
1answer
1k 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 14....
2
votes
1answer
41 views

Where can I find SQL Developer Database examples (scripts) to add data to practice?

Where can I find SQL Developer Database examples (scripts) to add data to practice? I require SQL scripts that will add tables and data on those tables in order to practice with Power Bi.
0
votes
0answers
13 views

Error ora-12505

I've downloaded Oracle DB Developer VM. I've tried to make a connetion and I get this error. I checked my tsnnames.ora file and it looks like this: I've also tried to change host 0.0.0.0 to ...
2
votes
2answers
129 views

identifier 'DBMS_CDC_PUBLISH.CREATE_CHANGE_SET' must be declared [closed]

I am using oracle 11g express edition and I am getting the below error when trying to create a change set. Error report: ORA-06550: line 2, column 3: PLS-00201: identifier 'DBMS_CDC_PUBLISH....
6
votes
2answers
40k views

Oracle tnsping.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 tnsping.exe should go along with it - but this is not the case. Also I was surprised that SQL ...
0
votes
0answers
56 views

Compare previous column and current column in ORACLE SQL and do SUM

This is my query to get TIME_DIFFERENT-> TO_CHAR (DATE '1900-01-01' + ABS ( LAG(MODIFIED_DATE,1)OVER(ORDER BY MODIFIED_DATE DESC) - MODIFIED_DATE), 'HH24:MI:SS') AS TIME_DIFFERENT Now, I want to ...
-1
votes
2answers
124 views

Why would a scheduled job fail in SQL Developer?

I am trying to create a scheduled job in Oracle SQL Developer that would run once a month and I am testing the Scheduler/Jobs feature where I have created a simple SQL query to test the ability to do ...
0
votes
1answer
52 views

How do you change the storage parameters of a already made table (sql developer)?

Summarize the problem I have been given 6 tables that have all been created already and I was told to change the storage parameters of those tables. the issue I run into is that I can only change ...
0
votes
1answer
202 views

Oracle: ORA-00942: “table or view does not exist” in SQL Developer

in SQL Developer when i get session information he return me this error message: (ORA-00942: "table or view does not exist"). Can i resolve this with add grant to privilege of my user? Wich ...
0
votes
0answers
33 views

Pivoting dynamic columns

I trying to pivot a table creating the columns dynamically according to the rows. I'm using the clause PIVOT XML, but I'm not getting parse the XML column to columns. My table looks like this: I ...
5
votes
1answer
26k 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 ...
0
votes
2answers
10k views

How to solve Vendor Code 17002 when connecting to a remote Oracle database?

I have an Oracle database 12c standard edition release 12.2.0.1.0 running on a Linux instance of AWS ec2. When I try to connect to it remotely from my machine (macOS) using SQL Developer I get an IO ...
0
votes
0answers
45 views

Pass Variables to SQLDeveloper Report in anonymous block

I can pass variables to anonymous block of this form SQL> set serveroutput on; SQL> DECLARE a number := &i_nr; BEGIN ..... But it doesn't works into SQLDeveloper PL/SQL DBMS Output (...
7
votes
2answers
7k views

I get ORA-13605 when trying to run SQL Tuning Advisor from SQL Developer

When trying to use the SQL Tuning Advisor from SQL Developer I get this error. Tuning advisor was working some days before.
1
vote
0answers
62 views

Unit Testing ORDS - Oracle Rest Data Services

I've been wanting to develop some unit tests for my ORDS functions as part of my push for better CI/CD - I am running ORDS functions on an Oracle Autonomous Database 19c, and while I'm developing a ...
0
votes
0answers
759 views

Critical error and failing to parse data returned by server

I am currently running Oracle 12c, but unfortunately I am getting this critical error message: Fail to parse data returned by server I have never seen this error before and every attempt at ...
0
votes
2answers
43 views

Aggregate Query in SQL Developer

Below is my query. i get an error msg. it works when i remove the fields without the sum. I have added a screen shot of the data. Thanks! SELECT S.PRODUCT_ID, SUM(DISTINCT S.AWARD_AMT),...
0
votes
0answers
28 views

How to load generated Microsoft SQL Server database capture scripts into Oracle SQL Developer 19.4?

I'm following Oracle documentation to migrate an Microsoft SQL Server database to an Oracle schema. I have generated offline database capture scripts properly and I need to load those into Oracle SQL ...
8
votes
2answers
53k 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 ...
5
votes
6answers
54k 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 network....
0
votes
1answer
2k views

Error while opening SQL worksheet in SQL Developer

I am facing the following issue while opening SQL worksheet in SQL developer Popup with Error Message --> "An error occurred while opening ide.worksheet.file:/C:/users/%USERNAME%/Appdata/Local/Temp/...
0
votes
0answers
36 views

Export the table results into a text file automatically using sql developer

I have a table with contents as below +-----------+-------+ | Name | Value | +-----------+-------+ | IHA_NAME | Rexon | | IHA_Value | 65 | +-----------+-------+ I want to export this data ...
0
votes
1answer
109 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?
0
votes
2answers
16 views

Filtering based on data in excel

I was given an excel file with account numbers in them and told to write a query that returns the account numbers in the list that meet a certain criteria. While I was able to write the query in ...
1
vote
0answers
65 views

SQL Developer - can't create DB objects in mysql

I have SQL Developer Version 19.2.1.247 on Debian Linux, with Java version "13.0.2" 2020-01-14 (I know, not supported, but it seems to work), and JDBC installed from mysql-connector-java_8.0.19-...
0
votes
1answer
274 views

Unable to get the DBMS Logs in Oracle SQl Developer [closed]

I am using Oracle SQL Developer (Version 18.4.0.376) and Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product PL/SQL Release 10.2.0.1.0 - Production "CORE 10.2.0.1.0 Production" TNS for ...

1
2 3 4 5