Support Questions
Find answers, ask questions, and share your expertise

Temporary/Intermediate Table creation in Phoenix

Temporary/Intermediate Table creation in Phoenix

We have existing process in Oracle and Sybase database where we are creating the temp/intermediate table using Select <Field Names> into <New_Temp_Table> from <Table>.

I am not being able to achieve same functionality in Phoenix. Is there any way we can create Temp/Intermediate tables on fly in Phoenix or we always have to define the table structure in advance in Phoenix then use UPSERT into to update table ?