Quick Question? Is it possible to have more than one if statement in a PLSQL procedure or trigger. I have tried but have been unsucsesful thus far.

So basically what I want to achive is.

Select name into ename from table where varaible= something;

If name= this then

If name= that then

and so on.....


Thanks for any help provided

The syntax is the same as VB,

If (condition) Then
End If

Do you mean like this? :-

IF name = 'this' THEN
...
ELSIF name = 'that' THEN
...
ELSIF name = 'other' THEN
...
ELSE
...
END IF;

Ah I see now same as VB....
I was just continually putting in if statement followed by another if statement (not an elseif)

andrewst quick question is the syntax 'elseif' or 'elsif'.

Thanks for your help guys....

It is ELSIF

===============================
Have you considered to use the CASE statement?

You can have consecutive If Statements without Elsif, If your conditions are independent of each other.

If (condition) Then
..
End If;
If (condition) Then
..
End If;

Also, don't worry too much about "efficiency." Some people will ponder for hours whether the computer will execute CASE vs. IFs "faster" in this situation or that one.

Don't worry about that. Worry instead about clarity. Soon enough someone will be looking at that code again, to debug it or to extend it in some way. Write for that person. Also be conscious about how easy your code will be to maintain. Those are the considerations that really matter... For instance, CASE might be much more tolerant of a typo, vs. a misplaced part of a nested IF...