I have a table with one CLOB field (s.File) and I need to create a join on this table to get related data. However, in Oracle, CLOBs are not allowed in group by
I'm running macOS Catalina 10.15.7 and I need to install Oracle Instant Client to run run a Perl script that connects to a DB. 1. Installing Oracle Instant Clie
I am trying to see if there is a way to improve the way data is inserted and updated. I am using ORACLE DB with JDBC. The current way i'm doing is to update (e.
I'm building system, in which I decided to use GUIDs as primary keys in many tables. I took this decision in order to be able to develop tool for integration te
I've searched but found no answer, so i resort to you. I have an Oracle table, say "Countries" that exists for ages in database 2 (target). Now, we want to sync
I have the following code, which seems to be working. Is there a way I can add a date, timestamp to the type definition? If so, how would reference the columns
I'm trying to copy a specific cell from an Interactive Grid (which is in Display Only mode, if that matters), and instead of copying the cell I'm in, I'm copyin
If is it possible change delay of JMS Message when it's already in the queue? When I send message via JMS, I set jmsMessage.setIntProperty("JMS_OracleDelay", 12
Thanks a lot for the opportunity.. I will try to pass 2 parameters in my Quarkus rest code, using Hibernate call stored Procedure at oracle database. Unfortunat
I'm trying to understand how Oracle processes SQL's to study ways of optimizing complex SQL's. Consider the test function below: CREATE OR REPLACE FUNCTION FCN_
Task: Write a query that returns a list of houses from the TB_ELEKTROSTAL_2018 table. It is considered that all subscribers who have the same address belong to
I am trying to parse some JSON like this: SELECT cid, c_message FROM JSON_TABLE('{"cid":"30152","c_message":"....very long message...."}' FORMAT JSON,'$[*]'
I have a table in which there is a field last_update_date in which the date is displayed in short form like 25/02/2015.If I want to extract the date in long dat
I have a Post Text Item at the end of my text fields. When I click on it, it shows a PopUp, that retrieves a key to insert in one of my tables. It is possible
Select firstname as name, time as asof, salary as bal into temp employee from people.person p where p.id =1; Need to create a temporary table employee by inser
I try to user Vert.x Reactive Oracle Client version 4.2.6 to avoid blocking threads in event loop. I decided to test a really long query: GlobalScope.launch(ver
I have a table with one row and clob as column (whose size is 5239). This column contains a table script extracted with the help of dbms_metadata.get_ddl. Along
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