Questions tagged [oracle-sqldeveloper]
Oracle SQL Developer is a free and fully supported graphical tool for Oracle database development.
oracle-sqldeveloper
7,623
questions
0
votes
1
answer
28
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 ...
- 121
1
vote
2
answers
25
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
25
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
22
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
38
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
137
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
44
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
22
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
49
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
32
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
0
votes
0
answers
21
views
Other ways to connect to Oracle DB through sqldeveloper?
anyone here aware of any other ways to connect to Oracle DB apart from the below mentioned ones?
1- user id and password.
2- proxy user connection / Kerberos connection.
different ways to connect to ...
- 1
0
votes
0
answers
22
views
Not All Variables Bound
I have clob variable which is storing the sql statement to execute and I am assigning the sql output in table type object.
EXECUTE IMMEDIATE v_sql BULK COLLECT INTO result_table;
CREATE OR REPLACE ...
- 11
0
votes
1
answer
19
views
How to save the node positions of an entity-relationship (ER) diagram in Sql Developer
I have generated an ER Diagram for a schema with lots of tables, by following this approach
After generating it, I re-positioned all the nodes (tables) in the diagram (Relational Model) so that they ...
- 10.5k
0
votes
0
answers
51
views
Executing Oracle User Function Truncating the Result
I am trying to run an Oracle user function that returns a SQL query. This SQL Query is used for an SSRS report. I want to get the exact query that the report sends to the Oracle DB.
I am trying to ...
- 115
0
votes
0
answers
21
views
Unable to Type anything in sql developer web not even apex sql command window
I am unable to type anything in sql developer web from oracle cloud console not even apex sql command window in oracle apex, the erorr is
Oracle Apex Cloud sql command window:
{ "code": &...
- 1