Top "Ora-00936" questions

'NOT LIKE' in an SQL query

Why does this simple query return 'ORA-00936: missing expression' (the database is Oracle as you can tell): SELECT * FROM transactions …

sql oracle ora-00936

How to resolve ORA 00936 Missing Expression Error?

Select /*+USE_HASH( a b ) */ to_char(date, 'MM/DD/YYYY HH24:MI:SS') as LABEL, ltrim(rtrim(substr(oled, 9, 16))) …

oracle oracle10g ora-00936

Syntax error: missing expression (ORA-00936)

I have 2 tables, Facilities and Services. CREATE TABLE Facilities ( facility_id NUMBER(2) NOT NULL, facility_name VARCHAR2(20) NOT NULL, CONSTRAINT …

sql oracle database-design foreign-keys ora-00936

java.sql.SQLException: ORA-00936: missing expression

Below I am creating table. public static final String CREATE_SQL = "CREATE TABLE " +DATABASE_TABLE + "(ID number(10,0), " + " CGUID VARCHAR(255), " + " PGUID …

java oracle ora-00936

What could cause an ORA-00936 - Missing Expression with the following sql?

We're seeing the error message ORA-00936 Missing Expression for the following SQL: Note that this is just a cut-down version …

sql oracle ora-00936

Getting error ORA-00936: missing expression

When I trying the below SQL I am getting the error ORA-00936: missing expression. Please help me on this, I …

sql oracle oracle10g ora-00936

ORA-00936: missing expression oracle

I have this query SELECT DAL_ROWNOTABLE.DAL_ID FROM ( SELECT ticket.id AS "DAL_ID", ROWNUMBER ( Order By ticket.…

sql database oracle expression ora-00936

Why is selecting specified columns, and all, wrong in Oracle SQL?

Say I have a select statement that goes.. select * from animals That gives a a query result of all the …

sql oracle table-alias ora-00936

SQL IF ELSE statement in trigger

I want to trigger every insert on a table. Sometimes the name_event is the repository of the target table …

oracle if-statement triggers compiler-errors ora-00936