Tags » Dba

Compare two tables in Oracle

Use the following SQL to compare two tables in Oracle

-- rows in table1 that are not in table2
(
  select * from  
    minus
  select * from 
) 
union all
-- rows in table2 that are not in table1
( 
  select * from  
    minus
  select * from 
) 
HowTo

#0356 – SQL Server – Search with the LIKE operator and the underscore (_) wildcard character

String searches in most applications are based on the “contains” or “begins-with” paradigms – which are implemented by the use of the LIKE logical operator. The LIKE operator allows for the use of wildcard characters (underscore being one of them), which is the part that most people unknowingly overlook when they have been working with T-SQL for quite some time. 443 more words

#SQLServer