Shulou(Shulou.com)06/02 Report--

This article mainly explains "Oracle multi-line data how to change to one line", the content of the article is simple and clear, easy to learn and understand, now please follow the editor's ideas slowly in depth, together to study and learn "Oracle multi-line data how to change one line" bar!

CREATE OR REPLACE FUNCTION comm.f_get_diagnosisdesc (v_patient_id diagnosis.patient_id%type,v_visit_id diagnosis.visit_id%TYPE,v_diagnosis_type diagnosis.diagnosis_type%type)

-- convert the values of multiple rows of the diagnostic table into one row Zhong Siping 20140610 Nanchang 334 Hospital

RETURN VARCHAR2

IS

V_diagnosis_desc VARCHAR2 (200)

BEGIN

FOR cur IN (SELECT diagnosis_desc from medrec.diagnosis WHERE patient_id = v_patient_id AND visit_id = v_visit_id AND diagnosis_type = v_diagnosis_type)

LOOP

V_diagnosis_desc: = v_diagnosis_desc | | cur.diagnosis_desc | |';'

END LOOP

V_diagnosis_desc: = Trim (v_diagnosis_desc)

RETURN v_diagnosis_desc

END f_get_diagnosisdesc

-- create synonyms

Create or replace public synonym f_get_diagnosisdesc for comm.f_get_diagnosisdesc

Commit

Thank you for your reading, the above is the content of "Oracle multi-row data how to turn a row", after the study of this article, I believe you have a deeper understanding of the problem of how to turn Oracle multi-row data into one line, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.