TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
patrick
NA
397
0
Oracle select, concatenate, deselect
May 19 2014 10:37 AM
I have a field that a software vendor formatted strangely, and I need to format it a certain way on select
I use two case statements,
CASE(WHEN TRANS_NUM = ---- )"TIME_POSTED1"
CASE(WHEN TRANS_NUM = ----) "TIME_POSTED2"
- This works fine, but I need to return them as one Column, and eliminate the first two Columns,
so it would be TIME_POSTED1 || TIME_POSTED2 AS TIME_POSTED
and "DESELECT" TIME_POSTED1, TIME_POSTED2
How can I do this?
Reply
Answers (
0
)
problem with procedures ( select query and cursors ) Oracle
Why is this join returning multiple results