Here is the SQL I used to create the table (converted from PL/SQL because it's my first time with SQLite):
CREATE TABLE ORG_SITE_RENT_OBJECTS (UNIT_ID NUMBER(18),
SITE_ID NUMBER(18),
SITE_CLASS_ID NUMBER(18),
TAX_GROUP_ID NUMBER(18),
LEASE_GROUP_ID NUMBER(18),
RES_GROUP_ID NUMBER(18),
DEP_GROUP_ID NUMBER(18),
UNIT_NUMBER VARCHAR2(20),
WIDTH NUMBER(10,2),
DEPTH NUMBER(10,2),
HEIGHT NUMBER(10,2),
VOLUME NUMBER(10,2),
ATTRIBUTE01 NUMBER(3),
ATTRIBUTE02 NUMBER(3),
CLIMATE NUMBER(3),
DOOR NUMBER(3),
ACCESS_TYPE NUMBER(3),
DEL_MODEL_ID NUMBER(18),
ADMIN_FEE NUMBER(7,2),
FEATURES NUMBER(3),
SERIAL01 NUMBER(18),
SERIAL02 NUMBER(18),
NOTES VARCHAR2(500),
STATUS NUMBER(3),
WALK_THRU_ORDER NUMBER(7),
LINK_ID NUMBER(18),
VERSION NUMBER(15,1),
CREATED VARCHAR2(200),
CREATED_BY NUMBER(18),
UPDATED VARCHAR2(200),
UPDATED_BY NUMBER(18),
DB_CREATE NUMBER(38),
DB_UPDATE NUMBER(38),
MUX NUMBER(7),
ALARM NUMBER(7))
To retrieve the data, I'm simply using SELECT * FROM ORG_SITE_RENT_OBJECTS.