Home » SQL & PL/SQL » SQL & PL/SQL » Custom field type in Oracle
Custom field type in Oracle [message #246444] Thu, 21 June 2007 00:34 Go to next message
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!
Re: Custom field type in Oracle [message #246448 is a reply to message #246444] Thu, 21 June 2007 00:45 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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.
Re: Custom field type in Oracle [message #246450 is a reply to message #246444] Thu, 21 June 2007 00:46 Go to previous messageGo to next message
majstoru
Messages: 68
Registered: October 2006
Location: Serbia
Member
Ok, I'll find this into my books and retype all sentence.

Thanks!
Re: Custom field type in Oracle [message #246477 is a reply to message #246450] Thu, 21 June 2007 01:25 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Yes you can create your own SQL types and use them later on. You are right.

MHE
Re: Custom field type in Oracle [message #246492 is a reply to message #246477] Thu, 21 June 2007 01:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Give them default values?

Regards
Michel
Re: Custom field type in Oracle [message #246495 is a reply to message #246492] Thu, 21 June 2007 01:55 Go to previous messageGo to next message
Maaher
Messages: 7062
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 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Makes sense.

Regards
Michel

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


Current Time: Wed Dec 07 22:11:14 CST 2016

Total time taken to generate the page: 0.11738 seconds