Top "Ora-00905" questions

ORA-00905: missing keyword

SELECT INTO using Oracle

I'm trying to do a SELECT INTO using Oracle. My query is: SELECT * INTO new_table FROM old_table; But …

Read More
sql oracle ora-00905
Oracle error : ORA-00905: Missing keyword

Excuting the line of SQL: SELECT * INTO assignment_20081120 FROM assignment ; against a database in oracle to back up a table …

Read More
sql oracle ora-00905
SQL Oracle LEFT JOIN and SUBQUERY error: ORA-00905: missing keyword

Asking for your help on this Oracle query. It's giving me the error 2 "ORA-00905: missing keyword". It was working fine …

Read More
sql oracle subquery left-join ora-00905
Missing Keyword (ORA-00905) - Oracle SQL Case Statement

Good morning, I was wondering if one of you could help me - should be fairly quick I'd imagine; I'm …

Read More
sql oracle case ora-00905
Using the Oracle "at time zone" function in sql - problem and solution

I have a table with a date column that I know is stored in GMT. I have a procedure that …

Read More
sql oracle timezone timestamp ora-00905
how to find length of a Long Column in a table

I have a LONG column named FileSize in a table called Files. To achieve the objective, I did the following : …

Read More
oracle plsql oracle10g ora-00905
ORA-00905: missing keyword

I am getting ORA-00905: missing keyword error when trying to run the following query in Oracle: select distinct MONTH_ID …

Read More
sql oracle case ora-00905
Missing Keyword in JOIN syntax

I have searched the site before asking the question but havn't come across something related. I am sure this is …

Read More
sql oracle ora-00905