Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Aug 5th, 2012  |  syntax: None  |  size: 1.03 KB  |  hits: 8  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Try to insert a record into a table with select and join
  2. Insert into seda_owner.seda_lookup(table_name,description,sequence,value)
  3. Select 'DEFAULT_CATE_CHG_ITEMS_DOCS','Software Requirements Specification', '1',
  4.   (select **value** from seda_owner.seda_document a
  5.    join seda_owner.seda_lookup b
  6.     on b.value = a.guid and description = 'Software Requirements Specification');
  7.        
  8. Insert into seda_owner.seda_lookup(table_name,description,sequence,value)
  9. Select 'DEFAULT_CATE_CHG_ITEMS_DOCS','Software Requirements Specification', '1',
  10.   (select **value** from seda_owner.seda_document a
  11.    inner join seda_owner.seda_lookup b
  12.     on b.value = a.guid and description = 'Software Requirements Specification')
  13. from dual;
  14.        
  15. Insert into seda_owner.seda_lookup(table_name,description,sequence,value)
  16. Select 'DEFAULT_CATE_CHG_ITEMS_DOCS','Software Requirements Specification',
  17.     '1', **value**
  18. from seda_owner.seda_document a
  19. inner join seda_owner.seda_lookup b
  20.     on b.value = a.guid and description = 'Software Requirements Specification'
create a new version of this paste RAW Paste Data