I’m pretty fan of SQLcl and lately, I’m using it for creating tables in development from production.

I query the table in production:

After that, while I’m connected to development, I use the bridge command for creating the table (like CTAS in sqlplus):

At the end, I query the new table:

%d bloggers like this: