Can I use the %TYPE reference when creating a global temporary table?
643707Sep 23 2008 — edited Sep 25 2008I think I already know the answer, which is no, but I was hoping that I just had the syntax wrong. Can I create a global temporary table whose data type def'n reference a datatype?
ie: CREATE GLOBAL TEMPORARY TABLE MY_TT (col1 someothertable.somecol%TYPE)
Using that syntax, I get an error that there's an invalid character (assuming its at %).
Certainly would be nice to user type references in GTT's.... If someone has done it, please share :-)
TIA-
kelly