RE: Create view using CAST to change datatype

From: Saira Somani-Mendelin <saira_somani_at_yahoo.com>
Date: Fri, 19 Mar 2004 10:03:24 -0500
Message-ID: <004301c40dc3$53d5c980$e20110ac@itlap01>

Tom,

That's a great suggestion, but how could I do that in a view? Perhaps like this? CAST(RTRIM(OB_OID) AS NUMBER) OB_OID... would that work?

Here is the view definition:

CREATE OR REPLACE VIEW V_ITH_F
AS
(SELECT
  ITH_RID,
  TRANSACT,
  SKU,
  PKG,
  FROM_LOC,
  TO_LOC,
  TRANSACT_STT,
  WAVE,
  CAST(OB_OID AS NUMBER) OB_OID,
  OB_TYPE,
  CAST(IB_OID AS NUMBER) IB_OID,

  IB_TYPE, 
  OB_LNO, 
  IB_LNO,

ACT_QTY,
WHSE,
FROM
ITH_F);
-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mercadante, Thomas F Sent: March 19, 2004 9:54 AM
To: 'oracle-l_at_freelists.org'
Subject: RE: Create view using CAST to change datatype

Saira,

My first idea would be to trim the blanks from the column thus converting
the value to a null before casting. Would that work? What happens with the
Cast statement when a null value is involved? Can you show the Create View
Sql?

thanks

Tom Mercadante
Oracle Certified Professional

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:57:03 CST