Cacher is the code snippet organizer for pro developers

	SELECT 
INVENTORY_ITEM_ID, 
ORGANIZATION_ID, 
CATEGORY_SET_ID, 
CATEGORY_ID, 
LAST_UPDATE_DATE, 
LAST_UPDATED_BY, 
CREATION_DATE, 
CREATED_BY, 
LAST_UPDATE_LOGIN, 
REQUEST_ID, 
PROGRAM_APPLICATION_ID, 
PROGRAM_ID, 
PROGRAM_UPDATE_DATE, 
WH_UPDATE_DATE,
ora_hash(ROWIDTOCHAR(ROWID)) as RID,
ROWIDTOCHAR(ROWID) as RidChar
 FROM MTL_ITEM_CATEGORIES