데이터베이스 질문과 답변
by 205 [2012.04.25 11:44:21]
with test as (
select '2002990801' as prod_id,'10' as div,'2001623843' as svc ,'PD21000050' as id_prod,'30' as status ,'20120406' as str ,'99991231' as en,'10' as etc from dual union all
select '2002990802' as prod_id,'20' as div,'2001623843' as svc ,'AN' as id_prod,'30' as status ,'20120406' as str ,'99991231' as en,'10' as etc from dual union all
select '2002990803' as prod_id,'20' as div,'2001623843' as svc ,'AL' as id_prod,'30' as status ,'20120406' as str ,'99991231' as en,'10' as etc from dual )
select * from test;
이런식으로 테이터가 잇을때
서브쿼리나 셀프조인 않쓰고
아래처럼 결과가 나오게 하고 싶어요..
2002990801 10 2001623843 PD21000050 30 20120406 99991231 10 PD21000050
2002990802 20 2001623843 AN 30 20120406 99991231 10 PD21000050
2002990803 20 2001623843 AL 30 20120406 99991231 10 PD21000050
도와주세요~ㅜㅜ
문제에 대한 설명이 전혀 없네요?
마농님 말씀대로 설명이 너무 부족합니다.
여러개의 컬럼이 아닌 하나의 컬럼에 데이터가 쭉 나오게 하고 싶으신 건가요?
맞다면 너무 간단합니다.
select prod_id || ' ' ||
div || ' ' ||
svc || ' ' ||
id_prod || ' ' ||
status || ' ' ||
str || ' ' ||
en || ' ' ||
etc || ' ' ||
id_prod
from test;
) 버튼을 클릭하여 작성 하시면 됩니다.