view counter
Home

Database Feed

Oracle Database, Oracle 10g, Oracle 11g, Oracle XE, Oracle RAC, Oracle Instant Client, Oracle Data Guard and Oracle Exadata resources, news, and support articles.

Analytic functions within Pivot statements

Today I found that SQL analytics go hand in hand with PIVOT statements.

I had percentage data pivoted by a certain column, but I needed to sort it by
the total across each row.

For the purpose of this demo I create a table with some random monthly data

create table my_data as 
select /*+ no_merge */ username, round(dbms_random.value(1,12)) mth, round(dbms_random.value(1,100),0) val 
from my_users connect by level < 4;

Now with the following query I transpose the monthly totals across as columns using the PIVOT.

May 21, 2013 6:00pm

Just lost all of my data...

I guess my database got corrupted and all of my data is showing as corrupted. Even the backup. I contacted Oracle about the situation but there was little they could do. Is there any way to save my information so it isn't all lost?
May 21, 2013 2:40pm

DROP TABLE ... PURGE

I tested this on Oracle 11.2.0.2.7. If the recyclebin is in use:

May 21, 2013 2:00pm

Top 12 reasons why you should NOT attend the NoCOUG conference tomorrow (Wednesday)

#12 All NoCOUG emails automatically go to your spam folder, including this one. You rely on Outlook for career guidance. #11 They won’t send a stretch limousine to pick you up and take you back. #10 They talked up SQL for 25 years but now, they’re all, like, “No SQL.” I mean, really! #9 You’re […]

May 21, 2013 12:13pm

conceptual erd model

Hello guys,

I am studding a basic course of database and I was asked to do a project which I could not start because of conceptual erd model.

the project asks to create a conceptual and logical ERD diagrams first before moving on to scripts, but i could not translate the text to entities, or well In the questions it says i should have at least 8 entities but i got 6..
if you can help me i would be glad...

here is the question..

May 21, 2013 10:26am

Cloud-based BPM offers dramatic advantages

New advancements in cloud-based business process management (BPM) software is empowering different departments to connect and share information more easily, while automation is driving new opportunities for improving efficiency. With remote database support, companies can migrate these systems to the cloud for optimal functionality and to immediately leverage other benefits.

May 21, 2013 9:26am

ODA re-imaging could take anything between 20 and 120 mins

20 mins vs 2 hours

Recently I have noticed that re-imaging process on the second Oracle Database Appliance node took significantly shorter time comparing with the first node. The difference was so significant that I started to suspect that there were something wrong with either particular set of hardware or some of the re-imaging process steps have failed on the second node. On the first node the process has completed  in 120 minutes, but  on the second it took just 20 around minutes.

May 21, 2013 8:46am

Targetbase gets deeper insight and 40x faster query response with Oracle Exadata

This is a great example of the evolution happening in Oracle Data Warehousing environments as customers consolidate databases into a single source of truth for their businesses with Oracle Exadata. Not only was Targetbase able to integrate large volumes of social, retail, and point-of-sale (POS)
data, such as Web blogs, to drive richer and more actionable insights
for their clients. They enabled real-time analytics scoring and consumer-specific text mining on large volumes of marketing-related data while achieving some great performance gains with up to 40x faster queries.

May 21, 2013 8:20am

High Performance Tuning Tools

Performance Tuning

Obligatory Melodrama

No matter how much time goes by I still remember it. The day my database was crippled beyond reckoning. That moment when I saw my hopes for a bright and shining future with my database spill through my fingers like so many cracker crumbs falling on a clean and well pressed pair of slacks.

May 21, 2013 4:30am

em12c agent software unavailable

Sometimes you need to deploy new agent to different machine or database, and to do that you have to add target and choose which platform installed but Agent software unavailable  this is the message you will see.

May 21, 2013 3:52am
view counter