CREATE OR REPLACE TYPE bdig_type AS OBJECT ( mynumber NUMBER(1)
                                           , MEMBER FUNCTION bdig2(b IN NUMBER) RETURN NUMBER
                                           );
/

CREATE OR REPLACE TYPE BODY bdig_type AS
  MEMBER FUNCTION bdig2(b IN NUMBER) RETURN NUMBER IS
  BEGIN
    RETURN 4;
  END;
END;
/

CREATE TABLE mytable OF bdig_type
/

DESC mytable

INSERT INTO mytable VALUES(2)
/

SELECT mynumber
FROM   mytable
/

CREATE OR REPLACE TYPE BODY bdig_type AS
  MEMBER FUNCTION bdig2(b IN NUMBER) RETURN NUMBER 
  IS
  BEGIN
    RETURN 4;
  END;
END;
/


SELECT * FROM mytable
/


DROP TABLE mytable
/

DROP TYPE bdig_type FORCE
/