for access, just using the command line you type something like this
SELECT t.team_number=384, d.drive_type=hyper;
FROM team t, drive d;
if you don't have multiple tables, and the info is just in the rows it goes like this
SELECT team_number=384, drive_type=hyper;
FROM team;
for entering info, i will get back to you, i need to find my Oracle 9i and SQL notes from last year in OIA. But I will let you know.
ivey
Found my notes, you need to use the INSERT INTO command, and then give the colums to insert info in, and then the corresponding data. After you type the inital command you need to put the name of the table, and then after that the schema. The whole thing looks like this:
INSERT INTO RoboInfo.SchemaIvey (drive_train, wheels) VALUES (hyper, MonsterTruck);
If you have any more questions search for information on Data Manipulation Language, or DML in SQL. Here is also a tutorial that helped me get through my Oracle class last year:
SQL Help and Tutorial