I've data like below Id date time type 1 01-01-2022 08:00 in 1 01-01-2022 11:30 out 1 01-01-2022 11:35 out 1 01-01-2022 12:45 in 1 01-01-2022 17:30 out 1 01-01
I have several environments where we have implemented sqlcl and apex versioning. Oracle database 19c - SqlCL version 20.3 The only difference versus other envir
I have downloaded and installed Oracle DB EX 21c on Windows and it seems the only way to interact with it is using the command prompt. Some older versions like
WARNING: The requested image's platform (linux/amd64) does not match the detected host platform (linux/arm64/v8) and no specific platform was requested Oracle
I have a table and I want to increment a column by 1 when I insert a row into the same table. Table users - when I insert first row value of idusers is 1, and i
I would like to know that is there any other effective way or query to get the desired output for the below query with AND operators because if I run this below
I want to convert value year month ('202101') 2021 > year 01 > month to 2021-01-31(end day) in toad for oracle please help me, if somebody know.
I am using the following stored procedures (Oracle Database) to export the output of the query to a CSV file CREATE OR REPLACE PROCEDURE run_query(p_sql IN
loan_id coll_date coll_pay_mode 8007571771 APR-2022 CH 8007571771 FEB-2022 CH 8007571771 JAN-2022 CH 8007571771 MAR-2022 CH 8007571771 MAR-2022 CL 8007571771 M
In 2022, the question asked in how-to-prevent-oracle-sql-developer-from-writing-to-appdata-roaming is still a bit of a problem. While the -Dide.user.dir option
I am wondering if using loadjava to load the Java package called JSch.jar in an Oracle database and then loading another .java file, that utilizes the JSch pack
How do I return the table of my procedure whenever I call it? -- this code will find all the empty categories. create or replace procedure empty_cats(emptyCat
I want to export/import an oracle apex application between two different workspaces. i have already tried to create supporting objects then export the applicati
Here is my configuration: Window Server 2016 build 14393 From phpinfo: PHP Version 8.1.5 Architecture X64 Server API CGI/FastCGI Loaded configuration file: D:
Let's assume I have following tables: TABLE_A (ID; NAME; ...) TABLE_B (ID; NAME; TABLE_A_FK; ...) And I expose the table data through this view: SELECT a.id, a
I was trying to set the v$session.program at the connection from a R2DBC Oracle connection (within a Spring application) For now I've tried this but without suc
tl;dr; Will the query optimizer be able to optimize the max calls? select id , max(case when this and that11 and that12 then 1 else 0 end) name1 , max(c
Note: This is an over simplified version of what I am trying to do. Let's say I have a table called USERS that has FIRSTNAME, LASTNAME. Contents are: JOHN SMI
I need to know if it is possible to feed the PARTITION clause with the latest partition name of a table, instead of using his value. Normaly we have: SELECT *
I have a code as follows. My question is - why do we need IF statement for CURSOR%FOUND ? If no rows are found, that will trigger NO_DATA_FOUND condition and co