Use of variables in PLSQL script
I have this existing stored procedure. I recently converted some of the database into multitenant
…I have this existing stored procedure. I recently converted some of the database into multitenant
…how do i get my planned orders to reference the approved supplier name
Have a huge table of over 800 million records.
Have to run an aggregate query on a set columns that
…I am using Asp.Net website and Oracle DB, In One Page, when I first open then it takes 30 sec, if I
…I use putty to do an ssh connection using oracle user and password to a linux server.
A new cyberark
…We are looking for a free, simple rule engine to be called from Oracle 19c PL-SQL similar to the
…getting the below error. pls see the file aatached
I am looking to install Oracle DB but free version, Is there any option available?
I currently have a linux machine with an Oracle database on it. I would like to create a clone of
…This question is in reference to EE question: How to Solve ORA-12801 and ORA-00600
In order to fix
…Hello all I am trying to insert data to oracle table by passing the data table data to my procedure
…All,
iam trying to create master detail form entry as show below:
Select
'S-' || trim(p.VENDOR) as "Supplier Key",
'1' as "Default PO Issue Email Data Key",
null as
…Oracle 19c Unified Auditing on Linux.
I have configured Unified Auditing and it is working fine and
…When I try to insert some date records in a table, oracle gives me the following error:
"literal does
We are in a process of upgrading domain controllers to server 2022.In our oracle ERP SSO server
…Hello,
how to implement apex forgot password functionality.
1) steps one I did in my login page is i
…Recently we have upgraded from oracle 12C to 19C .
We had a purge program we executes below
…I have been asked to expand on an existing query by adding a union statement.
The expected results
…I am searching a tag in clob. I can do it via regexp_count.
for example
select regexp_count(myclob,
…