Attention: To align with new corporate security policies, and to match policies adopted by other communities within Oracle, the My Oracle Support Community access requirements will change beginning September 18, 2025. MOSC will now require that member accounts in our community be associated to a *corporate* email address. This means that users with generic domains (such as gmail.com, yahoo.com, and others) will no longer be granted access to the discussion forums and ideas labs. If this policy affects you, act now to change the email address that is associated with your Oracle (and community) account. Alternatively, you can opt to create a new Oracle account that uses your corporate email domain.

Database DataWarehousing (MOSC)

Simple pivot

Oct 5, 2018 9:10AM edited Nov 27, 2018 9:16PM in Database DataWarehousing (MOSC) 4 commentsAnswered

Hi,

I've a very simple table (see below(. My database version is 12.2.0.1. Now I want to pivot the content Like this

DBName DBVersion MachineName orcl_gtp_contact orcl_gtp_line_of_bus

odwh 12.2.0.1.0 linuxs8889 John Doe DWH database Dep Sales

I've being experimenting with the pivot function but without success. Can someone give a helping hand?

Thanks,

Ivan

Table XX

PROPERTY_NAME	PROPERTY_VALUE
DBName	odwh
DBVersion	12.2.0.1.0
MachineName	linuxs8889
orcl_gtp_contact	John Doe
orcl_gtp_line_of_bus	DWH database Dep Sales

Tagged:

moscmove

1

Howdy, Stranger!

To view full details, sign in to My Oracle Support Community.

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month