2022 Developer Survey is open! Take survey.

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
0 answers
12 views

Failed to run sqldeveloper in Ubuntu 22

I am trying to run Oracle sqldeveloper in my Ubuntu 22 VM. I downloaded the sqldeveloper zip file and ran below code sudo unzip ~/Downloads/sqldeveloper-3.2.20.09.87-no-jre.zip Then I ran cd ...
user avatar
  • 101
1 vote
1 answer
28 views

Get explain plan for query with inline function

I have a query that has an inline function: with function with_f(p_text in varchar2) return varchar2 is begin return p_text; end; select with_f(dummy) from dual Is there a way to get the ...
user avatar
  • 1,377
0 votes
1 answer
23 views

How to get DML SQL of uncommited statements in Oracle 19c?

I'd like to know if there is a way to get the DML (insert, delete) SQL of uncommitted statements in Oracle 19c in my own session? For example, if I have typed some statements and I haven't committed ...
user avatar
-2 votes
1 answer
26 views

Trying to understand this quiz question on INSERT

Why will there be 2 rows and not 1? The rollback is meant to take it back to the last COMMIT function which in this case is inputted after one INSERT
user avatar
-2 votes
1 answer
26 views

Why will this query only produce 1 row and not 2? And why does it have a value of 11 and not 1? [closed]

What do I need to change to make this query output 2 rows, first value 1 and second value 10? CREATE TABLE cars (car_id NUMBER, top_speed NUMBER); CREATE SEQUENCE car_counter START WITH 1 INCREMENT ...
user avatar
-4 votes
1 answer
33 views

How do I line the SELECT LIST with the rules of of VIEW creation in this query? [closed]

I'm trying to understand exactly where I went wrong in this query
user avatar
0 votes
2 answers
42 views

How to request enhancement to Oracle SQL Developer

Regarding Oracle's SQL Developer tool: Is there a way to request that Oracle make an enhancement to the tool? For example, I want to ask Oracle to add this functionality: Generate WITH clause from ...
user avatar
  • 1,377
0 votes
1 answer
26 views

sqldeveloper export tool ignores filter by schema

I'm trying to export an Oracle schema to an .sql file. It has no tables, but it has some custom types and packages. During the steps "specify objects" and "specify data" I click &...
user avatar
  • 223
0 votes
1 answer
60 views

How can I get SQL Developer to compile code that includes code within the DDL?

I am preparing SQL scripts that can deploy a set of code to a target environment with minimal fuss. I want the executing DBA to just sign on to the target database and execute "install_release....
user avatar
0 votes
0 answers
30 views

How to store data in loop and after assign data set to out ref cursor in Oracle

I tried to store date in loop and after that dataset set to OUT SYS_REFCURSOR. In this time I declared array variable and I tried to store data in loop by each iteration. and after, I want to assign ...
user avatar
0 votes
0 answers
28 views

SQL query to fetch data between 2 date columns from 2 different tables

I am trying to fetch data from two different tables which contain two date columns: ENCODINGDATETIME and CREATEDON. I need those records where days gap between the ENCODINGDATETIME and CREATEDON ...
user avatar
0 votes
1 answer
44 views

SQL Developer: View only permissions

I am using SQL Developer, generally to assist in writing reports against various databases but there is one application that is run on an annual basis and at the end of that processing (about a 3 hour ...
user avatar
  • 11
0 votes
0 answers
33 views

How to find and delete partial duplicates in Oracle

I'm deleting duplicate values in an Oracle database using this: DELETE FROM results a WHERE a.ROWID IN (SELECT ROWID FROM (SELECT ROWID, ROW_NUMBER() OVER (PARTITION BY sample_id, ...
user avatar
0 votes
2 answers
66 views

Oracle Lag() on date output wrong data [closed]

Oracle DB 19 - Sql developper 19 - NLS DD-MON-RR I have a table ID NAME EFFDT NODE PARENT SHA DEPT 01-JAN-01 A10200 TOP SHA DEPT 04-JAN-11 A10200 X10200 SHA ...
user avatar
  • 9
0 votes
0 answers
18 views

Using Oracle SQL Developer Data Modeler - How do you create a Relational Model based off selected tables and tables related to them

I have a database with about 900 tables that I'm reverse engineering. I've identified 30 tables and have been able to create a new relational model view for those. The next step is I want to add any ...
user avatar
  • 101
-3 votes
1 answer
127 views

How to get the top record from each set of group [duplicate]

This question is for Oracle SQL DEV What I am trying to accomplish is to pull the top record for each person (last name + First name + Dob), using their most recent travel date. To help illustrate my ...
user avatar
0 votes
1 answer
266 views

ORA-03114 Unable to connect to remote Oracle database

I have an Oracle Database installed on Oracle Linux Server which I'm trying to connect to from my PC. I have configured the listener in the following way [oracle@ol8ngs1 ~]$ lsnrctl status LSNRCTL ...
user avatar
0 votes
0 answers
11 views

Oracle Data Miner: Exception when run Transformation node

I'm trying to learn Oracle Data Miner. It works well but I have an issue with Transformation node. I cannot make Transformation node work even when there are no any transformation. It seems there is a ...
user avatar
2 votes
3 answers
72 views

Ordering streets by their names and polysyllabic numbers in SQL query

In Oracle DB there is a table with some data: LAG HNR STREET 00020 44 Aachener Straße 00020 44/2 Aachener Straße 00020 44/1 Aachener Straße 00020 46 Aachener Straße 00020 46/6 Aachener Straße ...
user avatar
  • 167
0 votes
1 answer
558 views

Case statement in update statement

I am trying to update a table. I want to use a case statement to decide what column to update. I keep getting the error message, "syntax error at or near "case"." Can someone ...
user avatar
-3 votes
1 answer
237 views

Cannot connect new users to pluggable database

I'm new to Oracle DB (coming from MS SQL Server). For a start, I downloaded a Docker container for Oracle Database 18c XE. When I run that container, after creating a pluggable database, I don't seem ...
user avatar
  • 123
-1 votes
1 answer
73 views

Oracle SQL: How to get order of operations on multiple AND and OR conditional groups in this query

I am not very familiar with Oracle operators precedence, my question is how do ORACLE process the order of operations in multiple AND and OR blocks, and how can I properly use the parentheses so the ...
user avatar
  • 99
0 votes
1 answer
25 views

Counting failed attempt

Here is my code: create table failed_login_attempts( login_id number(5) primary key, date_created timestamp default systimestamp, email varchar2(110), ip varchar2(24), mac varchar2(18), attempt number(...
user avatar
  • 13
0 votes
3 answers
344 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
user avatar
3 votes
4 answers
77 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 | +-----+-----------+-----------------...
user avatar
  • 167
-1 votes
1 answer
217 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:...
user avatar
  • 125
0 votes
2 answers
9k 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 ...
user avatar
  • 133
0 votes
1 answer
178 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 ...
user avatar
0 votes
1 answer
144 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 ...
user avatar
0 votes
1 answer
614 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, ...
user avatar
2 votes
1 answer
53 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.
user avatar
2 votes
2 answers
377 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....
user avatar
  • 121
0 votes
0 answers
81 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 ...
user avatar
  • 15
-1 votes
2 answers
432 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 ...
user avatar
0 votes
1 answer
227 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 ...
user avatar
  • 107
0 votes
1 answer
901 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 ...
user avatar
0 votes
0 answers
67 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 ...
user avatar
0 votes
2 answers
27k 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 ...
user avatar
  • 143
1 vote
0 answers
173 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 ...
user avatar
0 votes
2 answers
69 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),...
user avatar
  • 1
0 votes
2 answers
20 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 ...
user avatar
  • 1
1 vote
0 answers
126 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-...
user avatar
  • 221
0 votes
1 answer
585 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 ...
user avatar
1 vote
0 answers
36 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 ...
user avatar
1 vote
1 answer
336 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 ...
user avatar
1 vote
0 answers
59 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 ...
user avatar
0 votes
1 answer
4k 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 ...
user avatar
  • 11
0 votes
1 answer
2k 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 ...
user avatar
0 votes
1 answer
347 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 ...
user avatar
  • 101
0 votes
1 answer
140 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. ...
user avatar

1
2 3 4 5 6