Skip to content

Instantly share code, notes, and snippets.

@tqheel

tqheel/gist:4560463

Created January 17, 2013 22:31
Download ZIP

Revisions

  1. tqheel created this gist Jan 17, 2013.
    8 changes: 8 additions & 0 deletions gistfile1.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,8 @@
    insert into app_item(app_item_id, control_id, app_page_id, description, default_label)
    select SEQ_APP_ITEM.nextval, a, b, c, d from
    (
    select'LabelNameSuffix' as a, 183 as b, 'Name Suffix' as c, 'Name Suffix' as d from dual
    union all
    select 'LabelFax', 184, 'Fax Number', 'Fax Number' from dual
    )
    ;