a couple q's on procedures / functions

Forgive me, I'm a newbie to oracle, having tried it for the first time just a couple of days ago.

My questions are:

1 - Is it possible to create a view inside a procedure or function? I don't need the view to persist outside the function, just to remain long enough for me to change and query it. I haven't been able to do this so far.

2 - Can someone show me an example of local variables in procedures and functions? I tried sticking the declare statement in several places without luck.

Thanks for your help!

• Dan