Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!swrinde!zaphod.mps.ohio-state.edu!magnus.ircc.ohio-state.edu!tut.cis.ohio-state.edu!dsac.dla.mil!dsacg3.dsac.dla.mil!dsacg2.dsac.dla.mil!nol1085
From: nol1085@dsacg2.dsac.dla.mil (Gregory S. Elich)
Newsgroups: comp.databases
Subject: Novice Oracle/SQL*Calc Question
Message-ID: <2922@dsacg2.dsac.dla.mil>
Date: 8 Feb 91 15:47:07 GMT
Organization: Defense Logistics Agency Systems Automation Center, Columbus
Lines: 15


    I am just beginning to teach myself to use Oracle, and I've run into
 a problem that I'm unable to solve.  I've built a small phone directory
 database. I'm using SQL*Calc to build the input data. However, when typing
 extension numbers, I found that SQL*Calc blanks out any leading zeros,
 so that extension 0566 becomes 566.  I tried checking /layout/modify-styles
 to see which option does Not "blank when 0" (option 5). Then, I selected
 layout/style. The prompt says "enter number of layout/modify-styles style
 setting (1-8)", so I enter "5" at this point. Then, when I enter 0566,
 SQL*Calc still blanks out the leading zero. How can I prevent this? 
 My version of Oracle is 5.1, and my SQL*Calc is version 1.1.
-- 
Gregory Elich     gelich@dsacg2.dsac.dla.mil      AV 850-9753  ATT 614-238-9753
Defense Logistics Agency Systems Automation Center  
DSAC-OLA, P. O. Box 1605, Columbus, OH  43216