Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them.
COURSE of the MONTH
9 days, 2 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
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 1 day ago
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
![[Webinar] How Hackers Steal Your Credentials](https://filedb.experts-exchange.com/files/public/2017/5/20/3315d9d8-8110-4d52-be94-a5aacdd83e4b.png)
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
- Acronis
- Databases
- Oracle Database
- MongoDB
- Oracle
- *Backup Software
This video shows how to copy a database user from one database to another user DBMS_METADATA. It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to take different types of Oracle backups using RMAN.
Suggested Courses
Course of the Month9 days, 2 hours left to enroll
764 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.