Programming Forums
User Name Password Register
 

RSS Feed
FORUM INDEX | TODAY'S POSTS | UNANSWERED THREADS | ADVANCED SEARCH

Reply
 
Thread Tools Display Modes
Old May 9th, 2008, 2:06 PM   #1
crazy fish
Newbie
 
Join Date: May 2008
Posts: 3
Rep Power: 0 crazy fish is on a distinguished road
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 is offline   Reply With Quote
Old May 10th, 2008, 8:57 AM   #2
crazy fish
Newbie
 
Join Date: May 2008
Posts: 3
Rep Power: 0 crazy fish is on a distinguished road
Re: Some questions about PL/SQL.. can any one help?

No one!

I didn't expect that !
crazy fish is offline   Reply With Quote
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
Old May 10th, 2008, 11:46 AM   #4
crazy fish
Newbie
 
Join Date: May 2008
Posts: 3
Rep Power: 0 crazy fish is on a distinguished road
Re: Some questions about PL/SQL.. can any one help?

thanks for help dear.. ^^

you helped me a bit..


waiting for other answers..
crazy fish is offline   Reply With Quote
Reply

Bookmarks

Tags
i smell homework

« Previous Thread in Forum | Next Thread in Forum »

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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




DaniWeb IT Discussion Community
All times are GMT -5. The time now is 3:03 PM.

Powered by vBulletin® Version 3.7.0, Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Copyright ©2007 DaniWeb® LLC