Hi, I need to write the programmer for below mentioned query.
I have input view called input_view,based on specfication we write a programmer to genrate the output view called out_view.Once this complete we manaully perform data qc to chcek the data is popualted as per specification or not.
What's your question? You've barely even touched on what the problem is, there's no where near enough information to even guess what you're trying to do.
Second, SQLTeam is a Microsoft SQL Server site. We're not Oracle people. Maybe try an Oracle forum for PL/SQL queries?