hi i have the following query
select -- substr(msg_name,1,8),
fld_seq_no,
substr(fld_name,1,40) fld_name, fld_type, fld_length,
fld_precision
from message_dict
where msg_name like ('&msg')
order by fld_seq_nO
;
which retun following values
FLD_SEQ_NO FLD_NAME FLD_TYPE FLD_LENGTH FLD_PRECISION
--------------------------------------- ---------------------------------------- -------- --------------------------------------- ---------------------------------------
10 IDMSTYPE_100 CH 1
20 SASTIME_100 DF 14
i have another query which got this
SQL> SELECT MSG_TEXT FROM msg_in WHERE stream = 'TESTBASIC'
MSG_TEXT
--------------------------------------------------------------------------------
U201605170000001122334455667788990065465465465033024tONYTEST
i what the value to display as
I what to trim the msg_text based on the FLD_LENGTH AND POPULATE in extra column
FLD_SEQ_NO FLD_NAME FLD_TYPE FLD_LENGTH FLD_PRECISION Value
--------------------------------------- ---------------------------------------- -------- --------------------------------------- --------------------------------------------------------------------------
10 IDMSTYPE_100 CH 1 U
20 SASTIME_100 DF 14 20160517000000
desc msg_in
Name Type Nullable Default Comments
------------- ----------- -------- ------- --------
MSG_TEXT LONG