ياجماعة انا عملت مكتبة ...الجداول انشأتهم بشكل صحيح علي مااعتقد وطبقوا معي
بس جمل الانسيرت ولا جملة راضية تزبط .......
وهي الجدول والانسيرت
create table Borrower(
Borrower_ID NUMBER(10) ,
Fname VARCHAR2(10) NOT NULL,
Lname VARCHAR2(10) NOT NULL,
Type VARCHAR2(10) NOT NULL,
College VARCHAR2(20) ,
Gender VARCHAR2(10) NOT NULL,
Birth_date Date,
Phone_NUMBER VARCHAR2(20),
Street_Address VARCHAR2(20),
Email VARCHAR2(25),
no_Borrower_times NUMBER(10) default 0,
CONSTRAINT Borrower_id_pk PRIMARY KEY(Borrower_ID),
CONSTRAINT Type_chk check (Type in ('Book','CD','Video')),
CONSTRAINT Gender_chk check(Gender in ('M','F'))
);وهي الانسيرت
Insert into Borrower values('554164','Ali','Ramadan','Book','I T','M','12/6/1986','2852684','Al remal','ahmed@hotmail.com','1'),
Insert into Borrower values('945654','Samy','el helo','CD',' Art ','M','11/9/1983','2054796','Al shohdal','samy_it@hotmail.com',3'),
Insert into Borrower values('412578','Ramez','Saqaa','Video',' I T ' ,'M','5-1-1988','2847412','Al jalaa','ramez_pal@hotmail.com','2'),
Insert into Borrower values('187436','Mohammed','Al Shawwa','Book',' Engenering ,'M','19/1/1987','2833553','M_Eng@hotmail.com','3'),
Insert into Borrower values('412578','Ramez','naser','Video',' I T ' ,'M','3/1/1982','2847412','Al jalaa','2');