So I have this table with a LOT of columns. And I am trying to do pxf connection from another database where this table is. Are there any way I can copy or export maybe all
column name – data type pairs, so I won’t have to announce it one by one in while creating external table?
>Solution :
You could generate the DDL from that table and use it as you need, by clicking right mouse button and selecting from menu Generate SQL–>DDL.