Im sorry, I don't fully understand your question.
Can you clarify?

Are you trying to find out how to use dynamic sql?


If you are not looking to use dynamic sql, you are correct-- you probably know you don't need the quotes around the schema name.

Let me know your question was looking for how to use dynamic sql, and then I will answer that. (Just dont want to do all that typing if that's not what you want) If you want dynamic sql--- do you have 8i? If not, you will need to use the DBMS_SQL package. It's pretty straightforward, and so I think the documentation would contain everything you need , such as what procedures for what type of statement.

Mary