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
I need to create a table where we have one date column. I need to insert the date from yesterday to yesterday-30 days.Table output should look like this There
I’m trying to connect to an oracle database using Sequelieze ORM. I know that Sequelieze doesn't support Oracle but I'm asking if there is any way to do t
I have two data tables. They both have an employee id column and a sales quarter column, in addition to lots of other columns. The first, which ill call "Rost
I have a function in Oracle 21 version that return a CLOB variable, let's call it x (more than 4000 bytes) and I'm selecting this variable to display it in a cl
Can someone help me with the connection to the Oracle Cloud from Qt. I can't find any information on the Qt website, nor examples, but surely someone has wanted
[ { "name": "sometablename", "numofcolumns": 5, "numofrows": 5, "colheadings": [ { "colname": "customcol1", "coltype": "
I am trying to use the LISTAGG function in Oracle. I would like to get only the distinct values for that column. Is there a way in which I can get only the dist