Skip to content

TechRepublic

  • Top Products Lists
  • Developer
  • 5G
  • Security
  • Cloud
  • Artificial Intelligence
  • Tech & Work
  • Mobility
  • Big Data
  • Innovation
  • Cheat Sheets
  • TechRepublic Academy
  • CES
  • TechRepublic Premium
  • Top Products Lists
  • Developer
  • 5G
  • Security
  • Cloud
  • Artificial Intelligence
  • Tech & Work
  • Mobility
  • Big Data
  • Innovation
  • Cheat Sheets
  • TechRepublic Academy
  • CES
  • See All Topics
  • Sponsored
  • Newsletters
  • Forums
  • Resource Library
TechRepublic Premium
Join / Sign In
Image of bobwatkins

bobwatkins

Send bobwatkins an email

Latest from bobwatkins

  • A change management primer for IT consultants
    Project Management

    A change management primer for IT consultants

    Determining the ability of the client organization to cope with a major IT project can help consultants find the most appropriate solution. Learn how evaluating the client's roles, resistance, and resilience can help you gauge their capacity for change.

    bobwatkins
    Published:  July 4, 2008, 3:50 AM PDT Modified:  July 4, 2008, 3:50 AM PDT Read More See more Project Management
  • What does a DBA do all day?
    Data Management

    What does a DBA do all day?

    Data integrity is a DBA's number one responsibility, but do you know what else they do all day? Bob Watkins outlines some of the basic duties of a DBA.

    bobwatkins
    Published:  June 26, 2008, 9:56 AM PDT Modified:  June 26, 2008, 9:56 AM PDT Read More See more Data Management
  • Practice using Oracle’s Remote Diagnostic Agent before you need it
    Banking

    Practice using Oracle’s Remote Diagnostic Agent before you need it

    Oracle provides a tool called Remote Diagnostic Agent that documents your Oracle installation. Becoming familiar with this tool before you need it can save time when you work with Oracle Support.

    bobwatkins
    Published:  August 6, 2007, 11:34 PM PDT Modified:  August 6, 2007, 11:34 PM PDT Read More See more Banking
  • Avoiding TOO_MANY_ROWS errors in PL/SQL
    Data Management

    Avoiding TOO_MANY_ROWS errors in PL/SQL

    Oracle’s PL/SQL language has two basic mechanisms for getting data from the database: SELECT and cursors. SELECT is designed to return a single row into local variables; cursors give you the ability to select multiple rows (i.e., a “rowset”) and process them one at a time. When you use SELECT in a PL/SQL block, it’s ...

    bobwatkins
    Published:  July 31, 2007, 2:20 AM PDT Modified:  July 31, 2007, 2:20 AM PDT Read More See more Data Management
  • Round and truncate dates in Oracle
    Cloud

    Round and truncate dates in Oracle

    Oracle's TRUNC and ROUND functions apply to date and time values as well as to numbers. Here are some examples of date manipulation using these Oracle functions.

    bobwatkins
    Published:  July 24, 2007, 1:34 AM PDT Modified:  July 24, 2007, 1:34 AM PDT Read More See more Cloud
  • Compute the percentage of a total with Oracle’s RATIO_TO_REPORT
    CXO

    Compute the percentage of a total with Oracle’s RATIO_TO_REPORT

    Computing a percentage of the total report usually requires a subquery. Oracle's RATIO_TO_REPORT analytic function does it in one step.

    bobwatkins
    Published:  July 17, 2007, 12:11 AM PDT Modified:  July 17, 2007, 12:11 AM PDT Read More See more CXO
  • Copy Oracle’s Automatic Storage Management files with DBMS_FILE_TRANSFER
    Storage

    Copy Oracle’s Automatic Storage Management files with DBMS_FILE_TRANSFER

    Oracle’s Automatic Storage Management (ASM), introduced in Oracle 10g, provides an alternative to raw disk devices for storing Oracle-related files. Like raw disks, ASM volumes (called diskgroups) have no filesystem and cannot be browsed directly at the operating system level. This makes maintenance a challenge because you cannot use the normal commands to copy and ...

    bobwatkins
    Published:  July 10, 2007, 8:31 AM PDT Modified:  July 10, 2007, 8:31 AM PDT Read More See more Storage
  • Multi-dimensional modeling in Oracle SQL
    Data Management

    Multi-dimensional modeling in Oracle SQL

    A spreadsheet is often used as an example of a relational table. Its rows and columns are similar to the rows and columns in a database table. At the intersection of each row and column is a value. The difference is that, in spreadsheets, each cell can also contain a formula that calculates the value ...

    bobwatkins
    Published:  June 26, 2007, 1:15 PM PDT Modified:  June 26, 2007, 1:15 PM PDT Read More See more Data Management
  • Control null data in Oracle using the ORDER BY clause
    Enterprise Software

    Control null data in Oracle using the ORDER BY clause

    NULL data, which is sometimes called “absent” data, can be difficult to work with in relational databases. When a query contains the ORDER BY clause to sort the output, NULL data will sort to the bottom if the sort is in ascending order (ASC) and to the top if the sort is in descending order ...

    bobwatkins
    Published:  June 19, 2007, 8:03 AM PDT Modified:  June 19, 2007, 8:03 AM PDT Read More See more Enterprise Software
  • Explore Oracle 10g’s updated sample schemas
    Data Management

    Explore Oracle 10g’s updated sample schemas

    Each new release of Oracle database brings with it new features to explore. It can be a challenge to create adequate sample tables to play with a given feature. But since Oracle 9i, Oracle has had a robust set of sample schemas you can use to learn new features. The Oracle Documentation also uses these ...

    bobwatkins
    Published:  June 12, 2007, 12:10 AM PDT Modified:  June 12, 2007, 12:10 AM PDT Read More See more Data Management
  • 1
  • 2
  • 3
  • 4
  • 5
  • Next
96 results

TechRepublic Premium

  • TechRepublic Premium

    Hiring kit: Community engagement manager

    PURPOSE Recruiting a community engagement manager with the right combination of experience and communication skills will require a comprehensive screening process. This hiring kit from TechRepublic Premium provides a flexible framework your business can use to find, recruit and ultimately hire the right person for the job. From the hiring kit: DETERMINING FACTORS, DESIRABLE PERSONALITY ...

    Published:  March 28, 2023, 12:00 PM EDT Modified:  March 29, 2023, 10:12 AM EDT Read More See more TechRepublic Premium
  • TechRepublic Premium

    Hiring kit: Chief experience officer

    PURPOSE Successful chief experience officers combine excellent communications skills with an intimate knowledge of customer expectations, company operations and industry standards. This hiring kit from TechRepublic Premium provides a workable framework you can use to find, recruit and ultimately hire the best candidate for CXO of your organization. From the hiring kit: DUTIES AND RESPONSIBILITIES ...

    Published:  March 28, 2023, 12:00 PM EDT Modified:  March 29, 2023, 10:26 AM EDT Read More See more TechRepublic Premium
  • TechRepublic Premium

    Hiring kit: Automation specialist

    PURPOSE Recruiting an automation specialist with the right combination of technical expertise and experience will require a comprehensive screening process. This Hiring Kit from TechRepublic Premium provides a flexible framework your business can use to find, recruit and ultimately hire the right person for the job. From the hiring kit: DETERMINING FACTORS, DESIRABLE PERSONALITY TRAITS ...

    Published:  March 27, 2023, 12:00 PM EDT Modified:  March 28, 2023, 12:48 PM EDT Read More See more TechRepublic Premium
  • TechRepublic Premium

    Hiring kit: Cybersecurity engineer

    PURPOSE Recruiting a cybersecurity engineer with the right combination of technical and industry experience will require a comprehensive screening process. This hiring kit from TechRepublic Premium provides a flexible framework your business can use to find, recruit and ultimately hire the right person for the job. From the hiring kit: DETERMINING FACTORS, DESIRABLE PERSONALITY TRAITS ...

    Published:  March 27, 2023, 12:00 PM EDT Modified:  March 28, 2023, 12:18 PM EDT Read More See more TechRepublic Premium

Services

  • About Us
  • Newsletters
  • RSS Feeds
  • Site Map
  • Site Help & Feedback
  • FAQ
  • Advertise
  • Do Not Sell My Information

Explore

  • Downloads
  • TechRepublic Forums
  • Meet the Team
  • TechRepublic Academy
  • TechRepublic Premium
  • Resource Library
  • Photos
  • Videos
  • TechRepublic
  • TechRepublic on Twitter
  • TechRepublic on Facebook
  • TechRepublic on LinkedIn
  • TechRepublic on Flipboard
© 2023 TechnologyAdvice. All rights reserved.
  • Privacy Policy
  • Terms of Use
  • Property of TechnologyAdvice