Connections Navigations Hierarchy
Exploring Database Objects
2-4 Oracle Database 2 Day Developer's Guide
2.
Click the
employees
table.
On the right-hand side of the Oracle SQL Developer window, under the Columns
tab, a listing of all columns of this table appears:
EMPLOYEE_ID
,
FIRST_NAME
,
LAST_NAME
,
EMAIL
,
PHONE_NUMBER
,
HIRE_DATE
,
JOB_ID
,
SALARY
,
COMMISSION_PCT
,
MANAGER_ID
, and
DEPARTMENT_ID
. Each column of a table
has an associated data type that defines it as character data, an integer, a
floating-point number, a date, or time information. To see all properties of the
column, move the horizontal scroll bar to the right.
