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 all, I want to remove all characters after result below : select ip from tab1 ; 192.168.161.40/20 ====> REMOVE "/20"
Should I use TRIM? or regexp_replace ? I'm not good on this :(