My data look like: CLUID EVENT_PAYLOAD STEP 1998-06-22-23.58.16.792243 {“type”:”page”,”name&…
Tag: plsql
Oracle optimize select after update status performance
I have a store procedure that will Update maximum 500 rows status from 0 to 1 Return those rows to program via cursor Here is my store procedure code PROCEDURE process_data_out ( o_rt_cursor …
Calculate age from date of birth with formatting
I would like to calculate the age from the date of birth stored as a string using the format in the comments in the code. Here’s my code: The result I get is the following: I guess there’s something wrong with the year but I can’t figure it out! Answer The error is in this line: You should n…
please find the solution of this problem. ( in PL SQL ) ——–
I’m doing an assignment and the last question states that I call the procedure from question 2 and function from question 3 and then put them in an insert clause(question 4). Write a PL/SQL Code for an anonymous block to do the following (in package): a) Get the doctor name for a given doctor id (read f…
Error while writing to array plsql how to fix? Extend doesn’t work also
so I am trying to write to an array in PL/SQL, and I always get the subscript outside of limit error. I’ve seen similar posts and implemented everything based on those answers, I can’t seem to find what I’m doing wrong. The line giving the error is “arr_quartosLivres(counter) := q.id;&…
Dynamic query to find all the table DML activity in all the table oracle
Hi I need to search the DML activity of specified list of tables in a schema single query since it is time consuming and hard to run individual queries ,so i am trying to prepare a dynamic sql to fetch max(ora_rowscn),SCN_TO_TIMESTAMP(max(ora_rowscn)) from all the tables so that i can use a filter and select …
not in in select query
I have similar query in my project. I have been told to find other way to remove not equal to, because index is not used if you do so. I have no other filter condition, can I do some work around to fool optimizer? Answer I have been told to find other way to remove not equal to, is generally
How to successfully reference another table before insert with a trigger
I’m trying to create a trigger to validate if a new entry in the table registraties (registrations) contains a valid MNR (employee number) but I’m getting stuck on the part where I’m referencing the table medewerkers (employees). Could someone help me out? Error message received is ORA-24344…
Update table inside a loop in a procedure pl/sql
So i want to hire a new manager for a department. This procedure has 2 parameters, the department name i want to change, and the new id for manager (taken from employee’s id). So to change it, i need …
List of Record type matching issue Oracle
I want to check if a workspace is not available in all_workspace table then create new workspace. My requirement is if p_workspace is not matching the list of value of v_workspace then it should create new one. It gives me error after creation. If I run that workspace individually then its working. but when I…