How does one select data from an Oracle Database using OO4O?

Use the OraDynaSet object to define recordsets. Look at this simple example:

Set OraSession = CreateObject("OracleInProcServer.XOraSession")
Set OraDatabase = OraSession.DbOpenDatabase("SQL*Net_Connect_String", "scott/tiger", 0&)
Set OraDynaset = OraDatabase.DbCreateDynaset("select empno, ename from emp", 0&)
MsgBox "Employee " & OraDynaset.Fields("empno").value & ", #" & OraDynaset.Fields("ename").value

One can also loop through the result set using code like this:

Do While(OraDynaset.EOF = FALSE)
   Response.write(OraDynaset.Fields("TNAME") & " ")
   osRecordSet.MoveNext
Loop