Skip to main content
The 2026 Annual Developer Survey is live— take the Survey today!
29,158 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
Filter by Employee ID
Score of 1
2 answers
194 views

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 ...
Best practices
0 votes
4 replies
98 views

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 ...
Advice
1 vote
4 replies
137 views

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 ...
Advice
1 vote
4 replies
95 views

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. ...
Advice
1 vote
5 replies
172 views

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. ...
Score of 4
1 answer
73 views

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"....
Score of 1
0 answers
171 views

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-...
Score of -1
2 answers
256 views

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 ...
Best practices
0 votes
2 replies
55 views

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 ...
Score of 1
1 answer
96 views

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; ...
Advice
1 vote
4 replies
101 views

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 ...
Score of 1
1 answer
120 views

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 ...
Score of 0
1 answer
219 views

I'm trying to do my first CSV export into an existing AWS S3 bucket. Calling with type CSV: call dbms_cloud.export_data(credential_name => 'cred', file_uri_list => 'https://s3.us-east-2....
Score of 0
1 answer
106 views

I'm trying to check if a file exists on a remote server, in a Forms 12c program unit. I tried to use utl_file.file_exists('\\server\d$\folder\filename.txt') and also utl_file.fgetattr('DBFOLDER','...
Score of 1
2 answers
80 views

I have an XML file with a node containing a file that has been converted into hexbinary. The ultimate goal is to read that node, convert it back to an actual file and store the path of that file in a ...

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