cancel
Showing results for 
Search instead for 
Did you mean: 

'invalid table name' in SQL command Editor for tables having slash in name

egor_malov
Contributor

Hi All,

In SQL command Editor (ST04) I am trying to query a table belonging to some partner namespace

My query looks like this

 SELECT count(*) as n from /ABCD/MYTABLE 

This error is returned: (ORA-903): ORA-00903: invalid table name

The problem is definitely with the slashes - for other tables it works fine:

 SELECT count(*) as n from T001 

I tried to escape the slashes with quotes, doublequotes, backslashes - it didn't work.

Is it at all possible to query tables like these?

Thanks in advance!

Best regards,

Egor

Accepted Solutions (1)

Accepted Solutions (1)

JPReyes
Active Contributor

Works absolutely fine with me using double quotes...

SELECT count(*) as n from "/ABCD/MYTABLE";

Regards

Juan

0 Kudos

what about MSSQL?

Double quotes is not working for MSSQL DB..

Answers (2)

Answers (2)

egor_malov
Contributor
0 Kudos

Eduardo, Juan, Thank you!

My system's patch level has been upgraded recently, and finally I was able to get it to work. The format that worked for me was doublequotes, no owner.

Thank you!

former_member184473
Active Contributor
0 Kudos

Hello Egor,

You can use the following statement:

select count(*) as n from <OWNER>."/ABCD/MYTABLE";

If you don't know the owner you can use the following statement:

select owner from dba_tables where table_name = '/ABCD/MYTABLE ';

Regards,

Eduardo Rezende