AboutPeter Choi Expertise I am a senior Oracle DBA, PeopleSoft Administrator and Project Manager with
10+ years experience. I have been working with PeopleSoft (HRMS 5, 7, 7.x and
8.9), Oracle RDBMS (7.3 - 11gR1) on various Unix and Windows platforms, and some Oracle Application Server (9i/10gR2). I also have experience with the configuration and administration of BEA`s Tuxedo and WebLogic for PeopleSoft 8.x.
Question What is table? what is field, record,column and row and their difference?
Answer Hi there,
In databases, a table is composed of attributes, typically called columns. Theses columns (or fields) hold information that is relevant to the table. An example of a table and columns:
PERSON (table)
------
PERSON_ID NUMBER(10)
LAST_NAME VARCHAR(50) <-- Column identifier and type
FIRST_NAME VARCHAR(50)
BIRTH_DATE DATE
In this example, the person table (above) contains 4 columns (or fields), namely PERSON_ID, LAST_NAME, FIRST_NAME and BIRTH_DATE. Each column contains some attribute type. PERSON_ID is defined as a number type with a length of 10 (or up to 10 digits). The LAST_NAME column is defined as a variable character of length 50 (or up to 50 characters).
A Row (or tuple in database relational language) is made up of 1 entry in the PERSON table. So 1 row in this table could look like this:
PERSION_ID LAST_NAME FIRST_NAME BIRTH_DATE
---------- ------------- ------------- -----------
0000192873 Smith John 04-DEC-1994
