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