Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Temporary tables
I think that you can use in-line view instead temporary table. If you can do anything with temporary table, also you can do anything with in-line view.
--
//////////////////////////////////////////////////////////////////////////
//
// $(C!#!F">!$"*!$ (B. $(C!$(B.$(C"* (B. . . * $(C"= (B. o . $(C!F!$ !F
(B// $(C"= !G!G !F "= (Bo . $(C"= (B. o . $(C!F(B. $(C!Y (B. $(C!Y (B. * $(C!Y !F !Z (B// $(C!Z !F"E&5&5&,&,&,&B&H&,&,&,&,&B&H&,&,&,&,&B&H&,&,&,&,&B !Y (B// $(C"= "= (B. $(C"+"C"C"I"I"I"I&"&""C"C"C"C&"&""C"C"C"C&"&""C"C"C"C&" !D"= "= (B.// ~~~~~ ~~ ~~~~~ ~~ ~~~~~ ~~ ~~~~~ ~~ ~~~~~~~~~~ ~~~ ~~~~~~~ ~~ ~~~~~~~~~
// $(C!Z (B///$(C!\!V!\!V!\!V!\!V!\!V!V!\!V!V!\!V!V!\!V!V!\!V!V!\ "* !#!$(B