Home » SQL & PL/SQL » SQL & PL/SQL » Select into problem (Oracle)
Select into problem [message #348705] Wed, 17 September 2008 13:32 Go to next message
Mackolicious
Messages: 1
Registered: September 2008
Junior Member
Hi

I am doing some data migration and I am stuck on a particular piece of code:

select
customer_id
into
multi_site_cust
from
multicust;

Basically I would like to know how to iterate through the indiviual values of the variable multi_site_cust so that I can compare them using an if statement.
Re: Select into problem [message #348706 is a reply to message #348705] Wed, 17 September 2008 13:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
PL/SQL User's Guide and Reference
Application Developer's Guide - Fundamentals

Regards
Michel
Re: Select into problem [message #348708 is a reply to message #348705] Wed, 17 September 2008 13:54 Go to previous message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

Using Third Normal Form would simplify or eliminate this issue.
Previous Topic: ORA-00600 durring merge on IOT
Next Topic: How to alter index
Goto Forum:
  


Current Time: Tue Dec 06 16:28:09 CST 2016

Total time taken to generate the page: 0.09273 seconds