Guest User

Untitled

a guest
Jan 19th, 2018
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. copy "SC_Tag"."tagdata_2015-01" ("F_TagName_ID", "F_Date", "F_ConvertedValue")
  2. to "SC_Tag"."tagdata_2015-01_new" (id_tag, f_time, value)
  3.  
  4. INSERT INTO table_dest (fields_list) SELECT fields_list FROM table_src
  5.  
  6. CREATE TABLE "SC_Tag"."tagdata_2015-01_new"
  7. ("id_tag", "f_time", "value")
  8. AS SELECT "F_TagName_ID", "F_Date", "F_ConvertedValue"
  9. FROM "SC_Tag"."tagdata_2015-01"
Add Comment
Please, Sign In to add comment