Re: [GENERAL] postgresql varchar[] data type equivalent in Oracle

2007-06-26 Thread Albe Laurenz
Murali Doss wrote: > > I like to know about postgresql varchar[ ] data type > equivalent in Oracle. The best I can think of is a VARRAY, though you cannot access it by index in SQL (you need a stored procedure or client API for that). Quite clumsy. Example: SQL> CREATE TYPE VARCHAR_A AS VARRAY

[GENERAL] postgresql varchar[] data type equivalent in Oracle

2007-06-25 Thread Murali Doss
Dear All, I like to know about postgresql varchar[ ] data type equivalent in Oracle. Regards Murali Doss T.S.