email template placeholders

Posted on 2011-04-29
Last Modified: 2013-12-07
took a email template from a table . have to add a place holder to hold a banner in the template
how to add place holder and replace it with a different banner
Question by:thota198
    LVL 40

    Accepted Solution

    Simplest manner would be to use REPLACE() and some easy pattern.

     select REPLACE('HELLO <NAME>, HOW ARE YOU', '<NAME>', 'TOM') from dual;

    LVL 40

    Expert Comment

    If the banner / template is more complex, consider using REGEXP_REPLACE(), the regular expression version, though this requires 10g and up.
    LVL 73

    Expert Comment

    are you attempting the same thing as in this question?

    Author Closing Comment

    i didnt get it in the output
    LVL 73

    Expert Comment

    if the results aren't what you wanted,  why did you close the question?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
    Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
    This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now