Home » SQL & PL/SQL » SQL & PL/SQL » What is wrong with this?
What is wrong with this? [message #40717] Fri, 01 November 2002 23:18 Go to next message
Skye
Messages: 2
Registered: November 2002
Junior Member
create type review_type as object (
reviewer varchar2(20),
review_text clob );

create or replace type customer_review_type under review_type(
score number,
review_date date) NOT FINAL;

Report message to a moderator

Re: What is wrong with this? [message #40725 is a reply to message #40717] Sun, 03 November 2002 06:28 Go to previous messageGo to next message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
Which version of ORacle are u using ? I am till 8.1.7..but never came across a word UNDER in the Syntax of creating a type..

Report message to a moderator

Re: What is wrong with this? [message #40727 is a reply to message #40717] Sun, 03 November 2002 14:24 Go to previous message
Skye
Messages: 2
Registered: November 2002
Junior Member
Type inheritance. Oracle 9i (9.2.0.1) ...

Doesn't matter. I think that I worked my way around my problems :P

Thanks though,

SKYE

Report message to a moderator

Previous Topic: update using multiple tables
Next Topic: errors in pl/sql function
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Apr 28 20:53:28 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.