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: <hatzinger_m_at_bmwf1f.bmwf.gv.at>
Date: 24 Nov 92 07:15:02 GMT
Message-ID: <1992Nov24.074155.58@bmwf1f.bmwf.gv.at>

In article <0f4GwZK00WB78ggVAv_at_andrew.cmu.edu>, "Albert L. Evans, IV" <ae0i+@andrew.cmu.edu> writes:
>
> Is it possible to center a string of text in a field and if so, how? Hopefully
> there is an easy way to do it, rather than having to resort to obscure SQL
> text manipulation functions. Thanks,
>
> Bert Evans

-- 

The only way I know !

field := LPAD(field,TRUNC((LENGTH(field)+screen_length)/2));

kind regards

Mike

================================================================================
                                                                          ^
 Federal Ministry of Science and Research                               B | M
<-------------------------------------------------------------------------+---->
 Computer Center                                                        W | F
                                                                          |
 Klaus-Michael Hatzinger            mail: hatzinger_m_at_bmwf1f.bmwf.gv.at   |
 Bankgasse 1/209                   phone: 0043-222-53120/5188             |
 1014 Vienna, Austria                fax: 0043-222-53120/5155             V
================================================================================
Received on Tue Nov 24 1992 - 01:15:02 CST

Original text of this message

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