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.

51 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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, ...
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 ...
2
votes
0answers
96 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
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
vote
0answers
64 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 ...
1
vote
0answers
67 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-...
1
vote
0answers
17 views

Is there a way to pass tnsname.ora while launching the oracle sql developer Client via command prompt

Is there a way to pass tnsname.ora while launching the oracle sql developer Client via command prompt? Or is there a way to overwrite the usr directory location where the connection.xml folder is ...
1
vote
0answers
55 views

Missing CALLs on identifiers_all using PL/SCOPE

Posted this on StackOverflow, but maybe this is the right place for it: I'm trying to use the view all_identifiers from PL/SCOPE to find out calls to procedures and functions but it's not showing all ...
1
vote
0answers
51 views

Is it possible to execute “begin transaction” when connected to MS SQL server with Oracle's SQL Developer?

I am using Oracle's SQL Developer to execute SQL statements on an MS SQL Server instance. Apparently, SQL Developer recognizes specific Oracle related keywords such as begin. Thus, when I try to ...
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 ...
1
vote
0answers
2k views

Oracle Network Encryption from SQL Developer

I'm configuring Oracle Network Encryption on my Amazon RDS Oracle SE2 12.1 instance per these instructions. I've got the RDS instance configured with the appropriate option group, enabling network ...
1
vote
0answers
484 views

How to connect to Oracle 11g using Oracle-SQL-Developer from a Mac

I am currently running Oracle 11g on my Windows 10 machine, but I use my mac a lot and I want to connect to the installed Oracle 11g on my windows from my mac using SQLDeveloper. How can you achieve ...
1
vote
1answer
876 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 ...
1
vote
0answers
274 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): ...
1
vote
0answers
1k views

Why is there a difference in CSV Export Results of Oracle SQL Developer and SQL Plus Spool

When I export data from SQL Developer GUI, setting format: csv, left enclosure: ", right enclosure: ", and Encoding: UTF8, I get data exactly the way that I need it for processing in Python. However,...
1
vote
0answers
1k 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 ...
1
vote
0answers
812 views

ORA-01861 - Input seems ok and FX/FM modifiers not used

Using SQL Developer 4, I am getting an ORA-01861 exception when I do the following (and BTW, I ticked 'Ignore NLS Definitions'): alter session set nls_date_format = 'DD-MON-YY'; alter session set ...
1
vote
0answers
207 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 Customers.Am ...
0
votes
1answer
7 views

Adding underscore(_) in a record in Oracle table

I want to add underscore (_) for around 4000 records in one of table. How can I achieve this?? Note : Records are present in table like this "I am Yash" and I want to change it like this &...
0
votes
0answers
10 views

How can I tell SQLDeveloper which Oracle jdbc driver to use?

I need to connect to an Oracle 9i server from my machine using SQLDeveloper. I already have a functioning version of SQLDeveloper 18.2 + Oracle Client 12, but for this connection I want a seperate ...
0
votes
0answers
24 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
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
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
18 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 ...
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 ...
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 ...
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 ...
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 (...
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 ...
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 ...
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
311 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\...
0
votes
2answers
967 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
55 views

How to build a query that gets its values from a file

I'm trying to build a query that uses the values in a file select Epm,Emp_num,Emp_Addr From Dir_Rimco_Table where Emp in (Dir_Emp_Rsed.txt) Constraints -I can't create a new table -I can't modify ...
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, ...
0
votes
0answers
271 views

sql developer pop up is not responsive

I use SQL Developer version 17.3.1.279. I try to save a file with File > Save. When the 'save' window opens, it is unresponsive, meaning that: the 'location' combo is not clickable icons such as ...
0
votes
0answers
1k views

Help with Connecting to SQL Server using Oracle SQL Developer

I am trying to connect to SQL Server using Oracle SQL Developer. I was able to get the SQL Server JDBC installed on SQL Developer and am able to see the SQL server Tab on the Connections page. I have ...
0
votes
1answer
164 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
0answers
761 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
1answer
795 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 ...
0
votes
1answer
552 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
1answer
21 views

Padding in info given a types table

Suppose I have the following schema for professions: id, type, likelihood. id is the id of the person in question, and I have info regarding the likelihood that that person will read a certain type of ...
0
votes
1answer
39 views

cant access both phone numbers in my nested table type

Im using Oracle Developer and I have a customers table where each customer has 1 home-phone number beginning with 0131 and either 1 or 2 mobile numbers. I am trying to display the customers name and ...
0
votes
0answers
43 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
595 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 ...
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
101 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 new ...
0
votes
1answer
132 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, ...