Sql Query To Compare Two Tables And Find Records With Matches

how to get matching records from two tables in oracle sql.
First  check the employee Records and check target records
for example i created  emp_target table  from emp with some duplicates in emp_target table.
Now Check the count of two table
SQL> SELECT COUNT(*) FROM EMP;

how to unlock scott user in oracle 11g

After install the oracle. So many are trying to login with Username and Password(scott/tiger) but it shows an error like "THE ACCOUNT IS LOCKED" then so many developers are fear of that error. Dont worry  be happy of that error because it teaches you more and more  knowldge to you. And How to Unlock the Scott User Account in Oracle. When the User scott does not exist in oracle 12c/11g then go to

How to Uninstall Oracle 11g And Install Again in Windows7

How to Uninstall Oracle 10g in Windows7
 Uninstall all Oracle Components using the Oracle Universal Installer(OUI). but it is not appear in then follow below steps.
Step-1 
Go to Window Button -> click on it--> search for programs and Features.

Types Of Indexes In Oracle

• Index is an Object in Oracle. 
• It is a Performance Optimization Technique
• It speed up or increase the performance of the Query Execution.
• Index is creating automatically on Primary key and Unique Key.
• No need to create index for primary and unique keys columns.

Determining The Leap Year In Oracle

Finding the Leap Year in Oracle or how to find leap year in oracle SQL

open sql*plus login user name with your respected password after that .

find the sysdate from Dual. It gives the respected First day of the Month. As Shown below when you use Number Function that is Trunc. If you use the To_Char function then it gives the same day of the month when you executed the query.

DDL Commands in Oracle SQL With Examples

• DDL stands for Data Definition Languages .
• DDL Commands Used for create and modify the structure of the Objects ,Views, Sequences,Indexes, Schemas etc.
• Data Definition Languages is one of the Sub Language. 
• the commands of the DDL Language is 

SQL Conditions

The top most used Oracle Conditions are
AND
OR
AND  and OR
LIKE