Temp Table Basic Syntax error
570228May 2 2007 — edited May 2 2007Thanks to those who answered my last thread. I just attempted to create a temp table by itself, here is my syntax:
1 CREATE GLOBAL TEMPORARY TABLE emp_temptable (
2 Employee_SSN VARCHAR2(9),
3 First_name VARCHAR2(20),
4 Last_Name VARCHAR2(20),
5 Employee_DOE DATE,
6 Employee_DPT VARCHAR2(20),
7 Hourly_Rate NUMBER(5,2)
8* ) ON COMMIT PRESERVE ROWS;
9 /
) ON COMMIT PRESERVE ROWS;
*
ERROR at line 8:
ORA-00911: invalid character
Why am I getting this error? I am referencing the 10g "The Complete Reference" as well as a website and my syntax looks the same. What am I missing?