Global temp table throwing error [message #387995] |
Mon, 23 February 2009 00:02  |
rangan.s
Messages: 75 Registered: February 2008 Location: chennai
|
Member |
|
|
Hi,
I am trying to create global temp table throwing error
please help
SQL> create global temporary table test_glb as ( select col1 from test1) on commit delete rows;
create global temporary table test_glb as ( select col1 from test1) on commit delete rows
ORA-00933: SQL command not properly ended
Thanks
Rangan S
|
|
|
|
|
|
|
|
Re: Global temp table throwing error [message #388145 is a reply to message #388133] |
Mon, 23 February 2009 07:47  |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
rangan.s wrote on Mon, 23 February 2009 07:56 | under stand how to get this ?
dont simply say like refer documnets that we know
|
What are you trying to say here? I think you are asking not to be referred to the documentation because you know how to do it, but you have shown that you did not know how to do it.
|
|
|