I have a table with thousands of rows. One of the columns does not read the values correctly. Some letters cannot be recognised and thus changed to some symbols
We just upgraded one of our database servers from Oracle 12.2.0.1 to 19.15.0 and one our perl programs is behaving differently. We are running with RedHat 8.4 u
I have multi-part SDO_GEOMETRIES in Oracle 18c. I can extract the parts as individual rows using the SDO_UTIL.EXTRACT_ALL() function: with cte as ( --Each part
So, I'm not sure how it works and I haven't found a sufficient answer by googleing (probably not using the right buzz words). So here it comes: Let's say I have
I have following Oracle SQL code: SELECT TO_NUMBER(TRIM(REGEXP_REPLACE(per_growth, '(%)(\s)')), 'FM99999999999999999990D099999999999999999',
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
elasticsearch-1.0.0