DESC Students; -- here you got all your info about types of variables and name of columns from the students table Name Null Type ------- ------- ----------- STU_ID NUMBER(2) FIRST_NAME VARCHAR2(8) SELECT * FROM students; -- here you selected everything from students STU_ID FIRST_NAME ------ ---------- 1 Victor 2 Alex