How to use oracle temporary table?
I want to use temporary table,but when i search in oracle websites,i only find a example about using globle temporary table. I want to a normal tempory table not a globle temporary table.
And when i create a globle temporary table in a package function. A synex error occurs. Why? Could create statement not use in the package function? How to do,please tell me,thanks.thanks very much.
Re: How to use oracle temporary table?
Oracle doesn't have "normal" temporary tables.
Global temporary tables should be created as other tables and persist in schema.
Creating and dropping GTT inside a package isn't very good practice.