model clause
Hi,
I copied the following from
http://download.oracle.com/docs/cd/B13789_01/server.101/b10736/sqlmodel.htm
for an example of model clause.
The query does not show the result correctly. Any idea what is wrong?
Thanks,
Sha
CREATE TABLE mortgage_facts (
customer VARCHAR2(20),
fact VARCHAR2(20),
amount NUMBER(10,2));
INSERT INTO mortgage_facts VALUES ('Smith', 'Loan', 100000);
INSERT INTO mortgage_facts VALUES ('Smith', 'Annual_Interest', 12);
INSERT INTO mortgage_facts VALUES ('Smith', 'Payments', 360);
INSERT INTO mortgage_facts VALUES ('Smith', 'Payment', 0);
INSERT INTO mortgage_facts VALUES ('Jones', 'Loan', 200000);
INSERT INTO mortgage_facts VALUES ('Jones', 'Annual_Interest', 12);
INSERT INTO mortgage_facts VALUES ('Jones', 'Payments', 180);
INSERT INTO mortgage_facts VALUES ('Jones', 'Payment', 0);
http://download.oracle.com/docs/cd/B13789_01/server.101/b10736/sqlmodel.htm
for an example of model clause.
The query does not show the result correctly. Any idea what is wrong?
Thanks,
Sha
CREATE TABLE mortgage_facts (
customer VARCHAR2(20),
fact VARCHAR2(20),
amount NUMBER(10,2));
INSERT INTO mortgage_facts VALUES ('Smith', 'Loan', 100000);
INSERT INTO mortgage_facts VALUES ('Smith', 'Annual_Interest', 12);
INSERT INTO mortgage_facts VALUES ('Smith', 'Payments', 360);
INSERT INTO mortgage_facts VALUES ('Smith', 'Payment', 0);
INSERT INTO mortgage_facts VALUES ('Jones', 'Loan', 200000);
INSERT INTO mortgage_facts VALUES ('Jones', 'Annual_Interest', 12);
INSERT INTO mortgage_facts VALUES ('Jones', 'Payments', 180);
INSERT INTO mortgage_facts VALUES ('Jones', 'Payment', 0);
0