• Login
  • Become a member
  • RSS
  • Part of the TechTarget network
SearchOracle.com
  • News
    • Latest Headlines
      • Sales reps out of control on issue of software license compliance
      • Oracle to rebrand Fusion Apps as Oracle Cloud Services, analyst charges
      • Aon eSolutions picks Oracle Database Appliance for overseas expansion
      • View All News
    • Featured
      • Business Applications Digest

        Essential resources for business and IT professionals tasked with designing an effective enterprise-wide business applications strategy – covering issues on cloud vs. on-premises apps, purchasing tips, implementation and upgrade best practices and...

        Download Now!
  • Premium
    Editorial
    • E-Books
      • Must-know BI and reporting trends for Oracle eBusiness Suite adopters
      • E-book: Ensuring data quality throughout your Oracle environment
      • Managing batch jobs in Oracle application environments
      • View All E-Books
    • E-Zines
      • Business Information
      • BI Trends + Strategies
      • View All E-Zines
    • E-Handbooks
      • Oracle analytics: Real time isn’t for everyone
      • Giving your Oracle hardware performance a shot in the arm
      • View All E-Handbooks
    • Research
      • Wayne Eckerson explores the market for in-memory visualization tools
  • Oracle
    Topics
    • Topics
      • Database Admin

        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

        Development

        BPEL in Oracle, SQL, PL/SQL, Stored procedures, Java / J2EE, XML, Open Source

        Applications

        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 management

        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

        Fusion

        Oracle and BEA, Application Server, SOA (service-oriented architecture), Data and application integration

        Data Mgmt

        BI (business intelligence), Metadata, Data quality, Data warehousing

      • Infrastructure

        Cloud computing infrastructure, Exadata and Exalogic, Virtual machine, Operating system, Oracle hardware decisions, Oracle on Linux, Grid computing

    • Hot Topics
      • Installation, upgrades and patches
      • Fusion applications
      • Oracle support services
  • Tutorials
    • Advice & Tutorials
      • Oracle database performance tuning guide
      • Oracle applications learning guide
      • Third-party tools for Oracle: Special report
      • Oracle upgrades: Tips and trends
      • Oracle virtualization introduction guide
      • Oracle grid computing and cloud computing: Special report
    • Technology Dictionary
      • Find definitions and links to technical resources
      • Powered by WhatIs.com
  • Expert
    Advice
    • Tips
      • Unlock the potential of the Oracle Exadata architecture
      • Improve database performance with Oracle segment space management
      • Six tips for maximizing your PeopleSoft upgrade or other applications
      • View All Tips
    • Answers
      • Perfect the Oracle RMAN duplicate 10g command
      • Doing SQL arithmetic with SELECT instead of arithmetic operations
      • Managing SQL parent table-child table relations
      • View All Answers
    • Ask a Question
      • Pose a question to the SearchOracle.com Experts
      • Get help from our technical community
      • Powered By ITKnowledgeExchange.com
  • White
    Papers
    • Research Library
      • White Papers
      • Business Webcasts
      • Downloads
      • Powered by Bitpipe.com
    • Product Demos
      • Try out software demos
      • Powered By 2020Software.com
    • Resource Centers
      • View All Resource Centers
  • Blogs
    • Blogs
      • Eye on Oracle
      • Powered By ITKnowledgeExchange.com
  • Home
  • Ask the Experts
  • Perfect the Oracle RMAN duplicate 10g command

    One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.

  • 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.

  • Meet All Experts

Submit a question to our experts

Expert Answers

  • Three facets of Oracle Hyperion implementation

    When implementing an Oracle Hyperion project, a company must be aware of technical, management and roadmap issues.

  • 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.

  • How to copy Oracle Database 9i to new server

    Expert Brian Peasland explains to one puzzled reader how to copy Oracle Database 9i from one production server to another.

  • 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.

  • Why won't TNS listener connect with Oracle Database 11g

    One reader asks why his 64-bit TNS listener won't connect with 32-bit Oracle Database 11g.

  • Where to look for Oracle DBA learning materials

    Readers ask SearchOracle.com expert Brian Peasland where they can find learning materials for becoming a better Oracle database administrator.

  • Call stored procedures inside user-defined functions

    In this expert answer, Brian Peasland explains how to call a stored procedure inside user-defined functions in Oracle Database.

  • Solve a PL-SQL error that creates dynamic tables

    Oracle PL-SQL expert Daniel Clamage answers a question about a problem with doing an “insert” in PL-SQL to create a table dynamically.

  • Inconsistent data type error in Oracle Database 9i

    A reader asks SQL expert Daniel Clamage about an inconsistent data type error he's getting on a query running in Oracle Database 9i.

  • Oracle licensing on Oracle Database Standard Edition

    One reader asks two questions about licensing Oracle Database Standard Edition.

  • Hyperion update has issues with migrating Essbase data

    One reader asks how to properly migrate Essbase data when upgrading from Hyperion 9.3.1 to 9.3.3 and then 11.1.2.1.

  • Oracle third-party support has benefits, drawbacks

    Expert Al Marmero describes the pluses and minuses of Oracle third-party support. Cost, quality and potential litigation are all key considerations.

  • Partitioning and Oracle licenses

    One reader asks expert Scott Rosenberg from Miro Consulting about partitioning Oracle software licenses.

  • Understanding Oracle Exadata Smart Scan

    Expert Shyam Varan Nath explains what Oracle Exadata Smart Scan does and how it can improve query performance on Exadata.

  • Examining mobile applications for J.D. Edwards

    Oracle recently announced some new mobile apps for J.D. Edwards. Expert Al Marmero talks about their benefits and potential drawbacks.

  • Making Monday the start of the week in Oracle SQL

    One reader asks how to set up a report in Oracle SQL so that Monday is the first day of the week.

  • Does storing documents in a database hinder performance

    One reader asks if it is the best practice to store a document inside an Oracle database.

  • Improve the Media Recovery Process in Oracle Data Guard

    One reader asks expert William Cullen why the Media Recovery Process (MRP) in Oracle Data Guard shouldn't be used in multi-node Real Application Clusters (RAC) environments.

  • Creating and retrieving a binary large object (BLOB)

    One reader asks how to create and retrieve a binary large object (BLOB), and SQL expert Karen Morton gives some comprehensive advice and tips.

  • Creating a virtual SQL table for date values

    One reader asks how to use SQL to track his company employees' absentee days, and expert Dan Clamage suggests creating a virtual table.

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
More from Related TechTarget Sites
  • Data Management
  • Business Analytics
  • SAP
  • SQL Server
  • Java
  • Data Center
  • Content Management
  • Financial Applications
  • Data Management
    • From 4GLs to HTML5 desktop apps: Bringing data to the masses

      Advocating wider access to data, speakers at the Information Builders Summit 2013 traced a journey from 4GL tools to HTML5 desktop apps and beyond.

    • Enterprise data quality efforts in good company with MDM, governance

      Combining data quality initiatives with master data management and data governance programs can help ensure that data remains accurate and consistent.

    • Better data quality process begins with business processes, not tools

      Efforts to improve data quality should start with procedural changes to help avoid data errors, then the possible addition of data quality software.

  • Business Analytics
    • Member Exclusive Downloads

      Member Exclusive Downloads from SearchBusinessAnalytics

    • In-memory applications take on big data analytics challenge

      In-memory tools and big data can be a potent analytics mix. But before you put them together, read advice from experienced users and consultants.

    • Texas utility deploys operational intelligence, improves 'on-boarding'

      TXU Energy applied Vitria operational intelligence software to gain a better customer view. Careful processes selection ensured quick performance.

  • SAP
    • Food bank network delivers with SAP mobility

      The nation's largest network of food banks is cutting out labor-intensive paper-bound processes with the help of SAP mobile technology.

    • SAP adds hybris to its SAP CRM tool set: More choices, or confusion?

      One expert calls SAP's purchase of hybris long overdue. Another wonders if SAP is confusing its own SAP CRM customers.

    • Limit returns, SAP procurement expenses with a stability study

      Stability studies, which measure how different materials respond to various conditions, can save companies huge amounts of money, writes Jawad Akhtar.

  • SQL Server
    • SQL Server 2014 'keeps up with the Joneses,' says analyst

      Ovum analyst Tony Baer says that most database platforms are moving toward in-memory features, and SQL Server 2014 is no different.

    • SQL Server high availability: Natural enemy of virtualization?

      Do SQL Server high availability and virtualization go together or not? Find out if virtualization is a good option for you in this tip by Bob Sheldon.

    • SQL Server 2014 due out in late 2013, in-memory OLTP a big feature

      Microsoft announced that the next version of its database, SQL Server 2014, will have in-memory features and be generally available in late 2013.

  • Java
    • Will the Red Hat model work for IaaS cloud computing with OpenStack?

      The Red Hat transition is to move their successful model to IaaS through OpenStack and cloud computing. But will this new move from the JBoss company work as well as RHEL did a decade ago?

    • How Red Hat's Linux and OpenStack IaaS drives Intel's bottom line

      While a major protectorate of intellectual property, Red Hat Linux and OpenStack IaaS offerings provide the bonus of driving innovation, which leads to more chips being purchased, driving revenue at Intel's bottom line.

    • Embracing OpenStack: How Red Hat commoditized open source cloud computing

      By leveraging OpenStack, Red Hat plans to commoditized cloud computing, just like they commoditized open source Linux ten years ago.

  • Data Center
    • Red Hat Open Hybrid Cloud aids private, public cloud management

      Hardware, virtualization, public and private cloud are all converging and need to be managed as one environment. Enter Red Hat's Open Hybrid Cloud.

    • Mainframe modernization takes on urgency

      A Red Hat Summit talk on database and mainframe modernization highlights urgency, need for agility in enterprise development teams.

    • AMD microprocessors regroup to fight another day

      Intel may win the server war, but AMD microprocessors could find more acceptance in another niche market.

  • Content Management
    • Cloud collaboration software connects at networking company Enterasys

      Enterasys Networks ended up with more users than expected when it deployed a cloud-based collaboration system. But that turned out to be a good thing.

    • Data value chain puts the focus on what matters most to a business

      In his career running data management systems for consumer goods companies, Richard Beaver has found a formula for success: the data value chain.

    • Quiz: Implementing digital asset management systems

      Take this quiz to test your knowledge of digital asset management (DAM) technologies and processes.

  • Financial Applications
    • CFOs reap the benefits of BPM tools in efficiency, compliance

      BPM tools can help CFOs reduce errors and enhance the accuracy of reporting and forecasting, experts say.

    • CFOs can seize opportunity to lead good governance over IT

      Get tips from experts on how to enact good IT governance by getting the right people to do the right processes.

    • CFO survey finds interest in analytics and cloud on the rise

      According to a recent survey, CFOs expect to invest more in cloud, mobile and big data technology in coming years and spend less on IT infrastructure.

All Rights Reserved,Copyright 2003 - 2013, TechTarget
  • About Us
  • Contact Us
  • Site Index
  • Privacy policy
  • Advertisers
  • Business partners
  • Events
  • Media kit
  • TechTarget Corporate site
  • Reprints
  • Archive
  • Site map