cancel
Showing results for 
Search instead for 
Did you mean: 

Create table : oracle 10g

viseshu
Frequent Advisor

Create table : oracle 10g

Iam creating an oracle table, trying to use customized data types. I want to predefine data types of userid, description and want to use them in rest of table creations.
Please suggest how to use this.
2 REPLIES
Jean-Luc Oudart
Honored Contributor

Re: Create table : oracle 10g

Hi

not sure what you are trying to achieve here. May be you can detail your question.

for oracle datatype and user defined data types refer to the Oracle documentation :
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements001.htm#i46376
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_8001.htm#BABHJHEB

Regards
Jean-Luc
fiat lux
josedial
Occasional Visitor

Re: Create table : oracle 10g

Hi Reinhard,

Sorry, posting this here :) , but in another question you answered that you add one Script "db_monitor.sql", may you share with me this script thanks.

josedial