I am trying to create a trigger that updates “event” table rather than updating the “v_event” view. When I run this script I get “success with compilation error” error. What am I doing wrong? Answer Pay attention to what you do. In order to find out what went wrong, either immediately after you see the error (if your tool supports
Tag: oracle-apex
I have a issue with Order By in SQL
I having this issue when I try to retrieve data from two tables. DEPT Table EMP Table I want to use this query but it’s creating the data with all locations in table DEPT DATA Answer Basically your query is doing a CROSS JOIN which creates all possible combination of two tables. As DEPT table has 4 rows and EMP
Showing Buttons in Oracle Apex with Server Side Condition dependent on Page Item Value?
I am currently struggling with Oracle Apex, trying to show a Button, when the Value of a Page Item is greater than Zero (numeric). Figured the Server Side Condition (SQL Expression) would be the best Idea and my SQL Code is: I am however getting the error: ORA-06550: line 1, column 37: ORA-00920: invalid relational operator. Using the Server-Side-Condition “Item
APEX: Submit without refreshing the page
I have an interactive report that runs a large query, which takes about 20 seconds to execute. There are many filter items on the APEX page, which affect the data in the report. The report uses a PL/…
Using Oracle SQL to join duplicate counts to an existing subquery
I have been asked to build a query that runs quality checks for data on a certain state test. I have the following query that creates a variable named ‘Flag’ to identify cases where there are issues. The main query is really in a subquery, and I filter out all records where there isn’t a flag by only selecting cases
Oracle SQL data fetch order
I’m trying to achieve this Layout. I’m not sharing the query because it’s working, I’m just wondering what functions to use in order to achieve format ‘2’. In the beginning I was doing UNION ALL , that’s how I got format ‘1’. The data is fetched from multiple tables. I’m trying to achieve this without PLSQL. Thank you ! How
multiple selection in the where clause
I need to do multiple selection in the where clause select * from BATS where REASON in case when :P12_REASON = ‘Rejects’ then (‘online’, ‘offline’) else ” end and case when :P12_REASON = ‘…
2 columns one below another in sql
I’m getting this error ORA-12704: character set mismatch can you please help me to fix this Answer See whether this helps. I presume that this is your situation: This is your current query: This is what you might try to do – apply the to_char function to a nvarchar2 column:
APEX get Multiple entries FK
,i dont know what so search for my problem. I think its very simple, but i dont know about that 🙂 I have a Table where i listed all my “Groups/Teams” And then i have a Users Table where i list all the People: I use APEX 18.1 and have a Form with a List of Values, there i can
How to know the size of a table with a photo in Oracle
I have a table that I fill in the post method, I send a photo, and describe the event, I want to know the size of this table (MB) with the help of a selector, Someone can help me with this ?? SQL> …