1

Topic: SQLPLUS ORA-00936: missing expression

At me Ubuntu 14.04 LTS. In connection with http://www.sql.ru/forum/1300658/kak-vkl … ie-xmltype tried to manage sql plus, but it produces an unexpected error.
with xml_table as (select xmlType (' <root><row><col>1</col><col>2</col></row></root> ') xml from dual)
select row_t.column_value as cols
from xml_table t, table (XMLSequence (t.xml.extract (' root/row '))) row_t; /
4 /
from xml_table t, table (XMLSequence (t.xml.extract (' root/row '/
*
ERROR at line 3:
ORA-00936: missing expression
Prompt what to install, please, on  or how to tame that is.

2

Re: SQLPLUS ORA-00936: missing expression

AnnitaBells;

with xml_table as (select xmlType (' <root><row><col>1</col><col>2</col></row></root> ') xml from dual)
select row_t.column_value as cols
from xml_table t, table (XMLSequence (t.xml.extract (' root/row '))) row_t; /
4 /
from xml_table t, table (XMLSequence (t.xml.extract (' root/row '/
*
ERROR at line 3:
ORA-00936: missing expression

3

Re: SQLPLUS ORA-00936: missing expression

with xml_table as (select xmlType (' <root><row><col>1</col><col>2</col></row></root> ') xml from dual)
select row_t.column_value as cols
from xml_table t, table (XMLSequence (t.xml.extract (' root/row '))) row_t
/

4

Re: SQLPLUS ORA-00936: missing expression

Or

with xml_table as (select xmlType (' <root><row><col>1</col><col>2</col></row></root> ') xml from dual)
select row_t.column_value as cols
from xml_table t, table (XMLSequence (t.xml.extract (' root/row '))) row_t;

5

Re: SQLPLUS ORA-00936: missing expression

6

Re: SQLPLUS ORA-00936: missing expression

Viewer;
Many thanks!