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
1answer
8 views

Adding underscore(_) in a record in Oracle table [closed]

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
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
61 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
384 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
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
19 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
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 ...
0
votes
1answer
134 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, ...
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
138 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....
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
133 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
56 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
217 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 ...
0
votes
2answers
11k 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 (...
1
vote
0answers
65 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
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 ...
1
vote
0answers
68 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
289 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
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
1answer
202 views

Disable autocommit for DB2 connection in Oracle SQL Developer

I am connecting to the DB2 database using oracle SQL developer, but automatically it is committing, i checked in the advanced menu the auto commit feature is turned off. I am confused now, can someone ...
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 ...
0
votes
1answer
2k views

Connection Error while connecting SQL Developer with DB2

I am trying to connect Oracle SQL Developer with DB2 Database. I have added db2jcc4.jar, db2jcc.jar and db2jcc_license_cu.jar Libraries in "Third Party JDBC Driver" DB2 tabs appears Entered Username ...
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
164 views

write SQL query that takes its own output as input

In a table that displays how trades are related to each other, starting from one trade, I want to find all other trades that relate to the first trade: 713613 PostPTETradeIDs 718478 713613 ...
0
votes
1answer
69 views

I didn't get listener file get installed

I have downloaded oracle sql developer to access Remote database. After downloading i couldn't connect to the database. I don't have tns.ora file installed in my system neither do i have oracle_home. ...
-1
votes
2answers
6k views

How to check sql query execution time in sql developer

I need to check any sql Statment exact execution time (how much time it will take to complete that sql Statment without running this query) in Oracle sql developer tools without running that sql ...
0
votes
1answer
312 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
972 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 ...
1
vote
0answers
52 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 ...
2
votes
1answer
136 views

Oracle isn't restoring correctly a backup

First of all I'll say I'm using: Oracle Database 11g Express Edition Oracle SQL developer What I'm trying to achieve Create a backup and restore it, so for example I can delete a table after a ...
2
votes
1answer
420 views

Missing right parenthesis after (or before) default 0, Oracle

I am trying to create a table with Oracle SQL where two columns of the table should have a default value and should not be NULL. I am getting the error you can see below, but i am not able to ...
0
votes
1answer
658 views

SQL Developer export/import SSH hosts

Is it possible to export/import ssh hosts from SQL Developer? The hosts are listed under C:\Users\name\AppData\Roaming\SQL Developer\system17.4.0.355.2349\o.sqldeveloper.ssh but I don't find a way to ...
0
votes
1answer
1k views

How to force SQL developer to use imp/exp command while import/export

While importing or exporting oracle data dump using SQL Developer by default it is using impdp command for import and expdp command for export. But I want to import a dump which is exported using exp ...
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
1answer
915 views

How to rearrange columns in Oracle SQL Developer script output

maybe this is an already answered question, but I am relatively new to Oracle DB and couldn't find my answer around the Internet. So I have created a table in Oracle and when running the SELECT ...
5
votes
1answer
9k views

“New query window” shortcut for Oracle SQL Developer

I'm used to Ctrl-N to give me a new query window in SSMS. How do I do it in Oracle?
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 ...

1
2 3 4 5