Re: I have an interview - PL/SQL...

Karsten Farrell <kfarrell_at_belgariad.com> wrote in message news:<MPG.19621ecbfc5eead99897d1_at_news.la.sbcglobal.net>...
> "Cynic" <dfee> said...
> > I'm going to an interview for a PL/SQL developer position. It's been a
> > little while since I've worked with PL/SQL, so I'm wondering if anyone knows
> > of a good online source for either a PL/SQL cheat-sheet type thing, or a
> > good refresher tutorial.
> > Thanks.
> >
> > P.S. Even better, if someone has one of those "common interview questions"
> > for PL/SQL positions, that would be great.
> >
>
> If you have a bookstore near you, head over to the Oracle book section
> and stand there, leafing thru one or more PL/SQL books. Since you're a
> former PL/SQL developer, you won't have to read thoroughly ... just skim
> a bit. I find that faster than reading text on a glaring white monitor.

i have had alot of pl/sql interviews and i have never had one that was the least bit challenging. every asks the same really easy and basic questions. The hardest part of these interviews is that you may be expecting a tough question and its really very easy.

another hard part is that the person interviewing you may not be very good and you may answer in one way based on a subtlety that they dont get.

for example, I was asked how do you RETURN two values from a procedure. People asking me had well over 10 years experience. I thought it was a trick question since you cannot RETURN any values from a procedure.

they meant out values which is not a return. But they didnt know that.

the gotchas for pl/sql are bulk binds, dynamic sql(mention bind variables), type definition(mainly ref cursors and pl/tables), and that is about.

you inevitably will be asked how to anchor a variable to a table(tablename.colname%type) different types of cursor attributes. %rowcount,%notfound, etc...

how to createa cursor. how to handle exception. rarely get asked about pragma exception_init.

thats really about it. even the 'hard' questions are really easy. Received on Wed Jun 25 2003 - 06:15:35 CDT