Forms 4.5: How to store/display leading zeros?
From: Barry Prentiss <thebear_at_slac.stanford.edu>
Date: 1998/05/15
Message-ID: <355C57C4.71C15726_at_slac.stanford.edu>#1/1
Date: 1998/05/15
Message-ID: <355C57C4.71C15726_at_slac.stanford.edu>#1/1
Hello Oracle Fans,
[Quoted] I am new to Oracle, Oracle Forms and SQL & PL/SQL. I have a problem
where our dwg numbers are segmented into multiple fields (ie. PREFIX,
SERIES, BASE, AND SUFFIX), the last three fields are NUMBER fields. How
do I store and display leading zeros?
EX: dwg no: SA-001-002-03 displays SA-1-2-3.
Thx in Advance...
-- _____________________________________________________________ Barry Prentiss Software and Systems Design (650)926-3812 Stanford Linear Accelerator thebear_at_slac.stanford.edu Stanford UniversityReceived on Fri May 15 1998 - 00:00:00 CEST