CHAR manipulation

From: Steiger Daniel <steiger_at_geo.umnw.ethz.ch>
Date: Fri, 6 May 1994 22:53:54 GMT
Message-ID: <1994May6.225354.16003_at_rzu-news.unizh.ch>


Does somebody know how to manipulate (update) CHAR strings?

SQL> desc sensor

 Name                            Null?    Type
 ------------------------------- -------- ----
 SRKEY                           NOT NULL NUMBER(4)
 SRETHNR                                  NUMBER(5)
 SROBJNR                                  CHAR(12)

SQL> select * from sensor;

     SRKEY SRETHNR SROBJNR
---------- ---------- ------------

        56       1473         1473
        58       1067    1067 -->| move to the right!
        59       1068    1068
        60       1069    1069
        61       1070    1070
        62       1071    1071
        63       1073    1073
        64       1074    1074
        65       1075    1075
        66       1076    1076

I'd like to eliminate all spaces right of SROBJNR, so that the result looks like the first line (SRKEY = 56).

Any hint is greatly appreciated!

Thanks, Daniel.

--


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
please respond to: <steiger_at_csr.lbl.gov> have a good day! :-)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Received on Sat May 07 1994 - 00:53:54 CEST

Original text of this message