Forum Stats

  • 3,853,873 Users
  • 2,264,288 Discussions


Equivalents To SQL Server's STUFF() Function



  • Paulzip
    Paulzip Member Posts: 8,756 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.



This discussion has been closed.