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
. . .
or to a "create temporary table" command like:
create temporary table Temp1 as
select * from (DESC <table name>) CC;