Hello: I am new to oracle, and I am trying to maintain some Oralce procedures written here. The problem I am having is that:

1) I created a view on 2 tables. This works fine.
2) when I do a select * from the view where rownum <2 just to see if the view works, the select runs for more than 3 to 4 hours and still does not return any values.

Can some guide me as to what to look for please.

Thanks in advance for any help.

Gopal