| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.oracle -> Re: Forms 3.0 question
Albert L. Evans, IV (ae0i+@andrew.cmu.edu) wrote:
>
> Is it possible to center a string of text in a field and if so, how? Hopefull
y
> there is an easy way to do it, rather than having to resort to obscure SQL
> text manipulation functions. Thanks,
>
> Bert Evans
I've done this to get a screen heading centered in a field on the top line and it basically does involve using text manipulation. I'm writing this at home so I dont have the exact code but it uses LEN to get the string length, subtracts this from the field length and then LPADs the string with spaces (if I remember correctly). If it helps, I can get the exact code and post it although I would love to see a better solution
Regards
Ian
-- _________________________________________________________________ EMAIL =---> idixon_at_infocom.co.uk (Ian Dixon) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Received on Tue Nov 24 1992 - 16:18:51 CST
![]() |
![]() |