Skip to main content

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
16 views

Select, Filter and Sort ist not working with Oracle SQL Developer

I am using SAP ADBC to UPDATE some Oracle database entries. It's working and the data appearance in the SQL Developer between "normal" and UPDATED entries look same. But when I use a, SELECT ...
Fuat's user avatar
  • 1
0 votes
0 answers
15 views

"Soft-wrapping" data in SQL Developer

Can I "soft-wrap" data in SQL Developer? I mean data in query results' columns. If so, how? Version 23.1.1.345
demavi's user avatar
  • 109
1 vote
0 answers
11 views

Oracle SQL Developer - Find Database Object -- schema checkboxes shift position on restart - anyone have a fix for this?

I'm using Oracle SQL Developer Version 21.4.1.349 on Windows We have a large number of schemas. I only work with 3 of them. When I need to find something using the Find Database Object function, I ...
J.C.'s user avatar
  • 11
0 votes
0 answers
48 views

See an arbitrary SQL statement in oracle enterprise manager

I like to see any sql statement in the Oracle Enterprise Manager (oem) Cloud Control 13c, e.g. in the active session history. A simple select is not shown in any view. After some research I found in ...
th0rn's user avatar
  • 1
0 votes
0 answers
109 views

How to get last executed statement on a particular table in Oracle?

Trying to identify what ghost process is inserting records into a particular table. Is there a way to get the exact query?
Dhaval Mohandas's user avatar
0 votes
1 answer
69 views

how to get explain plan from pl/sql function call?

consider this working pl/sql block: declare o_result boolean; io_error varchar2(30000); tab1 someTable1; tab2 someTable2; begin tab1(1).col1 := 'str'...
gabriel119435's user avatar
0 votes
1 answer
31 views

Use Field Value as where clause statement

is it possible to use the select statement result as where clause statement/Condition in oracle SQL? Eg: Condition_txt(FIELD) = 'AND b.mpal03d >= TO_DATE('01/10/2012','DD/MM/YYYY')' (Value of ...
iHateBugs's user avatar
0 votes
0 answers
45 views

Truncate Partitions greater than year 2015

I need to update the data in a table partitioned by year by truncating every time the partitions greater than 2015 and inserting again the updated data from the source system. But I think that we can ...
DS_Tn's user avatar
  • 3
0 votes
0 answers
104 views

one to one relationship in SQL Modeler

USING ORACLE SQL MODELER I am trying to make Relationship between 2 entities (Roles and Users). The Users table has role_id as a foreign key. The Relationship between Roles(1) and Users(Many) is 1:N, ...
datascinalyst's user avatar
0 votes
0 answers
249 views

Cannot cannot to database using sql developer: a connection attempt failed because the connected party did not properly respond after a period

I am using a windows laptop and installed sql developer version 23.1.0. When I input the connection details for my database I get the following error: a connection attempt failed because the ...
What is in a name's user avatar
1 vote
4 answers
102 views

Loop through 30 columns in Oracle DB to check if a value exists

I have a table which contains an ID in column one and that ID can have up to 30 different codes and dates associated with it. ID | CODE_1 | CODE_1_DATE | CODE_2 | CODE_2_DATE | CODE_3 | CODE_3_DATE ...
Rellek's user avatar
  • 13
0 votes
0 answers
85 views

find Sqldeveloper 19.2 download link

Im trying to find a link to download and install this version but it impossible. Dont appear on oracle. Someone knows any link or place to install it? thanks!!
Sergiooo87's user avatar
0 votes
1 answer
565 views

How to connect / auth users to Oracle pluggable DB using SQL developer

I am struggling connecting to a pluggable DB for which I created local users. I have an Oracle 21c XE on my machine. The CDB is XE. I logged into SID=XE with sys as sysdba. There I created a PDB as ...
Joysn's user avatar
  • 103
0 votes
1 answer
329 views

SqlDeveloper - Real Time SQL Monitor doesn't log statements even though I can see them in Sessions

I'm trying to trace an application that is running on my machine. In SQL Developer, I go into Real Time SQL Monitor and run the tool. I can see various queries being logged, but none from the ...
Coxy's user avatar
  • 111
1 vote
1 answer
233 views

I have data with column names as dates and I need to unpivot this columns into Dates column and values. How can i get this in oracle SQL developer

so my input_table is This is to be unpivot the columns of dates into Date and Values as in the output What is the oracle SQL developer code I need to write to achieve this output table. Please help ...
BHASKAR LAHARI's user avatar
0 votes
2 answers
3k views

Truncate tables in other schema

I have logged into a dev02 schema with a user and password and another schema dev08 with a different user/password in the Oracle database. Now from dev02, I run the command: truncate table dev08....
nicku's user avatar
  • 101
1 vote
2 answers
313 views

How to view data of a failing row in a view

I've the following situation: I've a view where there's a row that somehow generates incorrect data and when it's attempted to be visualized or exported it shows an error message like this: 00000 - &...
user2638180's user avatar
0 votes
1 answer
683 views

Connect to remote Oracle database from local SQL Developer client

I installed Oracle Linux 21c on the remote machine, tested it in Linux shell, and it worked as expected (I can query the testing table I created). But I am stuck when trying to connect to the database ...
geopark's user avatar
0 votes
2 answers
57 views

Converting string with DIN 1421 pattern to human-readable

In the Oracle DB there is a table that stores "DIN"s attribute (VARCHAR2(1200 BYTE)), see a table/image below. Each string follows the DIN 1421 pattern. +------------------+ | DIN ...
Taras's user avatar
  • 177
0 votes
1 answer
37 views

Is it safe to export and then import encrypted database information in Oracle SQLdeveloper?

I'd like to perform some tests in a database by deleting the content of certain tables and then restoring the content they previosuly had once the test is finished. But problem is that these tables ...
mylket's user avatar
  • 103
-1 votes
2 answers
50 views

Find in what table I can find multiple collumns

I am trying to write a query that will show me the tables that contains all the following columns: ProductGroup, ProductClass and ProductID. But I am not very successful at it. Can somebody help me ...
AnTiCoD's user avatar
0 votes
1 answer
418 views

schema ownership/permissions in MS-SQL vs Oracle

Hopefully I'm using the write terms here. I'm pretty good with concepts usually but don't always know the technical terms to describe it correctly. Here goes... I'm used to working in MS SQL Server ...
jessieloo's user avatar
  • 173
1 vote
1 answer
91 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 ...
User1974's user avatar
  • 1,477
0 votes
1 answer
116 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 ...
Metafaniel's user avatar
-1 votes
1 answer
47 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
Jay Jason's user avatar
-2 votes
1 answer
35 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 ...
Jay Jason's user avatar
-5 votes
1 answer
37 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
Jay Jason's user avatar
0 votes
2 answers
116 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 ...
User1974's user avatar
  • 1,477
0 votes
1 answer
108 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 &...
basin's user avatar
  • 282
0 votes
1 answer
645 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....
Jeromy French's user avatar
0 votes
0 answers
373 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 ...
Neo4242's user avatar
0 votes
1 answer
280 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 ...
Gaberax's user avatar
  • 11
0 votes
2 answers
387 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 ...
Nan0's user avatar
  • 29
-2 votes
1 answer
3k 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 ...
SQLPhan's user avatar
  • 11
0 votes
1 answer
2k 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 ...
dontMashMe's user avatar
2 votes
3 answers
135 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 ...
Taras's user avatar
  • 177
0 votes
1 answer
7k 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 ...
Weston Bridson's user avatar
-3 votes
1 answer
1k 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 ...
AxD's user avatar
  • 133
-1 votes
1 answer
510 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 ...
Tony77's user avatar
  • 99
0 votes
1 answer
129 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(...
MikeJ's user avatar
  • 13
0 votes
3 answers
2k 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
Jayachandran Jayaseelan's user avatar
3 votes
4 answers
1k 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 | +-----+-----------+-----------------...
Taras's user avatar
  • 177
-1 votes
1 answer
1k 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:...
Casivio's user avatar
  • 125
1 vote
2 answers
22k 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 ...
Gustavo's user avatar
  • 163
0 votes
1 answer
593 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 ...
Vaisakh P's user avatar
0 votes
1 answer
606 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
1k 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, ...
Daniel Grindstaff's user avatar
2 votes
1 answer
195 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.
Rodolfo Villalta's user avatar
2 votes
2 answers
961 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....
lse23's user avatar
  • 131
-1 votes
2 answers
1k 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 ...
Andrew Hicks's user avatar

1
2 3 4 5 6