For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
hi am having this error in this sql SELECT * from emp_msg WHERE substr(rtrim(MSG_TEXT,2)) = 'X'
update emp_msg set msg_test = substr(rtrim(MSG_TEXT,2,'x'))
am in oracle database 11g
data type MSG_TEXT LONG