Re: Dynamice SQL in Oracle

User DA Morgan wrote:

>
> Heck if you had read even one
> page of Oracle documentation you'd know you should not be using the
> VARCHAR data type to create a table.

Looks like VARCHAR is first ever type created in Oracle, having typecode 1. :-)

++***

SELECT o.NAME, a.version#, a.version, a.typecode, a.properties,

        a.ATTRIBUTES, a.methods
   FROM sys.type$ a, sys.obj$ o
  WHERE a.toid = o.oid$
    AND ( a.properties = 80 )
  ORDER BY a.typecode

-- 
Noel