SQL> select * from role_type; TYPE -------------------- SURVEYOR CLIENT EH INSPECTOR SQL> spool solid_geology