Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to create dynamic table while inserting the output of another query into it?

AshK-OracleApr 27 2022

CREATE TABLE && as SELECT transaction_number FROM (inner query);
This is a dummy query. I want to create a dynamic table and then insert the output of that query in to the dynamic table

This post has been answered by KayK on May 5 2022
Jump to Answer

Comments

Post Details

Added on Apr 27 2022
17 comments
4,716 views