Questions tagged [oracle-sqldeveloper]
Oracle SQL Developer is a free and fully supported graphical tool for Oracle database development.
oracle-sqldeveloper
7,626
questions
1
vote
1
answer
15
views
VS Code Drag and Drop Database to .ipynb Not working?
Currently test driving the new Oracle SQL Developer extension for VS code and was referencing this Youtube Video: https://youtu.be/e-yqkI0t6dQ?t=2784
Noticed the presenter had a database open and ...
- 165
0
votes
1
answer
38
views
Invalid characters in VARCHAR2 column - Oracle
I want to find out what characters are not supported in my VARCHAR2 column in Oracle. When I filter a VARCHAR2 field using asciistr(column) <> column (query provided below), I see that some ...
0
votes
0
answers
38
views
SparkException: Job aborted stage failure: Task 0 in stage 278228.0 failed 4 ti, java.sql.SQLRecoverableException: IO Error: Connection reset by peer [closed]
While ingesting data from Oracle to databricks(writing into ADLS) using jdbc I am getting connection reset by peer error when ingesting a large table which has millions of rows.I am using oracle sql ...
0
votes
1
answer
39
views
What's the use of the vertical line at 1/3 of the sqlDeveloper worksheet page [closed]
i want to ask this question out of curiosity, what's the use of the vertical line in the sql deeveloper worksheet ?
here a screenshot to let you know what i am talking about even if the resolution is ...
1
vote
2
answers
47
views
My Oracle database 21c express is duplicating my query result in the result tab
The oracle database developer is duplicating my queried data in the table, for example, in the attached screenshot I only insert two rows in each of the 3 tables i.e student table, course table and ...
0
votes
1
answer
42
views
Migartion of data from oracle DB to postgreSQL DB
I have a requirement to migrate data from AWS RDS Oracle DB instance to on-prem PostgreSQL DB,
I have manually created DB tables in PostgreSQL (replica of Oracle tables) now I'm trying to load the ...
- 115
1
vote
2
answers
26
views
Cannot figure out "invalid datatype" error in query
CREATE TABLE
Problem: "invalid datatype" error
Expected result: Create table "Appointment"
Have created multiple tables previously with the same datatypes, minus time. All foreign ...
- 11
0
votes
1
answer
26
views
Oracle.ManagedDataAccess query doesn't work in C# but works in SQL Developer
I'm using Oracle.ManagedDataAccess for running my application, basically I tested out the sql in SQL Developer and now want to port that over to .NET.
Let's say I have a user which has all the rights ...
- 750
0
votes
2
answers
24
views
In oracle SQL developer, how do I automatically generate a relational diagram which is 2 "levels" deep
this is the "model" tab I click to generate a relational diagram
However, this function only generates the the immediate relations (table A to B). Is there a way to generate relations by 1 ...
2
votes
2
answers
42
views
Issue selecting table in database using oracledb python module and local Oracle 21c database
I installed a local database and used SQL Developer to create a test table.
Database connection works, also the table is created and populated;
example here
Running this example code in Python throws ...
1
vote
5
answers
140
views
Group By and check if the group contains
I have houses that can have fixtures 'Sink, 'Faucet' and/or 'Toilet'.
I want find which houses have at least one fixture from the list, but are missing other fixtures and return the missing fixtures.
...
0
votes
1
answer
53
views
Mulesoft Getting timestamp format issue
My date input is createdate=20230425(yyyyMMdd) and I am trying to delete records from oracle database
Query: Delete from employee where create_date = :createDate
In oracle,field DataType is DATE (25-...
- 27
0
votes
2
answers
25
views
SqlPlus works, but SqlDeveloper gives ORA-12505 TNS listener error when making a connection
I've installed Oracle 19c Enterprise on a Windows Server 2019. After installing, I used SQL Plus to connect as "SYS as SYSDBA" account successfully, and made queries etc.
However, when ...
- 1
0
votes
0
answers
86
views
Oracle: Error when compiling any stored procedure . WaitCursor.hide called without matching WaitCursor.show sql developer
I created a new Oracle RDS from an existing snapshot. But when I try to compile any existing procedure I get this error on SQL Developer :WaitCursor.hide() called without matching WaitCursor.show().
...
0
votes
2
answers
35
views
Oracle SQL Query To Calculate Length of Service For Employees With Multiple Termination and ReHire Dates
I am trying to calculate the length of service of our employees within our Oracle database. Below is a table with some example data for two employees. The calculation would be from the first HIREDATE ...
- 57