السلام عليكم
ارجو منكم مساعدتي ليس لدي خبره وهذه بداياتي مع الـ 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
ولكم مني جزيل الشكر
ربي يوفق من يساعدني ويرزقه خير الدارين

مشروع بسيط -الرجو المساعده بسرعه
تمت كتابته بواسطة
شيهانه
, May 23 2011 12:13 AM
2 رد (ردود) على هذا الموضوع
#2
تاريخ المشاركة 23 May 2011 - 01:22 AM
السلام عليكم
بالتوفيق.
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; --==============================================================
بالتوفيق.
.Oracle E-Business Suite R12 HCM Certified Implementation Specialist
.Oracle Fusion Human Capital Management 11g Human Resources Certified Implementation Specialist
.Oracle Global Human Resources Cloud 2016 Certified Implementation Specialist