I need to create a table dummy and insert teh records in dummy using pl/sql . RSS

• • Reply
  

  poojakulkarn...

  Member

  24 Points

  109 Posts

  I need to create a table dummy and insert teh records in dummy using pl/sql .

  Dec 07, 2011 08:37 AM|LINK

  SELECT

  mct1.cconceptproductid0 into dummy FROM

  MCT_63904 mct1, principalKey pkey1 ,

  goldenCopy gc

  where pkey1.catalogid = gc.catalogid AND

  pkey1.productkeyid = mct1.cproductkeyid

  AND

  pkey1.modversion = mct1.cmodversion AND mct1.cmodversion = gc.version AND

  gc.productkey = mct1.cproductkeyid

  AND pkey1.active =

  'Y'

  • Moved by XIII on Dec 07, 2011 09:36 AM
• • Reply
  

  smirnov

  All-Star

  23512 Points

  4037 Posts

  Re: I need to create a table dummy and insert teh records in dummy using pl/sql .

  Dec 07, 2011 10:16 AM|LINK

  And what is the problem here? The sql seems to be ok