I'm working with a database Firebird 2.5 my question and can generate a query or procedures, for example
my table
CREATE TABLE COUNTRY
(REGION VARCHAR2 (20),
COLOR VARCHAR2 (20))
INSERT VALUES
REGION COLOR
Malta RED
Malta GRAY
Brazil GREEN ON RED
Brazil WHITE
I would like to have this result
REGION GRAY GREEN ON RED RED WHITE
Brazil 0 1 0 1
Malta 1 0 1 0
I thank you in advance for your help