如何在PL SQL Oracle中以逗号分隔的格式分隔字符串 [英] How to Separate a String With Comma Separated Format in PL SQL Oracle

问题描述

我有一个用PL SQL编写的函数，该函数以逗号分隔格式返回(A，b，C，D)中的值.
现在，我想将每个值分配给PlSQL中的变量.

因此，让我知道如何在PL SQL中使用分割逗号分隔的返回返回字符串.

在此先感谢

Sushil Dharmar ..

I have a Function Written in PL SQL which returns a Value in (A,b,C,D) with Comma Separated Format.
Now i Want to Assign Each Value to an Variable in PlSQL.

So Let Me Know how To use the Split The Return Written String with Comma Separated in PL SQL.

Thanks in Advance

Sushil Dharmar..

推荐答案

请检查
是否存在在plsql中分割字符串的函数? /a> [ ^ ]
和
在PL/SQL存储的proc中分离逗号分隔的字符串 [ ^ ].

希望他们能帮上忙.

Please check
Is there a function to split a string in plsql?[^]
and
Splitting comma separated string in a PL/SQL stored proc[^].

Hope they help.

这篇关于如何在PL SQL Oracle中以逗号分隔的格式分隔字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！