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 ^^

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 ^^

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

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

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

Programming Forums > Application Development > Other Programming Languages

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