• Home
• org.kuali.ole
• ole-ls-sql
• 1.6.2
• source code
• OLE_CAT_CMPLT_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_CAT_CMPLT_T.sql Maven / Gradle / Ivy

TRUNCATE TABLE OLE_CAT_CMPLT_T
/
INSERT INTO OLE_CAT_CMPLT_T (CMPLT_CD,CMPLT_ID,CMPLT_NM,OBJ_ID,ROW_ACT_IND,SRC,SRC_DT,VER_NBR)
  VALUES ('0',1,'Other','1000','Y','MFHD 008-16 http://www.loc.gov/marc/holdings/hd008.html',STR_TO_DATE( '20120322000000', '%Y%m%d%H%i%s' ),1)
/
INSERT INTO OLE_CAT_CMPLT_T (CMPLT_CD,CMPLT_ID,CMPLT_NM,OBJ_ID,ROW_ACT_IND,SRC,SRC_DT,VER_NBR)
  VALUES ('1',2,'Complete','1001','Y','MFHD 008-16 http://www.loc.gov/marc/holdings/hd008.html',STR_TO_DATE( '20120322000000', '%Y%m%d%H%i%s' ),1)
/
INSERT INTO OLE_CAT_CMPLT_T (CMPLT_CD,CMPLT_ID,CMPLT_NM,OBJ_ID,ROW_ACT_IND,SRC,SRC_DT,VER_NBR)
  VALUES ('2',3,'Incomplete','1002','Y','MFHD 008-16 http://www.loc.gov/marc/holdings/hd008.html',STR_TO_DATE( '20120322000000', '%Y%m%d%H%i%s' ),1)
/
INSERT INTO OLE_CAT_CMPLT_T (CMPLT_CD,CMPLT_ID,CMPLT_NM,OBJ_ID,ROW_ACT_IND,SRC,SRC_DT,VER_NBR)
  VALUES ('3',4,'Scattered','1003','Y','MFHD 008-16 http://www.loc.gov/marc/holdings/hd008.html',STR_TO_DATE( '20120322000000', '%Y%m%d%H%i%s' ),1)
/
INSERT INTO OLE_CAT_CMPLT_T (CMPLT_CD,CMPLT_ID,CMPLT_NM,OBJ_ID,ROW_ACT_IND,SRC,SRC_DT,VER_NBR)
  VALUES ('4',5,'Not applicable','1004','Y','MFHD 008-16 http://www.loc.gov/marc/holdings/hd008.html',STR_TO_DATE( '20120322000000', '%Y%m%d%H%i%s' ),1)
/