Hello,

I want to create Custom table with following SQL statement:

SELECT table_name, owner

FROM dba_tables

WHERE owner='HR' OR owner='TEST1'

ORDER BY owner, table_name

but I got error when want to upload data:

You have an error in your sql syntax check the manual that corresponds to your MySql server version for the right syntax to use near 'Schema limit 1,2' at line 1.

What can be the problem? I use Oracle DB.

Thanks

Perhaps the Oracle DB is expecting SCHEMA_NAME.TABLE_NAME in the SQL ?

SELECT

table_name,

owner

FROM

dba_tables

WHERE

owner = 'HR'

OR owner = 'TEST1'

ORDER BY

owner,

table_name