+ Reply to Thread
Results 1 to 3 of 3
  1. 01-22-2003 06:20 PM #1
    jags
    jags is offline Junior Member
    Join Date
    Jul 2000
    Posts
    9

    How to update ampersend ( & )

    Hi Guys,

    Any idea how to update & values into the database using PLSQL or Procedure. when I tried it is expecting an input value.

    example : updare emp set emp_name = 'abc & def'

    Regards
    Jag
    Reply With Quote Reply With Quote
  2. 01-22-2003 06:36 PM #2
    LKBrwn_DBA's Avatar
    LKBrwn_DBA
    LKBrwn_DBA is offline Senior Advisor
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,397
    Try:

    set define off
    Reply With Quote Reply With Quote
  3. 01-23-2003 12:40 AM #3
    eugene
    eugene is offline Junior Member
    Join Date
    Jan 2001
    Location
    San Diego, CA
    Posts
    81
    you can also try to use CHR value of &

    'this' ||CHR()||'that'
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules

 Click Here to Expand Forum to Full Width