مشروع بسيط -الرجو المساعده بسرعه

[شيهانه]

السلام عليكم

ارجو منكم مساعدتي ليس لدي خبره وهذه بداياتي مع الـ sql

صراحه عندي مشروع ومطلوب مني اسلمه بعد بكرا وانا والله مو عارفه اسوي ولا شي

مطلوب مني عمل 20 row عن اي شي وعمل هذه الكويري عليها:
create
insert
create as
select
pagesize
linesize
clean scren
update
delete(one row,1-2-3n row
drops
asending desing
prime key
max,min,count,sum,avg
null,not null
groupedby


ولكم مني جزيل الشكر
ربي يوفق من يساعدني ويرزقه خير الدارين

[Ahmad.Hasan]

السلام عليكم

Create Table Employees (Emp_Id          Number(10) Primary Key,
                       Emp_Name        Varchar2(50),
                       Emp_Sal         Number,
                       Emp_Bod         Date,
                       Emp_Nationality Number);
--==============================================================

Insert Into Employees Values (1, 'Ahmad', 5000, To_Date('15/08/1985', 'dd-mm-rrrr'), 1);                                              

Insert Into Employees Values (2, 'Ali', 6000, To_Date('15/06/1985', 'dd-mm-rrrr'), 2);

Insert Into Employees Values (3, 'Hasan', 4000, To_Date('15/10/1985', 'dd-mm-rrrr'), 1);

Insert Into Employees Values (4, 'Mohammad', 5000, To_Date('15/08/1980', 'dd-mm-rrrr'), 1); 

Insert Into Employees Values (5, 'Ibrahim', 5500, To_Date('10/08/1984', 'dd-mm-rrrr'), 1);

Insert Into Employees Values (6, 'Fadi', 6000, To_Date('01/01/1983', 'dd-mm-rrrr'), 3);

Insert Into Employees Values (7, 'Rami', 8000, To_Date('13/01/1982', 'dd-mm-rrrr'), 1);

Insert Into Employees Values (8, 'Abdallah', 6500, To_Date('03/09/1981', 'dd-mm-rrrr'), 2);

Insert Into Employees Values (9, 'Hani', 7500, To_Date('07/06/1980', 'dd-mm-rrrr'), 1);

--==============================================================

Create Table Employees1 As Select * From Employees;

--==============================================================

Select * From Employees;

--==============================================================

Sql> Set Pagesize 5;

--==============================================================

Sql> Set Linesize 300;

--==============================================================

Update Employees
  Set Emp_Sal = 10000
Where Emp_Id  = 1;
 
--==============================================================

Delete Employees
Where Emp_Id = 2;

--==============================================================

Drop Table Employees1;

--==============================================================

Select Emp_Id,
      Emp_Name
 From Employees
Order By Emp_Id Desc

--==============================================================

Select Max(Emp_Sal)
 From Employees;
 
--==============================================================

Select *
 From Employees
Where Emp_Name Is Not Null;  

--==============================================================

بالتوفيق.

[شيهانه]

عن جد مره حلو
بس ابغا ازيد الrow اللي فيه insert
3مايكفو كيف ازيد؟

والحين هو خالاص جاهز اعطيه الاستاذه ولا باقي له شي؟

الله يسعدك دنيا واخره والله ماتعرف قد ايش كنت متضايقه منه

اللهم اعطيه كل مايتمناه واكثر