Nigel Campbell wrote : > Hi, > > In my experience there are two basic ways of doing temp > tables, which might be called the "Oracle" model and the > "Sybase" model. > > In the "Oracle" model, you create the temp table as a > static entity - i.e. it's created once and usage local > to a transaction is visible to that transaction and not > outside the transaction. > > In the "Sybase" (or SQL-Server) model, creating a temp > table is quite a cheap operation and is often done within > a stored procedure. The table is destroyed when the > transaction is committed or rolled back. Temporary tables > are quite an idiomatic thing when writing sprocs in T-SQL. > > SAP-DB seems to use the "Oracle" model, but the document- > ation isn't clear on this. If anyone knows off the top of > your head, the info might be useful to many on the list. > If not, I'll do a little experiment and see. > > Nigel.
You're right, SAPDB supports the oracle model. A temporary table is only visible for the session creating that table and lives until session end, if not dropped explicitly. Regards, Thomas -- Thomas Anhaus SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
