| can help [message #531186] |
Mon, 14 November 2011 05:45  |
 |
moody
Messages: 3
Registered: November 2011
Location: oman
|
Junior Member |
|
|
hi every one
I'm new here in your web page
I want help from u in pl/sql
how can help me??
|
|
|
|
|
|
|
|
|
|
|
|
| Re: can help [message #531206 is a reply to message #531194] |
Mon, 14 November 2011 06:56  |
|
moody
Messages: 3
Registered: November 2011
Location: oman
|
Junior Member |
|
|
this is my quotations
1-
Write a PL/SQL block to display Fibonacci series from 1 to 25. Create a table and store the generated series into it. The PL/SQL block should also display sum of the numbers in the series.
Fibonacci series : 1,1,2,3,5,8,13,21
2
Create a student table with the following fields:
Student_Id (Primary Key)
Student_Name
Marks
Grade
Insert 5 records into the above created table having student_id values from 1 to 5 and leave the Grade field blank.
Write a PL/SQL block to update the GRADE field based on the following conditions:
For Marks <50, Grade should be 'F'
For Marks from 50 to 60, Grade should be 'C'
For Marks from 61 to 80, Grade should be 'B'
For Marks from 81 to 100, Grade should be 'A'
and thx all
|
|
|
|
| Re: can help [message #531207 is a reply to message #531206] |
Mon, 14 November 2011 07:01 |
 |
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
We don't do homework.
Post what you already tried and where you are stuck and we help you to go further.
(Note that you can find here many solutions to Fibonacci series here.)
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
