How to export table contents in sql statements

I have two simple questions (I use oracle/mySQL):

1. How can I export the schema of a table into SQL statments, like

CREATE TABLE Animal (
 ID NUMBER(6) PRIMARY KEY,
 name VARCHAR2(20) UNIQUE,
 legs NUMBER(3),
 insertionDate DATE);

CREATE SEQUENCE AnimalIDs

2. How can I export the contents of tables to SQL statemtns, so that I can load those in a different database, like

INSERT INTO Animal VALUES(AnimalIDS.NEXTVAL, 'cow', 4, SYSDATE);
INSERT INTO Animal VALUES(AnimalIDS.NEXTVAL, 'tiger', 4, SYSDATE);
INSERT INTO Animal VALUES(AnimalIDS.NEXTVAL, 'spider', 8, SYSDATE);

thanks,
khamis Received on Sun Oct 08 2000 - 13:31:55 CDT