topic Create table : oracle 10g in Operating System - HP-UX

Create table : oracle 10g

viseshu — Wed, 22 Jul 2009 06:29:13 GMT

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.

Re: Create table : oracle 10g

Jean-Luc Oudart — Wed, 22 Jul 2009 08:28:52 GMT

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

Re: Create table : oracle 10g

josedial — Fri, 11 Sep 2009 17:42:24 GMT

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