Forum Stats

  • 3,767,914 Users
  • 2,252,729 Discussions
  • 7,874,380 Comments

Discussions

Equivalents To SQL Server's STUFF() Function

13»

Answers

  • Paulzip
    Paulzip Member Posts: 8,489 Blue Diamond
    edited Jul 28, 2016 3:43PM
    Etbin wrote:
    
    More fuction calls might provide more not null results. 
    Replacing nvl(p_start,0) with case when p_start is null then 0 else p_start end and accordingly might be faster.
    Regards Etbin

    Mine might be more nulls, but it matches the SQL Server notes on the operation and parameters of Stuff function!

    Ray WinkelmanRay Winkelman
  • Etbin
    Etbin Member Posts: 8,968 Gold Crown
    edited Jul 28, 2016 5:16PM

    Until now I was only aware SQL Server exists and most probably such Stuff function parameters specifications (actually limitations) and notes on operation are just another reason to let the before mentioned awareness remain the same.

    Might not be irrelevant to the OP though, but at least in principle, migrating from SQL Server to Oracle requiring Oracle to work according to SQL Server specifications sounds weird (at least to me).

    A kind of modify-everything-without-changing-anything.

    Regards

    Etbin

This discussion has been closed.