Im relatively new to Oracle query syntax so can you help me out with the Case statement.
Select SECTION_ID, SECTION_TYPE, SECTION_ORDINAL, SECTION_TABLE_CELL,
CASE SECTION_TYPE
WHEN LINKLIST
THEN (SELECT LINK_LIST_NAME FROM OMNI_ENT_LINKLIST WHERE LINKLIST_ID = SECTION_ID)
WHEN LINE
THEN (SELECT LINK_ID FROM OMNI_ENT_LINK WHERE LINK_ID = SECTION_ID)
WHEN HEADER
THEN (SELECT LINK_ID FROM OMNI_ENT_HEADER WHERE HEADER_ID = SECTION_ID)
WHEN PARAGRAPH
THEN (SELECT LINK_ID FROM OMNI_ENT_PARAGRAPH WHERE LINK_ID = SECTION_ID)
ELSE ''
END AS SECTION_ENTITY
FROM OMNI_ENT_PAGE_CONTENT
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
Select SECTION_ID, SECTION_TYPE, SECTION_ORDINAL, SECTION_TABLE_CELL, types.ID AS SECTION_ENTITYFROM OMNI_ENT_PAGE_CONTENTLeft Join ( select 'LINKLIST' as Type, Link_List_Name as ID from Omni_Ent_Linklist union select 'LINE', Link_ID from Omni_Ent_Link union select 'HEADER', Link_ID from Omni_Ent_Header union select 'PARAGRAPH', Link_ID from Omni_Ent_Paragraph ) typeson types.type = Section_Type
Open in new window