Programming Forums > Application Development > Other Programming Languages

crazy fish · May 9th, 2008, 2:06 PM

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

No one!

I didn't expect that !

A.K.Al Shamsi · May 10th, 2008, 11:27 AM

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

thanks for help dear.. ^^

you helped me a bit..

waiting for other answers..

May 9th, 2008, 2:06 PM	#1
crazy fish Newbie Join Date: May 2008 Posts: 3 Rep Power: 0	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 ^^

May 10th, 2008, 8:57 AM	#2
crazy fish Newbie Join Date: May 2008 Posts: 3 Rep Power: 0	Re: Some questions about PL/SQL.. can any one help? No one! I didn't expect that !

May 10th, 2008, 11:27 AM	#3
A.K.Al Shamsi Programmer Join Date: Mar 2008 Posts: 35 Rep Power: 0	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

May 10th, 2008, 11:46 AM	#4
crazy fish Newbie Join Date: May 2008 Posts: 3 Rep Power: 0	Re: Some questions about PL/SQL.. can any one help? thanks for help dear.. ^^ you helped me a bit.. waiting for other answers..

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pl/sql	A.K.Al Shamsi	Other Programming Languages	3	May 12th, 2008 1:22 AM
VoIP Questions	crawforddavid2006	Coder's Corner Lounge	8	Jan 16th, 2008 1:53 PM
hardware questions	programmingnoob	Coder's Corner Lounge	28	Aug 8th, 2006 8:04 PM
Novice questions.	snafu	Python	3	Oct 5th, 2005 5:03 PM
ucf cs student has some questions	raspberryh	Coder's Corner Lounge	33	Sep 12th, 2005 2:49 PM

Programming Forums > Application Development > Other Programming Languages

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