Object relation database

[sudip]

Hi! All
I am not clear about object relational database. Can I store a class inside a database? Which means the data and associated methods to works on the data.
Regards

[hrishy]

oracles object terminology is a bit different

classes are called types type defination is stored in the data dictionary that means classes are stored in the data dictonary
you should create a column/table of that object type to actually store data.

heres an example......

create type adddresstype
.........
..............

create table employee
name varchar2(20),
address addresstype.........

hth

[sudip]

What I meant was can we also store methods to works on the class in the database(I classical OO Classes store data and metyhods together)?

[hrishy]

of course yes you can store them


CREATE OR REPLACE TYPE Dummy AS OBJECT (
f1 NUMBER,
f2 NUMBER,
MEMBER PROCEDURE Method1(x IN VARCHAR2),
MEMBER FUNCTION Method2 RETURN DATE
);
/

an object is created with attributes as f1 & f2 and 2 member functions.

-- Create the type body.
CREATE OR REPLACE TYPE BODY Dummy AS
MEMBER PROCEDURE Method1(x IN VARCHAR2) IS
BEGIN
NULL;
END Method1;

MEMBER FUNCTION Method2 RETURN DATE IS
BEGIN
RETURN SYSDATE;
END Method2;
END;
/

COLUMN object_name FORMAT a20

SELECT object_name, object_type, status
FROM user_objects
WHERE object_name = 'DUMMY';


i hope i answer your question this time......





[Edited by hrishy on 04-11-2001 at 04:56 AM]