use this syntax

insert into table_name

select * from tableA

except

select * from tableB

In T SQL

Select ISNULL(FirstName, 'xyz') from tableName where firstname is null..

In PLSQL you can replace the ISNULL with NVL i guess..

Do you need the sample data and the table structure? 🙂 That is what i see in the link posted by you. I will post it in a minute.

Sorry the question was not posted Correctly.

I need help with following requirement.

I want data to be generated in the following way in my stored procedure as given in the attachment.

Now...