Create Table vikrant_value_hold (Name Varchar2(100), No Number); Create Table vikrant_table (Name Varchar2(100), Id Number); Insert Into vikrant_value_hold Values('BHUSHAN',1); Insert Into vikrant_value_hold Values('NEHA ',1); Insert Into vikrant_value_hold Values('AKASH',2); Insert Into vikrant_value_hold Values('FELCY',2); Insert Into vikrant_value_hold Values('POOJA',2); Insert Into vikrant_value_hold Values('VIKRANT',2); Insert Into vikrant_value_hold Values('AMOL',3); Insert Into vikrant_value_hold Values('KEDAR',3); Insert Into vikrant_value_hold Values('RAJA ',3); Insert Into vikrant_value_hold Values('ANIL',4); Insert Into vikrant_value_hold Values('MANADAR',4); Insert Into vikrant_value_hold Values('SANDIP',4); Insert Into vikrant_value_hold Values('SWAPNIL',5); insert into Vikrant_table Values('AKASH',12); insert into Vikrant_table Values('AKASH',23); insert into Vikrant_table Values('AKASH',243); insert into Vikrant_table Values('AKASH',4656); insert into Vikrant_table Values('VIKRANT',121); insert into Vikrant_table Values('VIKRANT',44141); insert into Vikrant_table Values('VIKRANT',12); insert into Vikrant_table Values('VIKRANT',13213); insert into Vikrant_table Values('BHUSHAN',13121); insert into Vikrant_table Values('BHUSHAN',12121); insert into Vikrant_table Values('BHUSHAN',21212); insert into Vikrant_table Values('BHUSHAN',1212); insert into Vikrant_table Values('BHUSHAN',12); insert into Vikrant_table Values('MANADAR',23); insert into Vikrant_table Values('MANADAR',243); insert into Vikrant_table Values('MANADAR',4656); insert into Vikrant_table Values('FELCY',121); insert into Vikrant_table Values('FELCY',44141); insert into Vikrant_table Values('FELCY',12); insert into Vikrant_table Values('FELCY',13213); insert into Vikrant_table Values('SANDIP',13121); insert into Vikrant_table Values('SANDIP',12121); insert into Vikrant_table Values('SANDIP',21212); insert into Vikrant_table Values('POOJA',1212); insert into Vikrant_table Values('POOJA',12); insert into Vikrant_table Values('POOJA',23); insert into Vikrant_table Values('POOJA',243); insert into Vikrant_table Values('NEHA ',4656); insert into Vikrant_table Values('NEHA ',121); insert into Vikrant_table Values('NEHA ',44141); insert into Vikrant_table Values('RAJA ',12); insert into Vikrant_table Values('RAJA ',13213); insert into Vikrant_table Values('RAJA ',13121); insert into Vikrant_table Values('RAJA ',12121); insert into Vikrant_table Values('ANIL',21212); insert into Vikrant_table Values('ANIL',1212); insert into Vikrant_table Values('ANIL',12); insert into Vikrant_table Values('ANIL',23); insert into Vikrant_table Values('ANIL',243); insert into Vikrant_table Values('ANIL',4656); insert into Vikrant_table Values('AMOL',121); insert into Vikrant_table Values('AMOL',44141); insert into Vikrant_table Values('AMOL',12); insert into Vikrant_table Values('AMOL',13213); insert into Vikrant_table Values('KEDAR',13121); insert into Vikrant_table Values('KEDAR',12121); insert into Vikrant_table Values('KEDAR',21212); insert into Vikrant_table Values('KEDAR',1212); insert into Vikrant_table Values('SWAPNIL',13121); insert into Vikrant_table Values('SWAPNIL',12121); Commit;