How to remove characters from the right side of a text expression in Oracle

In Oracle RTRIM function removes all the rightmost characters matching string from Characters. The syntax for the RTRIM function is: RTRIM(character,Removing String)
For Example:

SELECT RTRIM('FOREST','EST') FROM DUAL;

Result: FOR


Comments

  1. Just say Hello to all, and offcourse especially to the owner on this blog. what can i say that this blog is very vital it is very helpful in my blog too. :)
    do check it
    Quick Money

    Thank you add comment too :)

    ReplyDelete

Post a Comment

Popular posts from this blog

How to create Oracle stored Procedures using TOAD for Oracle

Create Tables in Oracle Database using TOAD

How to Create Packages in Oracle Database using TOAD for Oracle