Do SQL arithmetic without using arithmetic operations

Learn how to do simple SQL arithmetic operations without using the arithmetic operators.
Managing SQL parent table-child table relations

Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.
Using SQL SELECT, SQL UNION ALL statements for sorting

Expert Dan Clamage explains how to use SQL SELECT and SQL UNION ALL statements to sort and visualize a set of sales figures.
Confusion around PL/SQL to_date and to_char functions

One reader asks expert Daniel Clamage about the PL/SQL to_date and to_char functions and how to properly convert date and string values.

Using Oracle PL-SQL

Email Alerts

Register now to receive SearchOracle.com-related news, tips and more, delivered to your inbox.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Testing for holidays, part 2

Ask the Expert
Testing for holidays, part 1

Ask the Expert
How to find source code

Ask the Expert
Calculating approval date, part 2: A faster day counter

Ask the Expert
Calculating approval date, part 1: Counting days

Ask the Expert
Calculating approval date, part 3: Code for a faster day counter

Ask the Expert
Selecting non-NULL values, part 2

Ask the Expert
SQL vs. PL/SQL

Ask the Expert
Selecting non-NULL values

Ask the Expert
Fixing duplicate primary keys

Ask the Expert

Data Management
- New BI stack tackles data load at Boston Children's Hospital
  
  Boston Children's Hospital upgraded its business intelligence architecture to boost enterprise reporting, a move that also required retraining users.
- Expanded Hadoop use cases will drive need for new enterprise features
  
  With user interest rising, Hadoop vendors are trying to pave a path to higher adoption with add-ons that target issues holding the technology back.
- Jim Goodnight on SAS in-memory analytics and the data scientist
  
  A podcast Q&A with SAS execs Jim Goodnight and Jim Davis looks at big data enablers, including in-memory analytics, and the role of data scientists.
Business Analytics
- Marketing and advertising remain sweet spots for big data technology
  
  Marketing and advertising are the sweet spots for big data, but those who serve up marketing insights and ad space will need to evolve to survive.
- Strategies for de-cluttering business intelligence dashboard designs
  
  Expert Brian Jordan shows business intelligence managers how to avoid developing dashboards that overwhelm business users with too much information.
- Making mobile BI applications a reality: Key steps to take
  
  In a podcast, BI expert William McKnight discusses best practices and action items for managing deployments of mobile business intelligence tools.
SAP
- Ariba Network announces QuickBooks integration
  
  At its annual conference, Ariba announced a new tool by partner Dell Boomi that lets small businesses integrate their QuickBooks accounting with the Ariba Network.
- Software license audits come in different forms, expert says
  
  Your next software license audit may be an inventory optimization exercise in disguise. Either way, the trick is to be prepared, writes one analyst.
- Sentiment analysis just part of the SAP social media vision
  
  Social media in the enterprise is in constant flux. One of SAP's top social media chiefs lays it out, from sentiment analysis to social collaboration.
SQL Server
- Adam Machanic talks SQL Saturday
  
  We caught up with Adam Machanic, group leader of the New England SQL Server user group, at SQL Saturday Boston. Find out what he shared with us.
- SQL Server meets database application security
  
  Make sure your SQL Server is secure by studying these general guidelines for secure database applications from SQL Server expert Roman Rehak.
- xVelocity Columnstore Indexes in SQL Server 2012
  
  Curious about how xVelocity can help with your columnstore indexes? Check out this tip from Basit Farooq to find out.
Java
- JSR-286 development tutorial: Mastering request-response programming
  
  This portlet programming tutorial shows how the PortletRequest and Portlet Response are used when developing JSR-286, request-response based apps.
- JSR-286 development tutorial: An introduction to portlet programming
  
  This portlet programming tutorial is an introduction to developing JSR-286 applications that can be deployed to any standards-based portal server.
- Mastering Tomcat: Installation, configuration, logging and optimization
  
  To master the Apache Tomcat server, administrators and developers need to be familiar with installation, configuration, logging and performance optimization
Data Center
- Data center technologies evolve to meet tomorrow's computing demands
  
  VMware's upcoming public cloud and AMD's 64-bit ARM servers are technologies for the data center that exemplify the changes in the IT industry.
- New data center cooling strategies to improve efficiency, lower costs
  
  Stagnant strategies for data center cooling will keep energy bills climbing ever higher, but a more modern approach can bring them back down to earth.
- Converged systems usher in data center transformation
  
  The rise of converged systems has brought a new level of manageability to the data center, but these integrated offerings have a few drawbacks.
Content Management
- Get 'em ready: Tips for planning a SharePoint 2013 training program
  
  SharePoint is a complex application. But training business users for an upgrade to SharePoint 2013 doesn't have to be a daunting task for IT teams.
- The organization of the future: Not just hybrid IT, but hybrid people
  
  The adoption of hybrid IT approaches creates a need for executives who can both formulate business objectives and assess IT requirements.
- SharePoint technology feels growing pains as 2013 release arrives
  
  SharePoint 2013 adds new features to the collaboration software. But it comes at a time when SharePoint's value is being questioned in some quarters.
Financial Applications
- IaaS business scales faster with Zuora billing software
  
  While a user testified to the benefits of Zuora specialty billing software, an expert said the niche tool is not necessary for all.
- Analytics, global HR hot topics at Bersin conference
  
  In this podcast, associate site and news editor Emma Snider recaps some of the key takeaways from Bersin by Deloitte's Impact 2013.
- Offboarding automation reduces risk, manual labor
  
  With HR's focus on onboarding, the offboarding process often gets short shrift. But making do with checklists and spreadsheets can lead to problems.

Latest Headlines

Featured

E-Books

E-Zines

E-Handbooks

Research

Topics

Hot Topics

Advice & Tutorials

Technology Dictionary

Tips

Answers

Ask a Question

Research Library

Product Demos

Resource Centers

Blogs

Using Oracle PL-SQL

Email Alerts

More from Related TechTarget Sites