Re: help with syntax

From: Daniel A. Morgan <Daniel.Morgan_at_attws.com>
Date: Wed, 22 Aug 2001 10:15:26 -0700
Message-ID: <3B83E8AE.8E30155D@attws.com>

bullseye wrote:

> What syntax shows data_type and data_length as: varchar2(30)? Where do I
> concatenate? Where do I use strings? (Do I need to?)
>
> I am querying user_tab_columns.
>
> thank you.

None.

What you would need to do is two complex for a simple query. For example when the data_type is DATE the data_length is listed as 7.

You likely would not want to concatenate together DATE(7).

Daniel A. Morgan Received on Wed Aug 22 2001 - 12:15:26 CDT