cursor using join in 8i

[abhu50]

i m learning pl/sql of oracle8i,i have encountered with doubt that can we use join in explicit cursor if yes then tell me by example.

however i need some ebook of pl/sql for oracle8i in which cursor should be deeply explained with example

i request to all of you i m facing continue prblm in pl/sql of 8i so help me just give me link to dwn ld the bool for pl/sql

i will be thankful to you,

regards
abhinav pandey

[debasisdas]

Hi
ABHINAB
Welcome to TSDN.

You have reached the right place for knowledge shairing.

Here you will find a vast resource of related topics and code.

Feel free to post more doubts/questions in the forum.

But before that give a try from your side and if possible try to post what/how you have approached to solve the problem.
It will help Experts in the forum in solving/underestanding your problem in a better way.

[abhu50]

thanks devashish
i m learning pl/sql from local institute of my city korba but here faculty is very poor in knowledge so i m learning by myself so irequest you to give me book for oracle8i in which cursor and function,trigge r wld be explained deeply by the example,plzzzzz zzzz help me for pl/sql for oracle8i(with example)
regards
abhinav pandey
thanks agaun for ur reply

[debasisdas]

U just go to Article-->Oracle from the top blue menubar

there u cound find a lot or resources regarding PL/SQL.

If still u have any problem I am always here to help you out.

Hope all those marerials will help u a lot.

[abhu50]

thanks devashish alot
i really apperciate ur effort u r great but since i m new to pl/sql so i need some book plzzzzzzz if u will not angry then suggest me some useful book for oalce8ipl/sql in which everything abt pl/sql shoulbe explained deeply with example
thanks again
regards
abhinav pandey

[debasisdas]

Ok, I will try to send some PDF files later on to your personal mail.

[abhu50]

thanks devashish
i will be highly obliged to you,actually i have so much doubt regarding cursor,function and procedure and trigger
that's why i need pdf book in which it is explained deeply with example
thanks

[bhushanbagul]

Hi Abhinav

Please visit below url hope u'll get the better notes on how to use explicit cursors.

http://www.unix.org.ua/orelly/oracle/prog2/ch06_02.htm