Environment used – Following simple query is giving me an error : ORA-00933:SQL command not properly ended On SQL Developer 1.5.1 – Answer Oracle did not support the ANSI join syntax until version 9i. Also, Huy Ngo is correct that Oracle does not allow AS for table aliases. Try this code instead:
Tag: oracle
Wrong number or types of arguments in call to ‘||’
We are supposed to read a text file, insert that data into a table while taking care of exceptions. This the code for my function: This is how i’ve called the function (but i think it’s wrong): And this is the error I’ve got: I tried to remove the results in the dbms_output and this is what …
I have query to get some data but I need different result
select to_char(a.insertdatetime) as insertdatetime , b.category, count(1) as count from daily a , server b where status != ‘OK’ group by b.category , to_char(a.insertdatetime) …
Oracle – Outer Join with join condition
I have a scenario where I have two tables ORDER ORDER_NO LOCATION ITEM QTY_RECEIVED SHIPMENT ORDER_NO LOCATION ITEM QTY_RECEIVED There are cases where ORDER table has a record but SHIPMENT table …
Query to see the MAX value in Oracle
I have the following N:N table (which stores the people boardings) in my Oracle Database (it is about an airport): CREATE TABLE boardings( Passport VARCHAR2(8), Day DATE, Flight VARCHAR2(8), …
sql query hangs/times out when passed large data
UPDATED: Guys I am passing list of faculty id’s to stored procedure, when i pass more than 10 faculty id’s it’s taking long time to process the data and sometime times out. I spent good amount of time …
Updating salary on employees for each full year they have been working [closed]
Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 2 years ago. Improve this question I have to do what i say in the title. I have to update the salary on employees for each full…
SQL turning rows into columns and populating with values
I’m not quite sure why this table was designed this way, but it’s making it hard to solve my problem. Looking at the data: What I need help with is to do the following: For each name have the type_name as a column and then fill those columns with the default_value or value. Like this: Basically po…
Oracle Why Exists Query Returns This Result
I am confusing using exists to compare two data between two tables. I am expecting to get 0 rows from query but it returns some data. I don’t know why. select main_rule, child_rule from …
How to remove duplicate rows from a join query in oracle? [closed]
Closed. This question needs debugging details. It is not currently accepting answers. Edit the question to include desired behavior, a specific problem or error, and the shortest code necessary to reproduce the problem. This will help others answer the question. Closed 2 years ago. Improve this question I hav…