关于SQL查询中的数据分离. [英] regarding seperation of data in sql query.

问题描述

如何使用任何用户定义的函数或过程通过sql查询基于管道拆分字符串.仅使用oracle预定义函数.

例如. -字符串="abc | sgdf | xyz"

结果s1 ="abc"
s2 ="sgdf"
s3 ="xyz"

how to split a string on basis of pipe through sql query with using any user defined function or procedure. use only oracle predefined functions.

eg. - String = " abc | sgdf | xyz "

result s1 = "abc"
s2 = "sgdf"
s3 = "xyz"

推荐答案

我们不做作业:它的设置是有原因的.在这里，您可以考虑自己被告知的内容，并尝试理解它.也可以在那里帮助您的导师识别您的弱点，并将更多的注意力放在补救措施上.

自己尝试，您可能会发现它并不像您想的那么困难！

We do not do your homework: it is set for a reason. It is there so that you think about what you have been told, and try to understand it. It is also there so that your tutor can identify areas where you are weak, and focus more attention on remedial action.

Try it yourself, you may find it is not as difficult as you think!

这篇关于关于SQL查询中的数据分离.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！