Number Precision in Oracle

[Philip Dodds <ph...@gmail.com>]

Hi

I just starting working with DDL utils in an Oracle 9i environment and the
XML doesn't appear to be storing the precision on the number(8,6)?  Is this
a setting or something I have misunderstood?

Cheers

P

Re: Number Precision in Oracle

[Thomas Dudziak <to...@gmail.com>]

On 4/27/06, Philip Dodds <ph...@gmail.com> wrote:

> I'll rebuild from head,  I was using a version from Feb :)

That should have worked back then (it actually dates back to the
commons-sql time). But it can't hurt to update anyway.

> Is there any plans to extend DDL Utils to allow other types of DB object to
> be handled (ie. PL/SQL/functions/procedures/triggers etc)

As far as it makes sense/is possible in a database-independent way, yes.

Tom

Re: Number Precision in Oracle

[Philip Dodds <ph...@gmail.com>]

I'll rebuild from head,  I was using a version from Feb :)

Is there any plans to extend DDL Utils to allow other types of DB object to
be handled (ie. PL/SQL/functions/procedures/triggers etc)

Cheers

P

On 4/27/06, Thomas Dudziak <to...@gmail.com> wrote:
>
> On 4/27/06, Philip Dodds <ph...@gmail.com> wrote:
>
> > I just starting working with DDL utils in an Oracle 9i environment and
> the
> > XML doesn't appear to be storing the precision on the number(8,6)?  Is
> this
> > a setting or something I have misunderstood?
>
> What are you trying to achieve ? In the XML schema, the
> size/precision+scale information is stored in the size attribute. E.g.
> a column avalue of type DECIMAL(15,7) would be specified as:
>
> <column name='avalue' type='DECIMAL' size='15,7'/>
>
> in the schema XML.
>
> Tom
>

Re: Number Precision in Oracle

[Thomas Dudziak <to...@gmail.com>]

On 4/27/06, Philip Dodds <ph...@gmail.com> wrote:

> I just starting working with DDL utils in an Oracle 9i environment and the
> XML doesn't appear to be storing the precision on the number(8,6)?  Is this
> a setting or something I have misunderstood?

What are you trying to achieve ? In the XML schema, the
size/precision+scale information is stored in the size attribute. E.g.
a column avalue of type DECIMAL(15,7) would be specified as:

<column name='avalue' type='DECIMAL' size='15,7'/>

in the schema XML.

Tom