Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2006
    Posts
    13

    Unanswered: stuff equialent function in oracle

    Dear Folks,
    Please tell me the sql server stuff() equialent function in Oracle. it has four input parametres.


    thank you very much

  2. #2
    Join Date
    Nov 2003
    Posts
    2,934
    Provided Answers: 12
    It would help a lot if you told us what the stuff() method did or - even better - what you want to achieve.

  3. #3
    Join Date
    Nov 2006
    Posts
    13

    stuff equialent function in oracle

    the function works like this

    SELECT STUFF('abcdef', 2, 3, 'ijklmn')
    GO

    Here is the result set:

    ---------
    aijklmnef

    (1 row(s) affected)



    can you please address me the equialent function in oracle please

  4. #4
    Join Date
    Aug 2004
    Location
    France
    Posts
    754
    I don't think so...

    Here is a solution :
    Code:
    rbaraer@Ora10g> SELECT SUBSTR('abcdef', 1, 1)||'ijklmn'||SUBSTR('abcdef', 5) FROM DUAL;
    
    SUBSTR('A
    ---------
    aijklmnef
    
    rbaraer@Ora10g>
    Or a slightly different one :
    Code:
    rbaraer@Ora10g> SELECT REPLACE('abcdef', 'bcd', 'ijklmn') FROM DUAL;
    
    REPLACE('
    ---------
    aijklmnef
    
    rbaraer@Ora10g>
    HTH & Regards,

    rbaraer
    ORA-000TK : No bind variable detected... Shared Pool Alert code 5 - Nuclear query ready .

Posting Permissions

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