At 03:57 AM 18/02/2005 +0000, you wrote:

>just wanna ask now i want create a field that data type = memo..how
>can i do it?

BLOB SUB_TYPE 1

or create a domain named MEMO:

CREATE DOMAIN MEMO
BLOB SUB_TYPE 1;
COMMIT;

CREATE TABLE NOTEPAD (
ID BIGINT NOT NULL PRIMARY KEY,
NOTE MEMO);

./hb