List Contents of Populated Tables
/* LIST CONTENTS OF POPULATED TABLES.
NOTE: HERE WE ONLY LIST CONTENTS OF THREE TABLES.
PLEASE REFER TO OUR SQL SOURCE CODE OF DDL TO SEE
THE INSERT LINES AND SELECT MORE. */
/* ************************************************************************* */
SQL> SELECT * FROM GLEVEL;
GL NAME
-- --------------------
1 Any grade
2 k-3
3 4-6
4 7-9
5 10-12
6 undergrad
7 grad
8 teacher/prof
9 nonaligned
10 other
10 rows selected.
/* ************************************************************************* */
SQL> SELECT * FROM POSITION;
PO TITLE
-- -------------------------
1 Undergraduate
2 Grad Student
3 Medical Student
4 Post-doc/Fellow
5 MD
6 Faculty
7 Staff
8 Others
8 rows selected.
/* ************************************************************************* */
SQL> SELECT * FROM HOLD;
HOLD_N DATE_STA DATE_END SCI_
------ -------- -------- ----
1 12/01/00 12/31/00 14
2 01/01/01 01/20/01 46
3 01/07/01 01/23/01 50
3 rows selected.