Oracle 10 Database Training
- نسخه :Version 10
- نوع فایل : نرم افزار
- زبان : انگلیسی
- سیستم عامل : Windows 32Bit & 64Bit
- تولید کننده : Oracle
- سال تولید : 2012
Description
Oracle 10g has introduced an extremely useful new group function, COLLECT. This function enables us to aggregate data into a collection, retaining multiple records of data within a single row (like a nested table). One of the main benefits of this function is that it makes "string aggregation" (one of the web's most-requested Oracle technique) very simple. This article will introduce the COLLECT function and then demonstrate how it can be used to aggregate multiple records into a single value (a technique known as "string aggregation
