Return-Path: <root@fatcity.cts.com>
Received: from ensim.rackshack.net (root@localhost)
 by orafaq.net (8.11.6/8.11.6) with ESMTP id g9AGXdM04001
 for <oracle-l@orafaq.net>; Thu, 10 Oct 2002 11:33:39 -0500
X-ClientAddr: 209.68.248.164
Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164])
 by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id g9AGXcD03992
 for <oracle-l@orafaq.net>; Thu, 10 Oct 2002 11:33:39 -0500
Received: from fatcity.UUCP (uucp@localhost)
 by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id HAA25454;
 Thu, 10 Oct 2002 07:13:57 -0700 (PDT)
Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 004E595B; Thu, 10 Oct 2002 06:28:27 -0800
Message-ID: <F001.004E595B.20021010062827@fatcity.com>
Date: Thu, 10 Oct 2002 06:28:27 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
X-Comment: Oracle RDBMS Community Forum
X-Sender: DENNIS WILLIAMS <DWILLIAMS@LIFETOUCH.COM>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: DENNIS WILLIAMS <DWILLIAMS@LIFETOUCH.COM>
Subject: RE: Packed decimal
Organization: Fat City Network Services, San Diego, California
X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain;	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Russ - What do you have in mind? Oracle stores numbers in its own format in
its own datafiles. Are you looking to hack the Oracle datafiles? Or do you
have an input file in packed decimal format that your are looking at loading
into Oracle? If you could tell us the objective you are seeking to achieve,
perhaps we could help you. Or maybe not. :-) My schedule doesn't allow me
much spare time to hack Oracle datafiles.



Dennis Williams
DBA
Lifetouch, Inc.
dwilliams@lifetouch.com 

-----Original Message-----
Sent: Wednesday, October 09, 2002 2:09 PM
To: Multiple recipients of list ORACLE-L


Hi,
  Is there any way to identify values in a field, defined in Oracle as
number(11,2), with a packed decimal format?  Or to update the field with
packed decimal values?
 
Thanks,
Russ

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS@LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

