Oracle DBA tools, Backup and recovery, Database design, Export, import and migration, Installation, upgrades and patches, Error messages, Oracle performance problems and tuning, Oracle security, Availability, Real Application Clusters (RAC), Cloud infrastructure, MySQL database
BPEL in Oracle, SQL, PL/SQL, Stored procedures, Java / J2EE, XML, Open Source
Enterprise and business performance management, E-Business Suite, Implementing and upgrading Oracle apps, Fusion applications, JD Edwards (JDE), PeopleSoft, Hyperion, Siebel and Oracle CRM
Oracle Web 2.0, Oracle strategy and product roadmap, Oracle support services, Oracle vs. SAP, Regulatory compliance, Market analysis, Oracle acquisitions, Oracle on demand and SaaS, Outsourcing, Business process management, Small businesses, DBA jobs training and certification
Oracle and BEA, Application Server, SOA (service-oriented architecture), Data and application integration
BI (business intelligence), Metadata, Data quality, Data warehousing
Cloud computing infrastructure, Exadata and Exalogic, Virtual machine, Operating system, Oracle hardware decisions, Oracle on Linux, Grid computing
For the PO table layout below:
PoNum Part 53831 M1 53831 M1 53832 M1 53833 M2 53831 M2
I need to return that M1 is on two seperate PoNums and M2 is on two PoNums. Any help is greatly appreciated.
By submitting your registration information to SearchOracle.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchOracle.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.
"Separate" PoNums can be counted using the DISTINCT keyword in the COUNT function:
select Part
, count(distinct PoNum) as PoNums
from PO
group
by Part
Easy when you see it, eh?
Terms for Whatis.com - the technology online dictionary
This was first published in May 2006
The latest version of GigaSpaces XAP is designed to let users create their own real time "big data" analytics platform, and more big data news from around the Web.
Educating end users and upgrading internal processes can help enterprises fix data quality problems without dropping a ton of cash, analysts say.
New research shows data virtualization, data governance and master data management initiatives provide higher levels of satisfaction with data quality and data integration.
Organizations will have to push beyond storage requirements and basic business intelligence tools to exploit big data, according to a Gartner analyst.
According to a recent Gartner survey, mobile technology is the second most important priority for CIOs in 2012, but building the business case is easier said than done.
Businesses looking to build effective business intelligence and analytics programs have to toe the line between focusing on the basics and using new technology to build more complex BI systems.
In this SAP Press book chapter excerpt, learn how to build a strong data foundation using the functionality in the SAP Data Services package.
Sapphire 2012 is in the books and, unsurprisingly cloud was a major topic. SAP mentor Jon Reed shares his thoughts on what SAP had to say about modular applications, PaaS and SuccesFactors in this video.
Ventana Research CEO Mark Smith offered up his take on SAP's announcements around HANA, the cloud and predictive analytics at the annual Sapphire conference.
In this second article of a two-part series on new T-SQL statements, expert Serdar Yegulalp reviews command changes to sequencing, date values and more.
Each release of SQL Server brings changes to Transact SQL. In this tip, expert Serdar Yegulalp gives a walkthrough of tweaks like WITH RESULT SETS for renaming columns and THROW for catching errors.
SQL Server Insider e-zine is a quarterly online publication focusing on Microsoft’s enterprise database, SQL Server. Join the editors of SearchSQLServer.com for an in-depth look into the database trends sweeping over Microsoft, including business intelligence, cloud computing and “big data.”
Here at CamelOne 2012, FuseSource is releasing two new products – Fuse ESB Enterprise 7.0 and Fuse MQ Enterprise 7.0.
Automotive rescue and recovery services in the UK gained significant messaging advantages over the past few years. The new Automotive Network Services (ANS) system, built and maintained by Apex Networks, connects automotive clubs and insurance agencies with the mechanics, riggers, and first responders that provide emergency services to accidents and disabled vehicles.
Scaling up and scaling out are two ways for growing businesses to increase productivity, but doing so blindly may be more costly than it's worth.
Data center experts say most enterprises can’t imitate Facebook’s Open Compute Project, but they could reap the benefits over time.
Use strategic capacity planning to future-proof your data center's virtualization efficiency and make the most of server hardware.
Get exclusive access to the High Performance Computing E-Zine, produced quarterly by the independent experts and analysts at SearchDataCenter.com
Information is growing exponentially and the lack of firm record retention schedules is costing organizations big money and will increase liability as time passes, says consultant Randolph Kahn.
Cimarex Energy replaced its SharePoint system with Accellion’s enterprise collaboration platform for secure mobile file sharing and uses it to recruit graduate geology students.
Get expert advice on whether it’s necessary to keep paper or other forms of original materials once a company implements an electronic document management system.
Nucleus Research names Ceridian, ADP among top performers and finds threats to legacy leader Kronos.
Save time and money by establishing human resources processes and scrubbing data before embarking on a project to integrate systems, industry watchers say.
As more companies consider taking human capital management to the cloud, analysts say the on-site version also has its benefits.
Join the conversationComment
Share
Comments
Results
Contribute to the conversation