From: mike_legs <mike_legs@my-deja.com>
Subject: table/view datatype mismatch
Date: 2000/03/03
Message-ID: <89paht$33q$1@nnrp1.deja.com>#1/1
X-Http-Proxy: 1.0 NYCIAS1, 1.0 x27.deja.com:80 (Squid/1.1.22) for client 206.189.172.12
Organization: Deja.com - Before you buy.
X-Article-Creation-Date: Fri Mar 03 21:24:18 2000 GMT
X-MyDeja-Info: XMYDJUIDmike_legs
Newsgroups: comp.databases.oracle.server
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)


I'm creating a view over a few tables that share the same columns.
for example:

TABLEA
  ID   NUMBER(10)
  NAME VARCHAR(20)
TABLEB
  ID   NUMBER(10)
  NAME VARCHAR(20)

with the view basically being a union of the two tables.

when selecting ID from the tables, the data type returned by the
database is integer(32bit), but when selecting ID from the view, the
data type is double(64bit).  this is becoming rather annoying, and I
was hoping someone may know of a way to fix the view to force a certain
datatype, or tell me what i'm doing wrong here.  thanks in advance.

by the way, when i DESCRIBE the view, it shows:
ID NUMBER(10)    (same as in both tables)

mike


Sent via Deja.com http://www.deja.com/
Before you buy.