As a subquery running the command "DESC <tempoprary table name>"

In subqueries SELECT command is supported.
Although DESC also provides a result set, it cannot be used as a subquery.

In order to evaluate the columns of a temporary table,
I need the columns names/types as cursor that
provided by DESC <table name> command.

If DESC command can be used as a subquery
it would be able to applicated to a "for loop" like this:

for REC in (DESC <table name>) do
– REC.Field, REC.Type, REC.Null
. . .
end for;

or to a "create temporary table" command like:

create temporary table Temp1 as
select * from (DESC <table name>) CC;