DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Varchar & char string manipulation

  1. 11-05-2002, 11:59 PM #1
    mm0073
    mm0073 is offline Junior Member
    Join Date
    Nov 2002
    Posts
    1

    Question Varchar & char string manipulation

    Hi,
    I need to join a varchar2(50) + "-" + char 5
    Can anybody help, pls

    Thank in advance
    Reply With Quote Reply With Quote
  2. 11-06-2002, 12:07 AM #2
    culonbu
    culonbu is offline Member
    Join Date
    Dec 2000
    Posts
    126
    try


    1 select 'varchar25' || '-' || 'char5' str
    2* from dual
    SQL> /

    STR
    --------------------------------------------------------
    varchar25-char5
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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