Born with the drab, unlikely name of Josephine Cottle on April 5, 1922, this pleasantly appealing, Texas-born, auburn-haired beauty was only seventeen months old when her father William passed away.
Oracle supports this through the use of temporary tablespace groups â this is a synonym for a list of temporary tablespaces. Â· A single user can have more than one temporary tablespace in use by assigning the temporary tablespace group as the default to the user instead of a single temporary tablespace.
LISTAGG makes string aggregation task pretty convenient but it was introduced in Oracle 11g release 2 so cannot be used in Oracle 10g. Instead we can use our own collection types with COLLECT function and display it using CAST function. It works slower than LISTAGG(of course) but serves the purpose.