| SQL statement [message #374479] |
Thu, 14 June 2001 04:58 |
Claudio Beretta
Messages: 5
Registered: February 2001
|
Junior Member |
|
|
I've create this statement to select all the table I'll need to import from one schema to another one.
The prolem is that the results of this statement is in a column, can you help me in refine my query to put the result in string like this Table1,Table2,Table3,etc.
This is my sql statement
select ' ' || TABLE_NAME || ','
FROM ALL_ALL_TABLES WHERE OWNER='TESTDTA'
AND TABLE_NAME IN (SELECT TABLE_NAME FROM ALL_ALL_TABLES WHERE OWNER='PRODDTA');
Many Thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
