I’ve created a temp table and need to further select some data from it. Seems simple. The temp table contains thousands of orders, an action code (C or D)and a seq_ID for each order. Each order has multiple instances of the C and D action codes, but I only want a list of those where [...]
Hi, My question is basic and should be simple to answer I assume. I’m a beginner so I don’t know much about Temp Tables? Can you please show how Temp tables work and the concept behind them. Thanks, o
We have an old server that runs SQL Server 7 on an NT system. One database has processes running that are not documented. I have written triggers to report any deletions, inserts or updates made against the database’s tables. All I can report is that an insert, update or delete has occurred, the Date and [...]
have a Oracle 10g database that is with its temporary tablespace full. Is there any way to clean this tablespace? I tried to restart the database, but i’ve no effect
please tell me which one performs better view or temp table ?





