Skip to main content
3,476 questions
Newest Active Bountied Unanswered
Advice
0 votes
2 replies
45 views

So I have been tasked to automate numerous reports which i succeeded mostly apart from this one case, I tried many recommendations from chatgpt but most were busted, the broken excel file started ...
Cheney raj Chadalavada's user avatar
  • 1
1 vote
1 answer
61 views

[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, ...
Doodu's user avatar
  • 67
-1 votes
1 answer
53 views

I have a procedure run_rest. Executing this procedure in sqlplus works perferctly - i get response from external system. But executing this in plsql developer throws 400: Bad request. Does someone has ...
q4za4's user avatar
  • 700
0 votes
1 answer
45 views

Simple problem. For audit purposes, a new set of steps was initiated when we sign into an Oracle DB using SQLPlus. At the first SQL> command prompt, we immediately activate spool to a file with a ...
TomV's user avatar
  • 1
1 vote
0 answers
177 views

I would like to change in my file sqlnet.ora from OSMSFT:// to MSLSA: to integrate Microsoft security. The problem come when I try to open a database in with authentification Kerberos like : sqlplus /@...
SRI_Techno's user avatar
  • 59
-1 votes
1 answer
50 views

(Context: I have literally only 30+ hours on SQL & its concepts; Just started fiddling with Oracle, mysql workbench) A screenshot that depicts what I said below Currently, I have an ERD that has ...
newbie_tweaker's user avatar
  • 1
1 vote
1 answer
51 views

I am using matlab to fetch data from our process database (AspenTech infoplus.21 historian). I constantly find myself looking for interesting time intervals. Usually I do this in matlab after first ...
danneedebro's user avatar
  • 67
1 vote
2 answers
61 views

How to call a stored procedure from SQL*Plus with blob input parameters? Below a sample of the SP to be called: procedure p_dummy_proc (sessionId varchar2, accountId integer, lobData blob, oId out ...
Alessandro Cucina's user avatar
  • 158
2 votes
1 answer
106 views

The output I need (I need to add multi-line headers): The output I am getting: My Query: -- Enable SQL*Plus HTML Markup SET MARKUP HTML ON SPOOL ON PREFORMAT OFF ENTMAP ON SPOOL "C:\...
Mehak's user avatar
  • 23
0 votes
1 answer
88 views

Output needed in this format: I am using SQL*Plus to generate an HTML report from an Oracle database using SET MARKUP HTML ON. However, the output file contains raw HTML tags as plain text instead of ...
mhk's user avatar
  • 21
1 vote
1 answer
19 views

I have shell script which inserts/updates data into oracle tables, what I don't understand is there is no explicit COMMIT in the script but data is committed to database, how is this possible? I have ...
Aravind's user avatar
  • 149
0 votes
1 answer
88 views

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 ...
gwinnem's user avatar
  • 76
1 vote
0 answers
49 views

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 ...
buggi's user avatar
  • 11
0 votes
1 answer
429 views

I am trying to connect to oracle database in mac system. My team generally works on Java so for development. we generally do this to connect to db in java. We connect to ssh tunnel which allows us to ...
Bhavin 's user avatar
  • 45
0 votes
2 answers
77 views

I am trying to input an Oracle query statement into a variable in a Unix shell. I want to remove the header of the SQL result value, so I want to include "set heading off" in the QUERY ...
SEUNGJAE MOON's user avatar
  • 1

15 30 50 per page
1
2 3 4 5
…
232