I need help with putting a condition on a List Of Values in Oracle apex. So I have 2 tables: and The list of values displays v.BROJ_VEZ but returns v.ID_VEZ. The LOV is displayed in the form for the table BRODICE. I want the LOV to display only the v.BROJ_VEZ (returning v.ID_VEZ) where v.MAX_DULJINA > b.DULJINA_BRODICE. How do I do
Tag: oracle-apex
Why is this CREATE command not running?
This is a part of a script which the whole script runs without errors. I followed the script and made minor changes, just by changing names, etc and discarded few commands like ‘create or replace force view’, sequences. This is one of the ‘CREATE TABLE’ commands that I edited from there. Errors came out; ORA-00907: missing right parenthesis ORA-06512: at
Data in Oracle apex
If I want to take data for today from 00:00 until currently hour how can I do it ??? I have this table datetime hourly clientchannel servicename service_count 13_02_2022 9 ***** notification 2 Answer Presuming that datetime column’s datatype is DATE (should be), then because If datetime’s datatype is VARCHAR2 (bad choice), then you should first convert it to date,
PL/SQL: IF or CASE statement to check two variables in a single row and return a third variable?
I need PL/SQL code to scan a table (tied to page 5 in Apex), see if a row with two variables (a specific ID and a specific number between 1-3) exists, and return a third variable from that row into an Oracle Apex item (this is a dynamic action on page 10) if it does. I can do this with
Change the text color of a shuttle based on a condition in oracle apex
I have two different tables in oracle apex, the first one is the documentation table which contains KPI’s, the second one is the results table which contains all the KPI’s results. I have created a shuttle in a page to choose KPI’s from documentation table then, insert the results into the result table. What I need is, if the showed
Which keywords did I missed on the following tables?
My problem: I get the same error on the tables: Tasks, TimeSheet, TimeSheetHour. I still don’t have any idea on what keywords did I missed. Here is the error I got in Tasks table: (same with other tables) May I know which keywords did I missed on the following tables? Answer The keyword is REFERENCES not REFERENCE. Then you have
List the discharged patients who were earlier admitted but did not undergo any operation
This is my code and everything is correct excepted the average temperature since the results are shown that everyone got the same temperature. exp:student a got 4 times observation of temperature whereas student b only got 1 time of observation. so how can I deal with it? Answer This is essentially a complete answer. It shows that writing the SQL
Remove duplicate values from comma separated variable in Oracle
I have a variable (called: all_email_list) which contains 3 email address lists altogether. (I found some similar question but not the same with a proper solution) Example: test@asd.com, test2@asd.com,test@asd.com,test3@asd.com, test4@asd.com,test2@asd.com (it can contain spaces between comas but not all the time) The desired output: test@asd.com, test2@asd.com,test3@asd.com,test4@asd.com Any solution to solve this in a simple way? By regex maybe. Answer Solution
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 Master Detail page that would link
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! Answer Don’t use a case when boolean logic suffices: The specific reason in