sincerogue
Last Activity: Aug 21 '07, 12:57 PM
Joined: Aug 20 '07
Location:
-
thanks for all ur all ur helps really apreciates it.... cheers -
hi,
CREATE TABLE BORROWER(
CardNo VARCHAR2(3) NOT NULL,
LName VARCHAR2(35) NOT NULL,
Fname VARCHAR2(30) NOT NULL,
Suburb VARCHAR2(20) NOT NULL,
Postcode VARCHAR2(4) NOT NULL,
PRIMARY KEY (CardNo));
CREATE TABLE BRANCH(
BranchID VARCHAR2(2) NOT NULL,
BranchName VARCHAR2(15) NOT NULL,
PRIMARY KEY (BranchID));...Leave a comment:
-
now it says the view does not exist
thanksLeave a comment:
-
Hi, Gints,
sorry but i dun still get what u mean by the count is not equal sorry for my ignorance....Leave a comment:
-
missing right parenthesis
hi all, im new to oracle and ive created some tables but one of them come out an error at line 8
CREATE TABLE LOAN(
ISBN VARCHAR2(20) NOT NULL,
BranchID NUMBER(2) NOT NULL,
CardNo NUMBER(3) NOT NULL,
DateOut DATE,
DateIn DATE,
PRIMARY KEY (ISBN, BranchID, CardNo, DateOut),
FOREING KEY (ISBN) REFERENCES BOOK (ISBN),
FOREING KEY (CardNo)...
No activity results to display
Leave a comment: