29,149 questions
Score of 3
1 answer
101 views
SELECT INTO IN Parameter not possible
I was working on a function, where I wanted to have one optional IN Parameter at the end, with DEFAULT NULL. As an example:
FUNCTION calc_due_date(
p_invoice_id IN NUMBER,
...,
p_user_id ...
- reputation score 23
Score of 2
2 answers
247 views
View query results from a PL/SQL block without PUT_LINE, RETURN_RESULTS, or CREATE?
I'm trying to create a PL/SQL block that will generate a query in the client interface, but I'm having difficulty due to my restrictions and the restrictions of the client.
My restrictions are that I ...
- reputation score 23
Score of 0
0 answers
69 views
Add error message to stack if apex_web_service.make_request fail
In Oracle apex, I have a page with SUBMIT button. On page submit, following happens
Execute "procedure_do_call"
'procedure_do_call' makes a REST API call using apex_web_service....
- reputation score 609
Score of 1
2 answers
213 views
Calculate customized ASCII values without using Loop/Cursor
I want to convert the following loop based query (from Oracle) to a set-based query (to PostgreSQL) without using Loop/Cursor.
The following code used to calculate/generate numeric values for the ...
- reputation score 7411
Score of 0
4 answers
176 views
Shorten a Union All query in which most elements are exactly the same?
I'm working with Oracle SQL 20.2 and writing a PLSQL procedure. The main body of the procedure is a Select query in which I make use of UNION ALL to get rows from two different tables that join onto ...
- reputation score 123
Score of 0
1 answer
167 views
How to return correct record if multiple records have same value in oracle sql
From_step
To_step
Step
4210
0088
B234210
0088
4210
B240088
4210
4600
B234210
As you can see my table above, 4210 returns twice which has multiple record, so in my case it returns B234210 twice, by ...
- reputation score 1
Score of 0
3 answers
139 views
I need to pass changes on certain tables to external system but am worried not to skip anything [closed]
I need to pass changes on a table to external system. Let's say I have table of messages. I have a column called change_id which is populated by trigger from a sequence on insert and update. ...
- reputation score 113
Score of -2
4 answers
208 views
What Java and JDBC topics should I focus on for a database-centric role? [closed]
I'm a PL/SQL developer with strong Oracle experience, interviewing for a role in a Java-based team. They're happy with my database skills but want me to learn few Java skills before the next round.
...
- reputation score 15
Score of 4
1 answer
97 views
Oracle 19. date century. difference in behaviour between 2 updates
I update 2 different columns within the same update and with the same variable (a date with value "01.01.1900"), the first one get the right value, the second one gets "01.01.2000"....
- reputation score 41
Score of 1
0 answers
193 views
Passing an array to a stored procedure expecting a SYS.ODCIVARCHAR2LIST
I'm passing an array of strings to an Oracle PL/SQL stored procedure to a parameter that expects SYS.ODCIVARCHAR2LIST on my muleApp stored procedure connector and it throws the following error:
ORA-...
- reputation score 33
Score of -1
2 answers
266 views
Refactor Stateful/Loop-based approach into Set-based approach
I have the Oracle Pipeline function, which is used to allocating marketing budget across product groups and campaigns.
This will allocate a total marketing budget to various campaigns within product ...
- reputation score 7411
Score of 0
2 answers
68 views
PL/SQL elegant Solution for HTML-User Input
I got a Web Form that is capable of displaying some data to users and reading some user input back into the database. However, I need a ton of parameters to work with, and as the project grows, I ...
- reputation score 376
Score of 1
1 answer
116 views
Call to an overloaded procedure inside another procedure in an Oracle/PLSQL package
I have a question about this package:
create or replace PACKAGE BODY emp_pkg IS
FUNCTION valid_deptid(p_deptid IN departments.department_id%TYPE)
RETURN BOOLEAN IS
v_dummy PLS_INTEGER;
...
- reputation score 22
Score of 0
4 answers
118 views
Check valid identifier name in Oracle
The database tool in IntelliJ can detect if an identifier needs to be quoted to make a statement work.
If I use a valid table name, the quotes are removed.
How can I do the same?
The best would be a ...
- reputation score 1253
Score of 1
1 answer
178 views
Render page item which has HTML in Oracle Apex
I have an application where I need to display and stylize the heading of the region. So instead of display heading simply as "Car", I need to display "car icon Car". This icon and ...
- reputation score 609
