7,666 questions
0
votes
2
answers
82
views
How to SELECT inside a DECLARE block? [duplicate]
Context:
As a developer in a large company, I am allowed to query (read-only) any table in the database and see the result (for debugging and investigation purposes).
When I do so (either from ...
- 1,794
1
vote
1
answer
45
views
error when access oracle server (with docker) from host sqlplus
[Q] How to fix ORA-29024: Certificate validation failure when connecting from host to Oracle in Docker?
my docker image: container-registry.oracle.com/database/adb-free:latest-23ai
ubuntu 24.04.1, ...
- 67
0
votes
1
answer
126
views
Oracle SQL DBLink with many tables and joins
I'm trying to execute an Oracle SQL query that can hit two different database servers at once. Both servers have the same table definitions however the SQL query is hitting many tables.
Simplified ...
- 178
1
vote
1
answer
84
views
Oracle SQL Developer claims missing select just because of end line comment
If I select all text in the SQL Developer and execute it, it works:
select 16 cc, date '2025-03-05' coDate, 18 nr, 594.34 tvaInc, 1 cat from dual union all
select 16 cc, date '2025-03-06' coDate, 22 ...
1
vote
1
answer
70
views
Adding a column with default value incorrectly fills a different column
After executing the following script:
alter table test_table
add (test1 varchar2(1 char),
test2 varchar2(1 char) default 'T' not null);
I got interesting results... both columns are filled with ...
- 63
1
vote
0
answers
142
views
Oracle SQLcl "project stage" incorrectly ordered changelog
I'm testing the recently released "project" feature in Oracle SQLcl (version: 25.1.1.0 build: 25.1.1.120.1002).
After watching some Oracle videos I decided to use the feature on a real ...
- 13
0
votes
0
answers
23
views
How do I add to an exsisting subject area in Oracle Fusion OBTI
I'm creating an analysis for invoices using the payables transaction invoices transaction real time subject area that has preselected columns. I would like to add a column from the notes table(...
- 13
1
vote
1
answer
131
views
Oraclesql developer with pem file
I need to connect to a oracle database which is SSL/TLS enabled and requires mutual auth. so i need client certificate to connect from oracle sql developer.
But i have only pem files with embedded ...
- 467
-3
votes
1
answer
101
views
SQL Developer (Oracle): How to find total disk space size of a result set [closed]
I have a query that returns a one column result set and I would like to know the total space size, not count, of that result set. The result set has over one million records. I could export it and ...
- 320
1
vote
0
answers
49
views
Oracle SQL Developer debug trigger
I am using version 23.1.1.345 of Oracle SQL Developer and cannot step through a trigger in debug mode.
I compiled the trigger for debug then executed code that would cause it to be invoked but the ...
- 665
1
vote
1
answer
178
views
REMAP_DATAFILE not working during Data Pump import on Oracle 19c
I'm trying to import a full database dump using impdp into a different Oracle 19c (Standard Edition 2) environment, but the REMAP_DATAFILE parameter doesn't seem to be working.
My goal is to import a ...
- 171
0
votes
0
answers
170
views
Debug PL/SQL with VS Code and SQLDeveloper extension
I am trying to get debug of PL/SQL working with Visual Studio Code and the Oracle SQLDeveloper extension.
To keep it simple, I have a single user with single stored procedure that I want to debug.
I ...
- 953
1
vote
1
answer
59
views
SELECT REF(...) works in SQL Developer but fails in SQL Developer VS Code Extension
I'm using Oracle Database 19c
When I run the following query in SQL Developer, it works fine:
SELECT REF(p) FROM persons p;
However, when I run the same query using the Oracle SQL Developer VS Code ...
0
votes
0
answers
32
views
Oracle: Sql Developer: Error in printing a clob output parameter of a stored procedure
I have an Oracle stored procedure that has an output parameter as a clob. I am trying to execute this stored procedure and print that output(about 1.5 MB) to dbms output in SQL Developer. The SP runs ...
- 1,041
0
votes
1
answer
66
views
How to display master and detail forms together?
Currently a Master-Detail page Oracle APEX shows the master table with detail tables below it for the report, and use separate forms for the master table and each detail table. How would I simplify ...
0
votes
2
answers
83
views
Oracle SQLDEv results grid export to excel: column size (in terms of data size in kb) limitation producing blanks
SQL DEV version
Oracle 22.2.1.234
Summary
Given that I have a table (simplified for question purpose) define as :
Doc ID (PK)
Doc text (XML/text/whatever)
DOC 1
Doc-1-text
Doc 2
Doc-2-text
Doc 3
Doc-3-...
0
votes
3
answers
93
views
Need to include a condition in my SQL lead function to check the previous year data when only one line of data entry is present for current year
I have an SQL query where I want to compare the data in a column with another line from the same column. So I included a LEAD function into my query.
However, when I run this query for the condition ...
0
votes
0
answers
36
views
select from with data separate for comma in Oracle DB [duplicate]
Good afternoon, I am currently doing a query of an SQL table and I want to bring an entire table (select * from) in values separated by commas, I have already managed to get it to come on a single ...
- 813
0
votes
2
answers
227
views
SQL Developer: Why are there no DDL options in my query result Export Wizard?
I need to export the results of a SQL query in Oracle SQL Developer (v. 24.3.1.347). I am using the SQL Developer Export Wizard (right-click on query results; select Export).
I have selected the "...
0
votes
1
answer
130
views
Create multiple reports dependent on another report?
I'd like to create a master query / report in Oracle SQL Developer, against which I can create multiple other reports.
e.g. create a master query / report which returns a list of values (known as '...
- 75
0
votes
1
answer
87
views
PLS-00357: Table,View Or Sequence reference not allowed in this context when execute immediate inside block
I'm trying to use variables in a ALTER SEQUENCE statement inside a BEGIN END block.
When hard coding the Schema name and the sequence name it works perfectly. But when I try to use variables instead ...
- 76
1
vote
0
answers
45
views
Sql*Developer: i/o error: The Network Adapter could not establish the connection
When trying to connect to the database in sql*developer, I get the following line:
An error was encountered performing the requested operation:
I/O Error: The Network Adapter could not establish the ...
- 11
0
votes
0
answers
25
views
Process to achieve bulk load using external table and SQL Loader
I never worked on External table and SQL loader before .Can someone please explain the steps to acheive the bulk loaing using external tables and SQL loader
- 23
1
vote
0
answers
312
views
Missing ORDS_Metadata and Deprecation of java -jar ords.war install advanced Command
I have successfully installed Oracle REST Data Services (ORDS) by deploying the ords.war file and running the ords install command, followed by linking my Oracle database. The setup seems to be ...
- 11
-2
votes
1
answer
326
views
How to connect to Oracle EBS R12 vision instance's database using SQL developer
I installed on my PC the oracle EBS R12 vision instance, and I'm able to use the application perfectly (i'm running it on VirtualBox within my Windows PC). But I could not connect to EBS vision ...
