• Home
• org.kuali.ole
• ole-master-sql
• 1.5.8
• source code
• OLE_EXCHANGE_RT_T.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sql.mysql.OLE_EXCHANGE_RT_T.sql Maven / Gradle / Ivy

TRUNCATE TABLE OLE_EXCHANGE_RT_T
/
INSERT INTO OLE_EXCHANGE_RT_T (OLE_EXCHANGE_RT_ID,OLE_CURR_TYP_ID,OLE_EXCHANGE_RT,OLE_EXCHANGE_RT_SRC,OLE_EXCHANGE_RT_DT,VER_NBR,OBJ_ID,ROW_ACT_IND)
  VALUES (1.0,2.0,1.010048,'http://www.exchangerate.com/',STR_TO_DATE( '20111019000000', '%Y%m%d%H%i%s' ),1.0,'1','Y')
/
INSERT INTO OLE_EXCHANGE_RT_T (OLE_EXCHANGE_RT_ID,OLE_CURR_TYP_ID,OLE_EXCHANGE_RT,OLE_EXCHANGE_RT_SRC,OLE_EXCHANGE_RT_DT,VER_NBR,OBJ_ID,ROW_ACT_IND)
  VALUES (2.0,3.0,1.760085,'http://www.exchangerate.com/',STR_TO_DATE( '20111019000000', '%Y%m%d%H%i%s' ),1.0,'2','Y')
/
INSERT INTO OLE_EXCHANGE_RT_T (OLE_EXCHANGE_RT_ID,OLE_CURR_TYP_ID,OLE_EXCHANGE_RT,OLE_EXCHANGE_RT_SRC,OLE_EXCHANGE_RT_DT,VER_NBR,OBJ_ID,ROW_ACT_IND)
  VALUES (3.0,4.0,1.031067,'http://www.exchangerate.com/',STR_TO_DATE( '20111019000000', '%Y%m%d%H%i%s' ),1.0,'3','Y')
/
INSERT INTO OLE_EXCHANGE_RT_T (OLE_EXCHANGE_RT_ID,OLE_CURR_TYP_ID,OLE_EXCHANGE_RT,OLE_EXCHANGE_RT_SRC,OLE_EXCHANGE_RT_DT,VER_NBR,OBJ_ID,ROW_ACT_IND)
  VALUES (4.0,5.0,6.375296,'http://www.exchangerate.com/',STR_TO_DATE( '20111019000000', '%Y%m%d%H%i%s' ),1.0,'4','Y')
/
INSERT INTO OLE_EXCHANGE_RT_T (OLE_EXCHANGE_RT_ID,OLE_CURR_TYP_ID,OLE_EXCHANGE_RT,OLE_EXCHANGE_RT_SRC,OLE_EXCHANGE_RT_DT,VER_NBR,OBJ_ID,ROW_ACT_IND)
  VALUES (5.0,6.0,5.467014,'http://www.exchangerate.com/',STR_TO_DATE( '20111019000000', '%Y%m%d%H%i%s' ),1.0,'5','Y')
/
INSERT INTO OLE_EXCHANGE_RT_T (OLE_EXCHANGE_RT_ID,OLE_CURR_TYP_ID,OLE_EXCHANGE_RT,OLE_EXCHANGE_RT_SRC,OLE_EXCHANGE_RT_DT,VER_NBR,OBJ_ID,ROW_ACT_IND)
  VALUES (6.0,7.0,5.467014,'http://www.exchangerate.com/',STR_TO_DATE( '20111019000000', '%Y%m%d%H%i%s' ),1.0,'6','Y')
/
INSERT INTO OLE_EXCHANGE_RT_T (OLE_EXCHANGE_RT_ID,OLE_CURR_TYP_ID,OLE_EXCHANGE_RT,OLE_EXCHANGE_RT_SRC,OLE_EXCHANGE_RT_DT,VER_NBR,OBJ_ID,ROW_ACT_IND)
  VALUES (7.0,8.0,49.28734,'http://www.exchangerate.com/',STR_TO_DATE( '20111019000000', '%Y%m%d%H%i%s' ),1.0,'7','Y')
/
INSERT INTO OLE_EXCHANGE_RT_T (OLE_EXCHANGE_RT_ID,OLE_CURR_TYP_ID,OLE_EXCHANGE_RT,OLE_EXCHANGE_RT_SRC,OLE_EXCHANGE_RT_DT,VER_NBR,OBJ_ID,ROW_ACT_IND)
  VALUES (8.0,9.0,76.64356,'http://www.exchangerate.com/',STR_TO_DATE( '20111019000000', '%Y%m%d%H%i%s' ),1.0,'8','Y')
/
INSERT INTO OLE_EXCHANGE_RT_T (OLE_EXCHANGE_RT_ID,OLE_CURR_TYP_ID,OLE_EXCHANGE_RT,OLE_EXCHANGE_RT_SRC,OLE_EXCHANGE_RT_DT,VER_NBR,OBJ_ID,ROW_ACT_IND)
  VALUES (9.0,10.0,13.32066,'http://www.exchangerate.com/',STR_TO_DATE( '20111019000000', '%Y%m%d%H%i%s' ),1.0,'10','Y')
/
INSERT INTO OLE_EXCHANGE_RT_T (OLE_EXCHANGE_RT_ID,OLE_CURR_TYP_ID,OLE_EXCHANGE_RT,OLE_EXCHANGE_RT_SRC,OLE_EXCHANGE_RT_DT,VER_NBR,OBJ_ID,ROW_ACT_IND)
  VALUES (10.0,11.0,1.28008,'http://www.exchangerate.com/',STR_TO_DATE( '20111019000000', '%Y%m%d%H%i%s' ),1.0,'11','Y')
/
INSERT INTO OLE_EXCHANGE_RT_T (OLE_EXCHANGE_RT_ID,OLE_CURR_TYP_ID,OLE_EXCHANGE_RT,OLE_EXCHANGE_RT_SRC,OLE_EXCHANGE_RT_DT,VER_NBR,OBJ_ID,ROW_ACT_IND)
  VALUES (11.0,12.0,5.693372,'http://www.exchangerate.com/',STR_TO_DATE( '20111019000000', '%Y%m%d%H%i%s' ),1.0,'12','Y')
/
INSERT INTO OLE_EXCHANGE_RT_T (OLE_EXCHANGE_RT_ID,OLE_CURR_TYP_ID,OLE_EXCHANGE_RT,OLE_EXCHANGE_RT_SRC,OLE_EXCHANGE_RT_DT,VER_NBR,OBJ_ID,ROW_ACT_IND)
  VALUES (12.0,13.0,1.283061,'http://www.exchangerate.com/',STR_TO_DATE( '20111019000000', '%Y%m%d%H%i%s' ),1.0,'13','Y')
/
INSERT INTO OLE_EXCHANGE_RT_T (OLE_EXCHANGE_RT_ID,OLE_CURR_TYP_ID,OLE_EXCHANGE_RT,OLE_EXCHANGE_RT_SRC,OLE_EXCHANGE_RT_DT,VER_NBR,OBJ_ID,ROW_ACT_IND)
  VALUES (13.0,14.0,7.925284,'http://www.exchangerate.com/',STR_TO_DATE( '20111019000000', '%Y%m%d%H%i%s' ),1.0,'14','Y')
/
INSERT INTO OLE_EXCHANGE_RT_T (OLE_EXCHANGE_RT_ID,OLE_CURR_TYP_ID,OLE_EXCHANGE_RT,OLE_EXCHANGE_RT_SRC,OLE_EXCHANGE_RT_DT,VER_NBR,OBJ_ID,ROW_ACT_IND)
  VALUES (14.0,15.0,6.679437,'http://www.exchangerate.com/',STR_TO_DATE( '20111019000000', '%Y%m%d%H%i%s' ),1.0,'16','Y')
/
INSERT INTO OLE_EXCHANGE_RT_T (OLE_EXCHANGE_RT_ID,OLE_CURR_TYP_ID,OLE_EXCHANGE_RT,OLE_EXCHANGE_RT_SRC,OLE_EXCHANGE_RT_DT,VER_NBR,OBJ_ID,ROW_ACT_IND)
  VALUES (15.0,16.0,0.907658,'http://www.exchangerate.com/',STR_TO_DATE( '20111019000000', '%Y%m%d%H%i%s' ),1.0,'17','Y')
/
INSERT INTO OLE_EXCHANGE_RT_T (OLE_EXCHANGE_RT_ID,OLE_CURR_TYP_ID,OLE_EXCHANGE_RT,OLE_EXCHANGE_RT_SRC,OLE_EXCHANGE_RT_DT,VER_NBR,OBJ_ID,ROW_ACT_IND)
  VALUES (16.0,17.0,30.33098,'http://www.exchangerate.com/',STR_TO_DATE( '20111019000000', '%Y%m%d%H%i%s' ),1.0,'18','Y')
/
INSERT INTO OLE_EXCHANGE_RT_T (OLE_EXCHANGE_RT_ID,OLE_CURR_TYP_ID,OLE_EXCHANGE_RT,OLE_EXCHANGE_RT_SRC,OLE_EXCHANGE_RT_DT,VER_NBR,OBJ_ID,ROW_ACT_IND)
  VALUES (17.0,18.0,30.93147,'http://www.exchangerate.com/',STR_TO_DATE( '20111019000000', '%Y%m%d%H%i%s' ),1.0,'19','Y')
/
INSERT INTO OLE_EXCHANGE_RT_T (OLE_EXCHANGE_RT_ID,OLE_CURR_TYP_ID,OLE_EXCHANGE_RT,OLE_EXCHANGE_RT_SRC,OLE_EXCHANGE_RT_DT,VER_NBR,OBJ_ID,ROW_ACT_IND)
  VALUES (18.0,19.0,0.640632,'http://www.exchangerate.com/',STR_TO_DATE( '20111019000000', '%Y%m%d%H%i%s' ),1.0,'20','Y')
/
INSERT INTO OLE_EXCHANGE_RT_T (OLE_EXCHANGE_RT_ID,OLE_CURR_TYP_ID,OLE_EXCHANGE_RT,OLE_EXCHANGE_RT_SRC,OLE_EXCHANGE_RT_DT,VER_NBR,OBJ_ID,ROW_ACT_IND)
  VALUES (19.0,20.0,0.737147,'http://www.exchangerate.com/',STR_TO_DATE( '20110919000000', '%Y%m%d%H%i%s' ),1.0,'22','Y')
/
INSERT INTO OLE_EXCHANGE_RT_T (OLE_EXCHANGE_RT_ID,OLE_CURR_TYP_ID,OLE_EXCHANGE_RT,OLE_EXCHANGE_RT_SRC,OLE_EXCHANGE_RT_DT,VER_NBR,OBJ_ID,ROW_ACT_IND)
  VALUES (20.0,1.0,1.000000,'http://www.exchangerate.com/',STR_TO_DATE( '20110919000000', '%Y%m%d%H%i%s' ),1.0,'23','Y')
/