How to create schema from a query?

[wangbinlxx]

Hi
As in the diagram, I refer a schema in Repository when creating tOracleInput. When creating the schema, I find that I need to define each column in the schema manually, which takes a while. Is there a way to load the schema from a file or somehow derive it from the result set of a query?
Thanks,
Bin
  

[Anonymous]

Hi,
Have you tried to centralize your oracle database and retrieve table schemas?
TalendHelpCenter:Centralizing database metadata
Best regards
Sabrina