Skip to Content
0

i don't undrstand the array concept to insert values

Aug 30, 2017 at 07:00 AM

22

avatar image

Hi friends,

Here i'm trying to insert a array values into the table.

below code shows my work:


create column table "KABIL_PRACTICE"."Array_Insert"
(
"Id" integer,
"Dept_Id" integer array
);

insertinto"keerthi"."Array_Insert"values( 3, array
(2,3,5,6));

But it results looks like:

|Id| Dept_Id |

|3 |040000000102000000010300000001050000000106000000 |

but i want to see my table original values like:

|Id| Dept_Id |

|3| 2 |

|?| 3 |

|?| 5 |

|?| 6 |

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers