Problem solve
Get help with specific problems with your technologies, process and projects.
Oracle development languages
How to check SQL query construction with the Mimer Validator
Read about the Mimer Validator, a tool used to verify your SQL code, in this tip from SQL expert Rudy Limeback. Continue Reading
What's the difference between an SQL inner join and equijoin?
Using LEFT OUTER JOIN query to get zero row counts in SQL
An SQL expert explains how using a LEFT OUTER JOIN query can retrieve zero row counts in SQL. Continue Reading
-
How to return multiple values for THEN clause in an SQL CASE expression
Read this tip from SQL expert Rudy Limeback on how to return multiple values in THEN clause of SQL CASE expression. Continue Reading
Can I concatenate row values in SQL?
An Oracle user asks SQL expert Rudy Limeback if there is an SQL query that will concatenate two different tables with different numbers of rows. Continue Reading
Should I try to avoid a LEFT OUTER JOIN in SQL?
An Oracle user asks expert Rudy Limeback whether avoiding a LEFT OUTER JOIN in SQL is a good SQL strategy.Continue Reading
How to create an SQL CHECK constraint for two letters
SQL expert Rudy Limeback explains how to create a SQL CHECK constraint for two letters when trying to write a query to retrieve data from two tables.Continue Reading
How to write an SQL query for two foreign keys to the same table
A SQL user asks how to write a query for two foreign keys to the same table. Read SQL expert Rudy Limeback's answer here.Continue Reading
Tips for derived tables in SQL and using FULL OUTER JOINs
SQL expert Rudy Limeback gives his strategy for using FULL OUTER JOINs on derived tables in SQL. Read the tip here.Continue Reading
How to return a zero in SQL instead of no row back for a select count
Want your row to return a zero instead of getting no row backs for some combinations when doing a select count in SQL? Find out how here.Continue Reading
-
How to write an SQL query using GROUP BY for row analysis
SQL expert Rudy Limeback explains how to write a SQL query using GROUP BY to retrieve the students who have all three rows in a skills table.Continue Reading
Using nested SQL string functions to find ERP customer values in a table
SQL expert Rudy Limeback explains the value of nested SQL string functions when extracting the ERP customer value for all rows in a table.Continue Reading
CASE expressions in the ORDER BY clause
SQL expert Rudy Limeback discusses using a CASE expression in the ORDER BY clause.Continue Reading
SQL to select rows 1000 through 3000 in a table
An Oracle user asks if they can use SQL to select rows 1000 through 3000 in a table.Continue Reading
The SQL REPLACE function
SQL Expert Rudy Limeback answers an Oracle user's question about the REPLACE function.Continue Reading