Programming Forums - Some questions about PL/SQL.. can any one help?

Programming Forums (http://www.programmingforums.org/forumindex.php)

- Other Programming Languages (http://www.programmingforums.org/forum38.html)

- - Some questions about PL/SQL.. can any one help? (http://www.programmingforums.org/showthread.php?t=15808)

crazy fish

May 9th, 2008 2:06 PM

Some questions about PL/SQL.. can any one help?

Goog evening programmers :)

^_^

I'm doing a PL/SQL project.. it is really interesting but there are some parts confusing me.. which are:

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

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

salary NUMBER(5);

what about decimals?

3. How do we right an exeption inside the block? I need an example..

4. When do we need a global variable?

Thanks for those who are helping ^^

crazy fish

May 10th, 2008 8:57 AM

Re: Some questions about PL/SQL.. can any one help?

No one!

I didn't expect that !

A.K.Al Shamsi

May 10th, 2008 11:27 AM

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

crazy fish

May 10th, 2008 11:46 AM

Re: Some questions about PL/SQL.. can any one help?

thanks for help dear.. ^^

you helped me a bit..

waiting for other answers..

All times are GMT -5. The time now is 10:59 AM.