oracle apex表隐藏,在oracle apex中显示表数据

我试图包括oracle express应用程序为我的oracle pl sql app创建GUI(图形用户界面)

my sql pl script was a oriental objects data type

我没能使用这个脚本创建一个成功的应用程序oracle apex

任何人都可以通过此脚本使用对象浏览器或应用程序页面向我们展示在oracle apex中显示所有表数据的正确方法吗？

谢谢

我的剧本： create object types and their table

CREATE TYPE client_type AS OBJECT

(num NUMBER(5), nom VARCHAR2(30), adresse VARCHAR2(30))

/

--Création de compte

CREATE TYPE compte_type AS OBJECT

(nCompte VARCHAR2(5), solde NUMBER(10,2), dateOuv DATE, ref_Client REF client_type)

NOT FINAL NOT INSTANTIABLE

/

CREATE TYPE cptCourant_type UNDER compte_type

(nbOpCB NUMBER(5))

/

CREATE TABLE Client OF client_type

(CONSTRAINT pk_client PRIMARY KEY (num));

CREATE TABLE CptCourant OF cptCourant_type

(CONSTRAINT pk_cptCourant PRIMARY KEY (nCompte),

CONSTRAINT nn_Courant_ref_Client CHECK (ref_Client IS NOT NULL),

CONSTRAINT refer_Courant_Client ref_Client REFERENCES Client)

;

insert data script

INSERT INTO Client VALUES

(client_type(1, 'Albaric', 'Pont Vieux - Vielle Toulouse'

));

INSERT INTO Client VALUES

(client_type(3, 'Miranda', 'Antipolis - Nice'));

INSERT INTO Client VALUES

(client_type(4, 'Payrissat', 'Salas - Ramonville St Agne'

));

INSERT INTO Client VALUES

(client_type(5, 'Vielle', 'INRA - Auzeville Tolosane',

));

--Insertion des comptes

INSERT INTO CptCourant VALUES

(cptCourant_type('CC1', 4030, '01-02-2001',

(SELECT REF(cli) FROM Client cli WHERE cli.num = 1), 509)

);

INSERT INTO CptCourant VALUES

(cptCourant_type('CC2', 3000, '15-02-2002',

(SELECT REF(cli) FROM Client cli WHERE cli.num = 1), 0)

);

INSERT INTO CptCourant VALUES

(cptCourant_type('CC3', 460, '13-05-2000',

(SELECT REF(cli) FROM Client cli WHERE cli.num = 4), 678

)

);