OraFAQ Forum: SQL & PL/SQL » Custom field type in Oracle

Home » SQL & PL/SQL » SQL & PL/SQL » Custom field type in Oracle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Custom field type in Oracle [message #246444]

Thu, 21 June 2007 00:34

majstoru
Messages: 68
Registered: October 2006
Location: Serbia

Member

Hi,

I was read somwhere in Oracle documentation that user can made own field type (field type, length, default value,...) and later use this for creating new tables, am I rigth?

Thanks in advance!

Report message to a moderator

Re: Custom field type in Oracle [message #246448 is a reply to message #246444]

Thu, 21 June 2007 00:45

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I was read somwhere in Oracle documentation that user can made own field type (field type, length, default value,...) and later use this for creating new tables, am I rigth?
I give up; please cite where this was read.

Report message to a moderator

Re: Custom field type in Oracle [message #246450 is a reply to message #246444]

Thu, 21 June 2007 00:46

majstoru
Messages: 68
Registered: October 2006
Location: Serbia

Member

Ok, I'll find this into my books and retype all sentence.

Thanks!

Report message to a moderator

Re: Custom field type in Oracle [message #246477 is a reply to message #246450]

Thu, 21 June 2007 01:25

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Yes you can create your own SQL types and use them later on. You are right.

MHE

Report message to a moderator

Re: Custom field type in Oracle [message #246492 is a reply to message #246477]

Thu, 21 June 2007 01:50

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Give them default values?

Regards
Michel

Report message to a moderator

Re: Custom field type in Oracle [message #246495 is a reply to message #246492]

Thu, 21 June 2007 01:55

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Just a minute. I'll check. Very Happy

[Edit]Coming to think of it: defaults are defined at table level. It doesn't make sense to give defaults at type level. You could, however create your own constructor function. Perhaps it's a way to define default values. I'm not sure about it though.

MHE

[Updated on: Thu, 21 June 2007 02:10]

Report message to a moderator

Re: Custom field type in Oracle [message #246502 is a reply to message #246495]

Thu, 21 June 2007 02:29

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Makes sense.

Regards
Michel

Report message to a moderator

Previous Topic:	getting error while executing SQL script
Next Topic:	%

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 18 21:12:00 CST 2025