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

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

• 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

• Update a specific column in a field or row?

  An Oracle user asks if SQL can be used to update a specific column in a field.Continue Reading

• Using BETWEEN with DATETIMEs in SQL

  Expert Rudy Limeback is asked if SQL can be used to retrieve data between two dates, including the two dates.Continue Reading

• Which normal form is used most?

  SQL expert Rudy Limeback explains what normal form is used in most database projects.Continue Reading

• Querying complex derived tables

  An Oracle user asks SQL expert Rudy Limeback how to run a query when the inner query results come from five different tables.Continue Reading

• SQL query for co-authored books

  SQL expert Rudy Limeback gives advice for writing a query that involves a number of tables.Continue Reading

• Connecting tables in a database

  SQL Expert Rudy Limeback gives advice on finding information on primary and foreign keys to connect tables in a database.Continue Reading

• Oracle 11g: PL/SQL Basics

  As an introduction to PL/SQL basics, this chapter introduces Oracle PL/SQL block structure, variables, assignments, and operators; control structures and more.Continue Reading

• Changing a NULL column to NOT NULL

  An Oracle user asks SQL expert Rudy Limeback how to repopulate a table after modifying the table to NOT NULL.Continue Reading

• SQL string functions

  SQL expert Rudy Limeback explains how to use string functions.Continue Reading

• LEFT OUTER JOIN to a MIN/MAX row

  An Oracle user asks SQL expert Rudy Limeback how to use a LEFT OUTER JOIN with a MIN/MAX condition.Continue Reading

• SQL for hourly totals for the last 48 hours

  SQL expert Rudy Limeback explains to an Oracle user how to user asks how to generate datetimes or use left outer join to get hourly totals for the last 48 hours in SQL.Continue Reading

• Normalizing a crosstab table

  SQL expert Rudy Limeback explains how to use a UNION query to normalize a crosstab table.Continue Reading

• Export dump with files larger than 2 GB

  An Oracle user asks how to create an export dump with files larger than 2 GB.Continue Reading

• Correlated update in Oracle

  SQL expert Rudy Limeback explains how a query is meant to be a correlated update.Continue Reading

• Entity-Attribute-Value constraints

  SQL expert Rudy Limeback explains the entity-attribute-value model.Continue Reading

• A running total

  SQL expert Rudy Limeback explains the importance of a sequencing column.Continue Reading

• SQL to update the header records?

  A SearchOracle.com user asks if SQL can be used to update the header records.Continue Reading

• SQL to round up to nearest thousand

  SQL expert Rudy Limeback explains how to use the CEILING function.Continue Reading

• The last transaction date every month

  SQL expert Rudy Limeback explains how to display the last date of the record of every month.Continue Reading

• Converting Long Raw to Blob

  Expert Greg Williams explains when and how to convert Long Raw to Blob using PL/SQL.Continue Reading

• Running a Monday-Friday report to include weekend data

  SQL expert Rudy Limeback explains how to run a Monday-Friday report to include weekend data.Continue Reading

• Return non-matching rows from both tables

  An Oracle user asks how to return only non-matching rows when joining two tables.Continue Reading

• Select from one table based on condition in another

  SQL expert Rudy Limeback explains how to select from one table based on condition in another using an inner join in Oracle.Continue Reading

• How to transfer data from Oracle to MS SQL Server

  SOA and Integration expert Harish Harbham explains how to transfer data from Oracle to MS SQL Server.Continue Reading

• Using Oracle Streams

  Oracle expert Harish Harbham explains how Oracle Streams can be used for replication.Continue Reading

• How to convert a SQL Server 2005 database to Oracle 10g

  Expert Harish Harbham answers the question, "How do you convert SQL Server 2005 database into 0racle 10g?"Continue Reading

• How to create a mediated schema

  A SearchOracle.com member asks, "I have two different relational schemas with me. Can I get an example as to how to integrate them and create a mediated schema?"Continue Reading

• How to use DISTINCT on just one column

  SQL expert Rudy Limeback explains how to use DISTINCT on just one column.Continue Reading

• Using SQL to get counts of counts

  Expert Rudy Limeback explains how to use SQL to get counts of counts in an Orders table.Continue Reading

• Retrieving row numbers with SQL

  A SearchOracle.com member asks, "How do you retrieve row numbers along with the data?"Continue Reading