Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.
Solved
Oracle Case statement problem
Posted on 2012-12-27
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
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
2
4 Comments
Active today
What's the error you're getting ?
Here's a reference to using the CASE statement: http://www.techonthenet.com/oracle/functions/case.php
Assuming that LINKLIST, LINE, HEADER and PARAGRAPH are valid values of column SECTION_TYPE, enclose the values in quotes:
CASE SECTION_TYPE
WHEN 'LINKLIST' then
etc
Try that and if you're still getting errors, can you come back with that the error message is ?
Here's a reference to using the CASE statement: http://www.techonthenet.com/oracle/functions/case.php
Assuming that LINKLIST, LINE, HEADER and PARAGRAPH are valid values of column SECTION_TYPE, enclose the values in quotes:
CASE SECTION_TYPE
WHEN 'LINKLIST' then
etc
Try that and if you're still getting errors, can you come back with that the error message is ?
Active today
I would prefer to not use a case here:
Select SECTION_ID, SECTION_TYPE, SECTION_ORDINAL, SECTION_TABLE_CELL,
types.ID AS SECTION_ENTITY
FROM OMNI_ENT_PAGE_CONTENT
Left 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 ) types
on types.type = Section_Type
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
- Query Syntax
- SQL
- Databases
- MySQL Server
- MongoDB
- NoSQL Databases, Percona
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses
Course of the Month14 days, 17 hours left to enroll
649 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.