Select statement - Compound column data

Community Support
1

Hi ,

I have defined a table pv:( a:10 20 30; b:(ab;cde;c))

Now I want to write a select statement to give the column a where each b contains `c.

i.e the?result should be

a

20

30

?

Thanks in advance

?

Regrds,

Saritha

?

?

?

2

select a from pv where c in'bOn 1 June 2012 10:10, Q\_developer <qbank9> wrote:&gt; Hi ,&gt; I have defined a table pv:([] a:10 20 30; b:(ab;cde;c))&gt; Now I want to write a select statement to give the column a where each b&gt; contains c.> i.e the?result should be> a> -> 20> 30>> Thanks in advance>> Regrds,> Saritha>>>>> –>

Submitted via Google Groups

3

select from pv where ('c in) each b

correct the symbol c.

Hth

Kim

Von meinem iPhone gesendet

Am 01.06.2012 um 11:10 schrieb Q_developer <qbank9@gmail.com>:

Hi ,

I have defined a table pv:( a:10 20 30; b:(ab;cde;c))

Now I want to write a select statement to give the column a where each b contains `c.

i.e the result should be

a

20

30

 

Thanks in advance

 

Regrds,

Saritha

 

 

 

–
Submitted via Google Groups

4

you can hold down ’ to get `

Cheers,

  Attila

5

Am 01.06.2012 19:13, schrieb Attila Vrabecz:

you can hold down ’ to get `

It works on my iphone, thx.

Kim

Cheers,

  Attila