-----Original Message-----
From: manish [mailto:m_chavan@hotmail.com]
Sent: Friday, August 14, 1998 6:49 PM
To: akaplan@interaccess.com
Subject: dba_stuff
Ari,
i have recently taken the job of a DBA for our project. I am not so
knowlegeble about the dba stuff .
can u please tell me the difference between a row and row id. What are
row pieces ? please site an example to clarify it ?
Regards
amaresh.
email: amr38974@trishul.icil.co.in
-------Reply------------------------
A row specifies one "record" of data. Suppose there is a table:
EMPLOYEES:
-------------------
EMP_ID NUMBER,
LAST_NAME VARCHAR2(40),
FIRST_NAME VARCHAR2(40),
DEPT_NO NUMBER
The table contains many rows ("records"), such as the following:
SELECT EMPID, LAST_NAME, FIRST_NAME, DEPT_NO FROM EMPLOYEES;
EMPID LAST_NAME FIRST_NAME DEPT_NO
--------- ------------------ ------------------- ---------------
123123 KAPLAN ARI 201
123124 KAPLAN TODD 201
123125 SMITH JOHN 203
12126 PARKER FRANCIS 803
In Oracle there is a Pseudo-column called ROWID that is used by the Oracle
engine to define the file, block, and record within the block.
You can see it with:
SELECT ROWID, EMPID, LAST_NAME, FIRST_NAME, DEPT_NO FROM EMPLOYEES;
For more information, read up on the DBMS_ROWID package. As for a row piece, I
believe this is when a row is stored in more than one database block. Each
portion of the row is called a "row piece".
Best of luck,
-Ari Kaplan
www.arikaplan.com
Back to Ari Kaplan's Home Page