Re: how to declare type data

"Sergio Cotti" <sergiof31_at_hotmail.com> wrote in message news:662333daca44ab80bbe563aae491575b.18240_at_mygate.mailgate.org...
> Yes, but i want to known what can i do to declare an data type record.
> es. create table test
> ( data Date.....);
>
> and i want to specify the format of the Date type.
>
> thanks in advance.
> Daniele.
>
>
> --
> Posted from [213.156.38.68]
> via Mailgate.ORG Server - http://www.Mailgate.ORG

You can't specify the format of the date datatype. You can force users to use a specific format in many different fashions, one of them setting the registry var/environment var NLS_DATE_FORMAT to the appropiate value.

Hth,

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address