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
How to create a trigger which will auto create sequence ID
I have been trying to implement the logic. But as only basic knowledge on SQL. I have a below following table I have following data in it I need to write some trigger as soon as the insert is performed depending upon createddate a sequence should be automatically inserted to sequence column for respective record. Expected output : The sequence
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
How to create table from an existing table
I’m in Oracle APEX and would like to create a new table from other existing one like this: I have a column in a SONGS table that is: ARTIST NAME Another header Bad Bunny row Bad Bunny, Ozuna, Daddy Yankee row And I want this in another table: ID Artist 1 Bad Bunny 2 Ozuna 3 Daddy Yankee Also, from
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