table/view datatype mismatch

From: mike_legs <mike_legs_at_my-deja.com>
Date: 2000/03/03
Message-ID: <89paht$33q$1@nnrp1.deja.com>#1/1

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. Received on Fri Mar 03 2000 - 00:00:00 CST