CHADI E.

Use a SQL statement to find out the names of students whose marks are over 80 in all of their... more

First question:My lessons e-book is for 18c, when you go to Oracle, the only download for Windows 10 is 21c, does this matter?Second question: I attempted to download 21c anyway, now I have an... more

I need to return some dummy select when my variable matches string. This is what I tried: begin if :someVar = 'Yes' then select 1 from dual; end if; end; / I've tried... more

I have no idea what the problem is. Using MySQL 5.0 i get a compile error when attempting to run the following MYSQL update statement UPDATE b SET b.mapx = g.latitude, b.mapy =... more

It seems to me that you can do the same thing in a SQL query using either NOT EXISTS, NOT IN, or LEFT JOIN WHERE IS NULL. For example: SELECT a FROM table1 WHERE a NOT IN (SELECT a FROM... more

I have begun reading about *Common Table Expression* and cannot think of a use case where I would need to use them. They would seem to be redundant as the same can be done with derived tables. Is... more

I have a Geometry LineString that I wish to convert to Geography. Since the Geometry isn't valid , When I use MakeValid on it, SQL convert it to MultiLineString and than the Geography creation is... more

I'm just starting with Oracle BI Publisher and I really don't know how to get along with my task. My project is to ask the user for a parameter (that's ok), and if the user chooses 01, I should... more

I was solving one of the puzzles and came across swapping column values using DML queries: SELECT * FROM TEMP_TABLE; ID1, ID2 -------- 20, 15 20, 15 20, 15 Solution is mathematical... more