Select into select
From: Rahim <rahimladha_at_hotmail.com>
Date: 12 Jul 2001 14:24:06 -0700
Message-ID: <13223d42.0107121324.16bd713e_at_posting.google.com>
Date: 12 Jul 2001 14:24:06 -0700
Message-ID: <13223d42.0107121324.16bd713e_at_posting.google.com>
I have this query
select subcase.id_number
I knwo, I can write this kind of query in Informix, MS SQL server. But
when I write this query in Oracle, I got this error "Error: ORA-00936:
missing expression"
Can anyone tell me, what Im doing wrong?
the above query is just a sample, I have a bigger query in which I
have to use SELECT into SELECT
thanks in advance.
(Select case.id_number
From case
Where case.objid=subcase.subcase2case) case_id
from subcase
where subcase.id_number='1000003A'
regards
rahim Received on Thu Jul 12 2001 - 23:24:06 CEST