GUI sin
Home
Location
Tags
Media
Guestbook
Admin
New Post
database/oracle
여러 row를 하나의 row로 출력
두억시니
2014. 9. 3. 17:06
1
2
3
4
5
6
7
8
SELECT
WMSYS.WM_CONCAT (MESSAGE) MESSAGE
FROM
(
SELECT
LO.MESSAGE MESSAGE
FROM
SMEIS.S_LECTUREOPINION LO
WHERE
LO.YEAR
=
'2014'
AND LO.SEASONCODE
=
'11'
AND LO.SUBJECTCODE
=
'380031'
AND LO.DIVISION
=
'12'
AND MESSAGE IS
NOT
NULL
)
cs
공유하기
글 요소
구독하기
GUI sin
저작자표시
1
2
3
4
5
6
7
8
9
···
12
더보기