PL/SQL (MOSC)

MOSC Banner

model clause

edited Aug 18, 2009 5:32AM in PL/SQL (MOSC) 5 commentsAnswered
 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);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center