Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Create view using CAST to change datatype

Create view using CAST to change datatype

From: Saira Somani-Mendelin <saira_somani_at_yahoo.com>
Date: Fri, 19 Mar 2004 09:52:53 -0500
Message-ID: <004001c40dc1$dbe31c80$e20110ac@itlap01>


List,

We have an issue where we would like to join two tables using a column of different data types, so we thought to create a view which could cast one of those join columns to match that of the other.

The problem is that we are trying to cast a character column to a number column, which under normal circumstances would be fine, except that the default value for this column is ' ', we get an error when we try to query on it.

We could of course just go the other way and cast the other table's column as character, but the other table can be joined with many other tables, and for BI reasons, we'd like to keep it that way.

Any help is appreciated.

Thanks,
Saira



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Fri Mar 19 2004 - 08:46:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US