I am trying to return all Col1 values IF the respective Col2 value = NULL I have thought of IF Col2 = NULL Return Col2 END IF, But I am unsure of how to format this, because when I run it I get errors saying invalid relational operator. Thank you for your time. SELECT Col1 FROM mytable WHERE IF NULL
Tag: oracle-apex
Oracle APEX master detail page creation: ORA-06531 error
I am creating a flock management application with APEX with the following PL/SQL scheme: In this scheme, the SALE and EVENT tables reference the EID field of the SHEEP table (unique identifier of 5 numbers and one letter – representing the yellow tag they have in their ears). I am trying to create a Mas…
Oracle Apex – Case within a where statement
I’m having issues while running the following query (interactive report / simplified the query cause I’m sure the issue is with the case statement): The error is this one: ORA-20999. Does someone know why this is happening? (:p28 items are calculated via computations and work perfectly) Thanks! An…
Using oracle apex dynamic action to set a date time value that is concatenated
I have a date value in one page item and i have a time value in another. i want to concat the date with the time and set it to another item using a dynamic action. Structure as below P_DATE = ’01-01-2021′ (item is a date with format mask dd-mm-yyyy) P_TIME = ’08:30 AM’ (item is date wi…
SQL Command isnt running (invalid identifier) maybe SYSDATE?
I’m having a bit of trouble getting my command to run and I think that it has something to do with the SYSDATE command: I get the ORA-00904: : invalid identifier error. Any fix? Answer The problem is the last field definition: Get rid of the comma and you’ll be fine. db<>fiddle here
Put a json inside another json on Oracle 19
i have the next problem. I need create a json from a table that contain another json inside in one of the columns Having this: i try with this query: But the result is not correct: Must be something like: There is a way to get the correct result? Regards. Answer after see examples and see the resuslts. I know
Populating rows in table with previous row value oracle sql
Here above the data is grouped by person then their duties are listed : I need a way to get the data to look like this using oracle sql : having a bit of trouble iterating over every row… dont mind if its plsql – sql prefered tho Tried a few things… but it goes back to null after the
Oracle Apex update specific row of table
Hi i want to update a specific row of my oracle database via apex. So i need to reach/address the specific row via where clause. example entries: GATTUNG ART UNTERART ABART VARIETÄT AAA AAA AAA NULL …
No data is showing in object browser in Oracle Apex
I have a SQL table created in Oracle database with 5 records. However, the records are not reflecting in the Oracle Apex Object Browser (table). I tried refreshing the data but no luck. I was able to …
Oracle APEX changing the colour of display only item with PL/SQL query
I have a display only item in a static content which looks like this: I want to change the whole background colour of the button/item instead of the text’s colour. My PL/SQL code looks like this for example for the first item: Is it possible to change it with PL/SQL? All I could do is change the span ba…