Needing to know if this is possible. I'm trying to get a hierarchical output looking like this: TITLE|CHART|FUND|ORGN|PROGRAM S |S |null|null| S |S
create or replace function auditif return number as l_filter_count NUMBER; begin EXECUTE IMMEDIATE 'EXPLAIN PLAN FOR ' || SYS_CONTEXT('USERENV','CURRENT_SQL')
I would like to display the result of my SQL query in a grid vaadin I can get the data from my toto table But I can't display them in a grid How to do it? publi
Looking for a RAILS solution for OCI Object Storage, we currently are using paperclip on AWS with S3. Paperclip is depreciated and Active storage has no documen
I am trying to insert data into a table and I have written multiple Insert Into statements but I am facing an issue which is quite strange. When I run whole scr
I'm blocked with the development of an Oracle trigger (11g). The goal of the trigger is to store some data in an audit trail table. One of the fields that is po
Enabling @Version on table Customer when running the tests below @Test public void actionsTest1 () throws InterruptedException { CustomerState t = customerS
I have started using and learning APEX 21.2. It seems in previous version there was a sample database application that included sample data when installed. In 2
I have a column with many zeros and I want to put only non-zero values into N groups of (approximately) equal sizes. All zero values should get group number 0.
I am working on building a classic report where I want to view the results in a table format. I am using the source as "Function Body Returning SQL Query" Lang
I have table called generalledger_mgmt that contains many columns. I wrote query to perform some operations and select some of them as below. My problem is some
I want to Install Oracle Database Express on macbook m1 but it only supports linux and windows, I downloaded Sql developer but I m unable to download Oracle dat
We are using Hikari Connection pool to connect to Oracle on Azure. We tried increasing the timeout value to 12000000 after consecutive connection time out error
I am migrating some data. I have a table data which has quite a lot of columns to reference other tables. And those other tables are being changed and simplifie
I have an application created using .NET Core 3.1 which needs to connect to an Oracle database, the connection code is very straightforward and I'm connecting u
I am trying to query data from linked server. It is giving me the following error: TNS:listener does not currently know of service requested in connect descrip
I'm planning to write a pl sql pseudo code procedure a gets all records from emp and is passed to procedure b procedure b getting called inside from a , is tra
I'm working on Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production and I need to develop a store procedure that access an API, I have t
select case when code = number_1 then number_1=code when count(code)>=count(number_1) then number_1 = sum(code)
I'm running below code and getting below results but I want to remove ,, and after ,, texts from email address and that email address should show in UPPER(PT_PA