Ask the Experts

Ask the Experts

LEFT OUTER JOIN with ON condition or WHERE condition?

I would like your explanation of the difference between a LEFT OUTER JOIN ON condition and a WHERE condition. Continue Reading
Converting from CHAR to DATE datatype

As a time value, I used the CHAR datatype and need to convert to a DATE value while manipulating/computing. How do I use the DATE datatype instead? Continue Reading
Installing 32-bit and 64-bit Oracle on same machine

I have an application that does not support 64-bit Oracle. It needs to run on 32-bit Oracle. Can I install two Oracle engines (32-bit and 64-bit) on the same machine? If so, how can it be done? Continue Reading
Multiple instances on a single database

Is it possible for Oracle to have parallel servers (single database, multiple instances)? Is it impossible to have the inverse (that is, multiple databases, single instance)? Continue Reading
VARCHAR2 vs. NUMBER

What is the correct circumstance to store a numeric string as VARCHAR2 vs. NUMBER? The response I have received before is to store all numeric strings as VARCHAR2 unless the intention is to manipulate the field mathematically; but no reason has ... Continue Reading

Alternative to LEFT OUTER JOIN?

Continue Reading
How do I copy an Oracle DB from one server to another?

Continue Reading
Assertions

Continue Reading
Purpose of roll forward and roll backward

What are rolling forward and rolling backward in backup and recovery? Continue Reading
ORA-12801 and ORA-01652 errors on running query

Continue Reading
PL/SQL to display all tables

Continue Reading

1
2

Data Management

How to approach data mesh implementation
Data mesh takes a decentralized approach to data management, setting it apart from data lakes and warehouses. Organizations can ...
Fivetran's new funding a hedge against economic uncertainty
The data integration vendor added $125 million in financing to not only fuel R&D but also ensure that operations remain smooth if...
Snowflake acquisition of Neeva to add generative AI
The pending purchase will let the data cloud vendor infuse generative AI throughout its data management suite and potentially ...

Business Analytics

Alteryx unveils generative AI engine, Analytics Cloud update
The longtime data management vendor developed a new AI engine that incorporates generative AI. It also unveiled new capabilities ...
Microsoft unveils AI boost for Power BI, new Fabric for data
The tech giant introduced a tool that will infuse its primary analytics platform with generative AI, as well as a new SaaS suite ...
ThoughtSpot unveils new tool that integrates OpenAI's LLM
The analytics vendor unveiled a variety of new capabilities, including Sage, which integrates OpenAI's generative AI technology ...

SearchSAP

ERP roundup: SAP partners unveil new products at Sapphire
At SAP Sapphire 2023, SAP partners and ISVs displayed products and services aimed at automating processes, improving security and...
SAP's new sustainability ledger tracks carbon emissions
If companies want to improve sustainability efforts, they will need to treat environmental reporting like financial accounting. ...
SAP Sapphire 2023 news, trends and analysis
The conference bolsters SAP's case to customers that the future lies in the cloud by showcasing cloud products, services and ...

TheServerSide.com

5 Scrum servant leader examples
The term 'servant leader' was removed from the 2020 Scrum Guide, but that doesn't mean it's not important. Here are five examples...
How to address Python performance problems
Python is a great language for nonprogrammers to do mathematical and scientific tasks, even if such optimization impacts ...
Scrum vs. Waterfall: What's the difference?
Most organizations choose between Waterfall and Agile methodologies, which often means comparing Scrum vs. Waterfall. Here are ...

Data Center

Differences between Green Globes vs. LEED for data centers
Consider Green Globes and LEED certifications when building green data centers. Learn the differences in how the assessments are ...
6 data center migration best practices
Data center migrations can be a complex process. Use best practices when migrating a data center to ensure maximum uptime, avoid ...
Navigate Energy Star data center standard and certification
Organizations can use the Energy Star data center standard and certified assets to be more energy efficient. Consider Energy Star...

Content Management

What does a knowledge management leader do?
Knowledge management teams often include IT professionals and content writers. But at the head, they need a central leader to ...
5 integrations for your CMS
To get the most out of a content management system, organizations can integrate theirs with other crucial tools, like marketing ...
8 software tools for knowledge sharing and collaboration
Knowledge sharing and collaboration are staples of the modern workplace, thanks to remote and hybrid work. These eight tools can ...

HRSoftware

Generative AI could make employee surveys truly anonymous
Qualtrics is exploring generative AI to maintain anonymity in employee surveys by rewriting responses, a move that could enhance ...
UKG integrates generative AI into HR tech with Google Vertex
UKG is using Google's Vertex AI platform to test and explore generative AI and sees it delivering conversational capabilities ...
Federal regulators urge HR to perform AI bias audits
The EEOC's latest warning about AI bias in hiring might prompt employers to conduct AI audits, either done internally or with ...

Close