I need help How can I merge the column into a single column, here is my code, is this method is correct. I want to get the count of the selected row in the table for the columns. Can you guys help me I’m a beginner at SQL. Thank you in advance Answer If you want just one row in
Tag: oracle-apex
Finding the length of years between todays date and a column of dates
I’m new to sql so it might not be too difficult for some of you but I simply need to find the length in years between a column displaying different dates and todays date. I’m not too sure what i’m …
SQL query for descending order by sum of values
I have an Apex Oracle app to do. This is the app description: A touristic destination is defined by its name and description. Each touristic destination has a number of bookings, defined by start date, end date, description, price as in the following example: Touristic destination: Hotel Sunrise, Hawaii Start date: 18-Aug-2014 End date: 01-Sep-2014 Description: One room with breakfast
How to successfully reference another table before insert with a trigger
I’m trying to create a trigger to validate if a new entry in the table registraties (registrations) contains a valid MNR (employee number) but I’m getting stuck on the part where I’m referencing the table medewerkers (employees). Could someone help me out? Error message received is ORA-24344: success with compilation error Answer The PL/SQL assignment operator is :=, or select
Can’t enable a foreign key in ORACLE SQL
So I have a disabled foreign key (Manager_ID in the table Employees) and I wanted to enable it, but I get this error: ORA-02298: cannot validate (my_username.EMP_MANAGER_FK) – parent keys not found And this is the code: Here’s how the table was created: Answer There are values in the column that are invalid from the foreign key’s perspective. Assuming that
How can i write hired the same month employees and order?
Sql, which gives the number of employees hired in the same month (or year) grouped and sequentially on date basis. I tried to write this code, but i didn’t find same hired and order. Answer This is how I understood the question. Sample data: Employed in the same month: Hired in the same year:
How to create a column table that holds a file in Oracle Apex
I have created a report with a form in Oracle Apex, for this report I am using a table that have 5 columns and 1 of the columns is filename varchar2(500) which is support to hold a file. In the form I have a page item that uploads the file, however when I create a new record in the form,
Use v(‘APP_USER’) as default value for column in Oracle Apex
I am trying to use v(‘APP_USER’) as default value for a column. I get null when I use it in select like But when I use it as default in column, like below, I am getting error. Error Can anyone explain this or have a turnaround for this ?? Answer There are other options than V(‘APP_USER’). Since Apex 5, the
SQL – Where clause with case statement and wildcards
I’m working in Oracle’s APEX environment, trying to return all values in one case and specific values in another case. If you aren’t familiar with APEX, it uses low-code to produce a front-end page …
How do I fix this error: ORA-00933: SQL command not properly ended
Got this error while trying to enter values for 2 different tables on Oracle APEX and need help figuring out where I went wrong. I’m not sure if it’s because I made a typo somewhere or it’s because I’…