Posted by Anonymous Fri 2nd Mar 2007 00:33 - Syntax is Diff - 49 views
Download | New Post | Modify | Hide line numbers
  1. INSERT INTO fv_document
  2. (
  3.     doc_id, doc_url_id, doc_class_id, doc_type_id, user_id,
  4.     doc_status_id, doc_title, doc_desc, date_created, date_updated,
  5.     map_lat, map_lon, bldg_floor
  6. )
  7. SELECT
  8.     doc_id, doc_url_id, doc_class_id, doc_type_id, user_id,
  9.     1, doc_title, doc_desc, SYSDATE, NULL,
  10.     map_lat, map_lon, 1
  11. FROM fv_document2

PermaLink to this entry https://pastebin.co.uk/11270
Posted by Anonymous Fri 2nd Mar 2007 00:33 - Syntax is Diff - 49 views
Download | New Post | Modify | Hide line numbers

 

Comments: 0