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 …
Tag: oracle
‘SET’ must be a type
I created the following types : A person can have a set of PhoneNumbers, when I try to create the Type Person : I get the following error : Errors: TYPE PERSON Line/Col: 0/0 PL/SQL: Compilation unit analysis terminated Line/Col: 1/90 PLS-00488: ‘SET’ must be a type Answer If you want an array of p…
Merge sql throws Unique constraint violation error
I have below two table for which when i query table TEST_RUA: select CLASS, ID_LL, ID_UU, TKR from TEST_RUA where ID_UU= ‘GV9999B12M0’ it returns: CLASS ID_LL ID_UU TKR Bond (null)…
How to pass in a comma separated list of values as a Parameter input in Oracle
I have a simple select query that I would like to pass in a Parameter in the WHERE clause which contains more than one value, (comma separated list) and the query shows results for each comma separated value ? I need to know what the syntax / method for this is in Oracle SQL. So in the Query below my
How to get list of cars with a specific ID of wheel?
I have the following code snippet : I want to get the Voitures having number of Roue = 554 : What is the difference of using the table in the EXISTS subquery directly in the WHERE clause? Answer The right way to write your first query would be: This query, written this way, is doubtfully usefull, because it s…
Foreign key as primary key?
I currently have 2 tables STUDENTS and SUBJECTS. I need to create another table for ENROLLMENTS, the thing is that in that table I need to know the minimal attendance, which is both dependent on …
joining temporal tables in oracle
I am looking for better solutions to a fairly generic problem with temporal tables. say we have table_a (some_value int, date_from date, date_to date) and a series of similar tables table_b, table_c, …
Get the data from previous month in sql query
I have a data of all the cost for each month. For example, I have table of cost for each month +——–+——–+—–+——–+——–+ | Jan | Feb | Mar | Apr | May | +——–+——–…
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…
SQL timestamp filtering based only on time
I want to create a query in Oracle SQL that will grab records from a given time interval, during certain hours of the day, e.g. records between 10am to noon, in the past 10 days. I tried this, but it does not work: where timestamp is of type TIMESTAMP. I have also thought of using a join, but I am