إنتقال للمحتوى

  • تسجيل الدخول عبر الفيس بوك تسجيل الدخول عبر تويتر Log In with LinkedIn Log In with Google      تسجيل دخول    
  • إنشاء حساب

صورة
- - - - -

أرجو المساعده في Pl/sql

PL/SQL

لا توجد ردود على هذا الموضوع

#1 أحساس غالي

أحساس غالي

    عضو

  • الأعضــاء
  • 18 مشاركة

تاريخ المشاركة 30 October 2011 - 12:46 PM

Table Name: SALES
Item_No Item_Name Quantity Unit_Price Amount
101 HP Laptop 13 210
102 DELL Laptop 12 250
103 Fujitsu Laptop 9 195
104 Sony Laptop 9 275
105 Acer Laptop 8 165

a. Write a PL/SQL block to compute the Amount column values and
update the table.

b. Display the item details of the item
1.2 Create a table with two fields:
Given_No Number Primary Key and
Description Char(4)


السؤال الثاني

a)
Write a PL-SQL block to insert numbers from 51 to 75 and the number
description (odd or even) in the table.
B)
The PL/SQL block should also display the odd numbers count and even
numbers count.
Table: ODD_EVEN
Sample Data
Given_No Description
51 ODD
52 EVEN


السؤال الثالث


1.3 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’
___________________________________________

السؤال الرابع
1.4 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





موضوعات أخرى ذات صلة بـ PL/SQL