gudii9
asked on
new to stored procedures
I was going through oracle PL SQL reference manual book at following link
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/overview.htm#sthref259
I was trying to find material about stored procedure but when i search on that i could not see anything related to that. I see something like subprograms etc.
I would like to learn stored procedures from scratch. what are the best places to start learn quickly, effectively with code sample.
Any ideas, resources,sample code,links, highly appreciated. thanks in advance.
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/overview.htm#sthref259
I was trying to find material about stored procedure but when i search on that i could not see anything related to that. I see something like subprograms etc.
I would like to learn stored procedures from scratch. what are the best places to start learn quickly, effectively with code sample.
Any ideas, resources,sample code,links, highly appreciated. thanks in advance.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Feuerstein covers pretty much everything there is to know about pl/sql from total beginner to advanced developers.
Do you have questions about anything in the links above?
Do you have questions about anything in the links above?
ASKER
i see stored procedures with multiple begins multiple if if else for loops. I am trying to understand those kind of stored procedures. but could not find similar material.please advise
ASKER
i have lot of cursors also in between same procedure
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
>>>begin
--do some logic
begin
--special code
exception
when NO_DATA_FOUND then
--handle this error
when others then
--trap/handle unexpected error
end;
-- do this logic regardless of the error in the above block
exception
when -- trap exceptions in the main code (not from the internal blocks)
end;
i have not understood this line
>>> -- do this logic regardless of the error in the above block
does that means iner begin loop is bypassed to come here or how this logic executed regardless of the error in the above block.
I am from java programmming background.
--do some logic
begin
--special code
exception
when NO_DATA_FOUND then
--handle this error
when others then
--trap/handle unexpected error
end;
-- do this logic regardless of the error in the above block
exception
when -- trap exceptions in the main code (not from the internal blocks)
end;
i have not understood this line
>>> -- do this logic regardless of the error in the above block
does that means iner begin loop is bypassed to come here or how this logic executed regardless of the error in the above block.
I am from java programmming background.
It means that no matter the outcome of the inner block, if exceptions are properly handled, the main block continues executing.
ASKER
any good video tutorial link on stored procedures, PL/SQL. please advise
same link I posted above above in http:#35354265
Feuerstein's PL/SQL Obsession site has videos on it as well as sample code and articles.
He also has a new PLSQLChannel website, it has a free trial on it but pay for full access.
The Obsession site is free
http://tutorials.plsqlchannel.com/
Feuerstein's PL/SQL Obsession site has videos on it as well as sample code and articles.
He also has a new PLSQLChannel website, it has a free trial on it but pay for full access.
The Obsession site is free
http://tutorials.plsqlchannel.com/
There were a lot of links posted above. Did those not help you?
A quick Google came up with a new one: http://www.plsql-tutorial.com/
It doesn't appear to be a full-blown course but does seem to cover the basics.
A quick Google came up with a new one: http://www.plsql-tutorial.com/
It doesn't appear to be a full-blown course but does seem to cover the basics.
Thanks for the points.
>>best places to start learn quickly, effectively
Just remember, its an old programming adage but works in many places. Typically you never find all three, pick two: Good, Fast, Cheap.
>>best places to start learn quickly, effectively
Just remember, its an old programming adage but works in many places. Typically you never find all three, pick two: Good, Fast, Cheap.
ASKER