[Home] [Help]
[Dependency Information]
Object Name: | PER_EMPDIR_IMAGES |
---|---|
Object Type: | TABLE |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
Images for a designated row in a designated table.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PER_EMPDIR_IMAGES_PK | NORMAL | UNIQUE |
![]() |
![]() |
PER_EMPDIR_IMAGES_U1 | NORMAL | UNIQUE |
![]() |
![]() ![]() |
SYS_IL0000331028C00006$$ | LOB | UNIQUE |
![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
IMAGE_ID | NUMBER | (15) | Yes | System generated unique identifier from PER_IMAGES_S |
ORIG_SYSTEM | VARCHAR2 | (30) | Yes | Defines the Original System for which the image is inserted. |
ORIG_SYSTEM_ID | NUMBER | (15) | Yes | Primary key of row for which image is held. |
IMAGE_NAME | VARCHAR2 | (60) | Name of the entity for which image is held. | |
CONTENT_TYPE | VARCHAR2 | (30) | File type of the image. | |
IMAGE | BLOB | (4000) | The digitized image, held in TIFF, BMP, JFIF, PCX, PICT or other supported format. | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Object Version Number. | |
LAST_UPDATE_DATE | DATE | Standard Who column. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
CREATED_BY | NUMBER | (15) | Standard Who column. | |
CREATION_DATE | DATE | Standard Who column. |
Cut, paste (and edit) the following text to query this object:
SELECT IMAGE_ID
, ORIG_SYSTEM
, ORIG_SYSTEM_ID
, IMAGE_NAME
, CONTENT_TYPE
, IMAGE
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM HR.PER_EMPDIR_IMAGES;
HR.PER_EMPDIR_IMAGES does not reference any database object
HR.PER_EMPDIR_IMAGES is referenced by following:
|
|
|