Create Global Temporary table in Command window

[Roeland]

Hi,

when executing the following code inside a Command Window, nothing happens. When executing the same code in a SQL window, the table was generated...

CREATE GLOBAL TEMPORARY TABLE Tmp_Test
(
   ID Varchar2(16) NOT NULL
)
ON COMMIT DELETE ROWS
;

Any idea?

Version 7.1.5.1398

 

[Marco Kalter]

Works fine for me. Are there any empty lines in reality that are missing in this example?

 

[Roeland]

you are right.

the correct example should be:

CREATE GLOBAL TEMPORARY TABLE Tmp_Test
(
   ID Varchar2(16) NOT NULL
)
ON COMMIT DELETE ROWS

;

Note the empty line above ';'

How did you know? Is this a bug already know? Or is this a grammatical error from my side?

Regards,

Roeland

 

[Marco Kalter]

It's the same behavior as SQL*Plus. It stops parsing when an empty line is encountered.