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.
I tested this on Oracle 220.127.116.11.7. If the recyclebin is in use:
#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 […]
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..
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.
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.
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.
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.
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.