Generate create table DDL from any arbitrary select query? Using allroundautomations PL/SQL Developer, is there a way, given any arbitrary select query like this:

select myfavoritenum, myfavoritetxt 
from tablewithmanycolumns


to magically receive a create table statement:

create table justmyfavorites (
    myfavoritenum number,
    myfavoritetxt varchar2(30)
)


I'm aware of CREATE TABLE AS SELECT, but I don't necessarily want to create the table right then, or in that particular database, etc.

Attempting to Google up a solution, I also became aware of DBMS_METADATA.GET_DDL, but that appears to be for existing objects, not arbitrary queries.
One way to accomplish this, using Java, would be to prepare the query statement, then use the PreparedStatement.getMetaData() method to obtain the ResultSetMetaData object that has the list of columns that would be returned, as well as their data types.

Other database interfaces, such as ODBC and OCI, have similar functionality.