且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在Oracle 10g中获取Newline中的列值

更新时间:2022-12-09 19:48:48

其实从什么你粘贴到这里很难找到你想要的输出格式。


亲爱的rski,

我直接编辑但是格式不正确,尽管如此我编辑了我需要的格式,如上所述,我必须在这里编辑和粘贴它?请告诉我?


使用[code]标签。

你想要这样的东西吗?
展开 | 选择 | Wrap | 行号

Hi Everyone,
Here my requirement is,
My Emp table have the following 3 columns,

Id , Name and programming

it has the following values,

Id Name Programming
-- ---- -----------
1 Raju Java,Plsql,sql
2 Kamal C,C++,Java


now I need the output in the following format,
Id Name Programming
-- ---- -----------
1 Raju Java
plsql
sql
2 kamal c
c++
Java.

Can anyone suggest me the code to get the above format?
Thank you in advance.


With regards,
gurujothi.D

Actually from what you paste here it is hard to find out what output format do you want.


Dear rski,
Directly I edited but it is not a right format,eventhough i edited the format which i need it became like above, from where i have to edit and paste it here? please let me know?


Use [code] tags.
Do you want something like that?
Expand|Select|Wrap|Line Numbers