What is the Signature of a PLSQL Program?

PL/SQL Signature

In interviews for PLSQL developers, I usually ask a question of the form:

If you write a procedure to do <specific operation>, what will be the signature of such a procedure?

In response, the developer often veers off into describing the logic/body of the procedure, which is not what was asked.

If you’re among those likely to answer that question similarly, this article will clarify for you the concept of "signature" of a PLSQL stored procedure.

Read more

7 Surefire Tips to Ace your Interview

Oracle Job Interview Tips
Presenting for you the third article in the series on interviews. Earlier in the series: tips to make your resume stand out, and the fallacy of memorizing interview questions.

Your resume has made it to the shortlist and you’ve got that precious interview call. You’re excited and nervous and eager to sail through. How can you convert the interview call into an offer for employment?

To make a success of the interview, you have to start hitting the right notes from before the interview. Here are a few interview tips for you.

Read more

How to Create an Awesome Resume: 8 Golden Rules

Résumé Tips

We’ve seen the pointlessness of memorizing answers to interview questions, earlier in the series on interviews. In this article, we have for you 8 gleaming resume tips to help you get you that valuable interview call.

Your resume is your sales pitch, your chance to make an impact in the brief time the employer scans it.

Organizations are flooded with resumes far in excess of the openings; it is essential for yours to get noticed and interest a prospective employer enough to call you for an interview.

Here are eight “Golden Rules” for creating a resume that’s truly outstanding.

Read more

The Fallacy of Interview Questions

Interview Questions
A series of posts about Oracle interviews starts with this article.

“Interview Questions” is a hot topic on many Oracle forums. Job aspirants want these questions to be listed down, emailed to them, complete with model answers. Some imagine that by learning answers to such questions, they will land a job, though they have not really worked at finding the meaning or rationale behind the answers.

I am utterly bemused.

Read more