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
I tried fetching error message from the snp_session table in ODI 12C. I have explicitly inserted erroneous data in order to get an error. But that error is not
I want to show letters only in uppercase in input text field. <oj-input-text style="text-transform: uppercase;" id="text-input" placeholder="Select new Item
I’m having trouble on a query right now to retrieve only the last value saved for each group of results. I explain myself with a table. I have these value
I have problem with my function, I'm getting ORA-21700: object does not exist or is marked for delete error. It's caused by table type parameter in cursor, but
i need help for a problem. Before someone complain. I have post the same question in another forum but i didn't get any useful help there. https://community.ora