View Single Post
Old May 10th, 2008, 11:27 AM   #3
A.K.Al Shamsi
Programmer
 
A.K.Al Shamsi's Avatar
 
Join Date: Mar 2008
Posts: 35
Rep Power: 0 A.K.Al Shamsi is on a distinguished road
Re: Some questions about PL/SQL.. can any one help?

1. Can we have an IF statement inside an UPDATE statement? Can any one provide an example?

of course, you can.... but i don't have examples because i have project in this part

2. How do we declare a decimale variable is the statement?
For example, for numeric values we write

salary NUMBER(5);

what about decimals?

about the decimal places, you should write that

salary Number (5,2); <<< easy, right?

that what i can help you with
A.K.Al Shamsi is offline   Reply With Quote