---
-- There are two rules
-- Rule 1 has one test
-- Rule 2 has two tests that should be evaluated to TRUE
---
drop table test_vertical;
create table test_vertical (m_id number,col1 varch
Title: RE: vertical serches on a table - how to
Susan,
me thinks following condition specified is vague ... when compared to the output you specify.
(COL1=mango and COL2=banana AND COL1=grape and COL2=pineapple)
Raj
-Original Message-
From: Susan Tay [mailto:[EMAIL PROTECTED
Stephane,
Fantastic! Appreciate the help.
Thanks!
susan
From: "Stephane Faroult" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: RE: RE: vertical serches on a table - how to
Date: Wed, 01 Oct 2003 08
>Stephane,
>Apologize for not being clear on my question.
>
>The query you have provided will only return one
>record, ie.
>1 mango banana.
>
>I need two records to be returned:
>1 mangobanana
>1 grape pineapple
>
>You're right that by 'vertical', I meant filtering
>according to conditio
<[EMAIL PROTECTED]>
Subject: RE: vertical serches on a table - how to
Date: Wed, 01 Oct 2003 06:14:32 -0800
>Hi,
>I have a table that I would like to perform a
>vertical search on. For eg.
>
>Table X
>---
>ID COL1 COL2
>1 apple orange
>1 m
>Hi,
>I have a table that I would like to perform a
>vertical search on. For eg.
>
>Table X
>---
>IDCOL1 COL2
>1 apple orange
>1 mango banana
>1 grape pineapple
>2 mango banana
>2 guava lemon
>
>
>I would like to display re