· Apr 18, 2019

Running a SQL SELECT statement in USER NAMESPACE to get data from another NAMESPACE


I am trying to run a simple SELECT STATEMENT in USER NAMESPACE.

SELECT * FROM projectname.table

What is the syntax if i need to get data for a table in another namespace eg. SAMPLES., SYS

SELECT * FROM SAMPLES.projectname.table  is not working.

Thanks in advance.

Jimmy Christian.

Discussion (9)2
Log in or sign up to continue