Operating System - HP-UX
1748185 Members
4438 Online
108759 Solutions
New Discussion юеВ

Re: 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 2
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
New Member

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