OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » SQL QUES

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL QUES [message #377]

Fri, 08 February 2002 06:15

Neke_73
Messages: 1
Registered: February 2002

Junior Member

Why won't the following statement execute?

select ci.order_item_id "Order Item ID", ci.conc_spec_id, ci.num_substances, ci.testset_id, ci.reservation_id,
ci.bill_of_material_id, co.bom_type, cs.container_set_id from cos_order_item ci, cos_order_item_cont_set cs,
cos_order co where ci.order_item_id = cs.order_item_id and
co.order_id=ci.order_id
if co.bom_type = well
then select ci.bill_of_material_id from cos_order_item_cont_set
else co.bom_type = "null"
end if;

Report message to a moderator

Re: SQL QUES [message #378 is a reply to message #377]

Fri, 08 February 2002 06:49

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

there is no into clause

select ci.order_item_id "Order Item ID", ci.conc_spec_id, ci.num_substances, ci.testset_id, ci.reservation_id,
ci.bill_of_material_id, co.bom_type, cs.container_set_id from cos_order_item ci, cos_order_item_cont_set cs,
cos_order co
into .........into_list goes here.........
where ci.order_item_id = cs.order_item_id and
co.order_id=ci.order_id

Report message to a moderator