Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Re: Forms 3.0 question

Re: Forms 3.0 question

From: Ian Dixon <idixon_at_infocom.UUCP>
Date: 24 Nov 92 22:18:51 GMT
Message-ID: <432@infocom.UUCP>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US