Home » Other » Training & Certification » Pl/sql (9i ,win 2003)
Pl/sql [message #340214] Tue, 12 August 2008 00:28 Go to next message
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
Member
Hi all,
I am not much proficient in pl/sql but my company has asked me to read some books and get trained in pl/sql. So i went through a book by an author named Scott Urman.
They say that i would be required to do some function or procedure troubleshooting. I am not proficient in troubleshooting but i was able to grab the pl/sql programming concepts. I just wanted to know if there are any books or documents that might guide me in Function or procedure troubleshooting?? Pls let me know. Also it will be helpful if anyone can brief me about what function trouble shooting is all about?



Thanks,
Arun.
Re: Pl/sql [message #340223 is a reply to message #340214] Tue, 12 August 2008 00:55 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
The best way to learn this and any programming language or technique is by having a tutor.
Is there anyone in your company that is a senior PL/SQL programmer or DBA who you can ask to tutor you? If not, see if there is any senior programmer in another language; after all, programming techniques really don't differ that much, especially the ideas behind debugging and such.
I think it is nearly impossible to learn this from a book. Only experience can help you, and, to become really good at it, you have to have a certain 'je ne sais quoi'.
Re: Pl/sql [message #340236 is a reply to message #340214] Tue, 12 August 2008 01:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Start with
PL/SQL User's Guide and Reference
Application Developer's Guide - Fundamentals
to get the basics but programming and programming and programming is the way to get experience (if you try to always find new ways and not stay to what you first learned).

Regards
Michel
Re: Pl/sql [message #340237 is a reply to message #340223] Tue, 12 August 2008 01:14 Go to previous messageGo to next message
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
Member
Hi Frank! Thanks for the reply. Well i am the only Oracle DBA here. But there is one Senior Data Analyst in our company for SQL Server database. So, will he be able to assist me?

P.S: (Are there any stereotyped problems that needs trouble shooting in pl/sql, which occur quite often?? If so is it possible for you to list them?)



Thank you,
Arun.
Re: Pl/sql [message #340239 is a reply to message #340236] Tue, 12 August 2008 01:17 Go to previous messageGo to next message
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
Member
@ Michel-- Thanks for the reply [Smile]
Re: Pl/sql [message #340246 is a reply to message #340237] Tue, 12 August 2008 01:38 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
If there is noone else available, go with the SQLServer guy to learn techniques on how to tackle a problem.
Depending on how good this guy is (whether or not he knows the consequences of the differences between SQLServer and Oracle), you should be very careful to following his advise on how to rewrite stuff though..

The problems that occur most depend greatly on the level of the developer(s) that initially built the system.
Speaking of which.. what happened to him/them? Are they no longer around to help you?
Re: Pl/sql [message #340259 is a reply to message #340246] Tue, 12 August 2008 02:10 Go to previous messageGo to next message
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
Member
Hi Frank,
Actually there are no developers right here, all are in the US at the client's location,they have forwarded the DBA activities alone to our company. My client used to interact with me thro online chat to guide me with his requirements.
Re: Pl/sql [message #340274 is a reply to message #340259] Tue, 12 August 2008 03:17 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
But then you should not be the one responsible for debugging PL/SQL code..
Not that you should not learn, after all, it is a fun thing to do.
Re: Pl/sql [message #340283 is a reply to message #340274] Tue, 12 August 2008 03:33 Go to previous messageGo to next message
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
Member
Ok Frank, i will do as u said.. well ....hope u'll help me out during crisis situations...

Thanks,
Arun.
Re: Pl/sql [message #340292 is a reply to message #340283] Tue, 12 August 2008 04:16 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Sure, we will be happy to help you.
Make sure you read and follow the forum guidelines. These tell you the best way to post stuff, in order to help us help you.
Also remember to first try to do it yourself and let us know you did, so we don't think you're lazy Smile
Re: Pl/sql [message #340346 is a reply to message #340292] Tue, 12 August 2008 07:23 Go to previous message
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
Member
ok thanx Frank..
Previous Topic: Informatica certification question.
Next Topic: Oracle 9i, Windows
Goto Forum:
  


Current Time: Thu Mar 28 15:29:12 CDT 2024