Problem solve

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?

   Continue Reading

• 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

• 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

• 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

• 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

• 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

• 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