SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Alternate for stuff function of sqlserver

542647Jun 14 2007 — edited Jun 14 2007

Hi,Can Anyone please help me in migrating following code from sqlserver to oracle.

set @sLastItemInPkts_2 = Stuff(@sLastItemInPkts_2,
@iOffset,
@iElementSize,
SubString(@sLastItemInPkts_1,
@iOffset,
@iElementSize)
)

set @sLastItemInPkts_1 = Stuff(@sLastItemInPkts_1,
@iOffset,
@iElementSize,
Convert(varChar(10),
Replace(Str(@iDocId, @iElementSize),
' ',
0))
)

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 12 2007

Added on Jun 14 2007

3 comments

542 views