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

TRUNCATE TABLE OLE_CAT_ENCD_LVL_T DROP STORAGE
/
INSERT INTO OLE_CAT_ENCD_LVL_T (ENCD_LVL_CD,ENCD_LVL_ID,ENCD_LVL_NM,OBJ_ID,ROW_ACT_IND,SRC,VER_NBR,SRC_DT)
  VALUES ('1',1,'Holdings level 1 ','1000','Y','MFHD Leader 17 Encoding Level: http://www.loc.gov/marc/holdings/hdleader.html',1,TO_DATE( '20120322000000', 'YYYYMMDDHH24MISS' ))
/
INSERT INTO OLE_CAT_ENCD_LVL_T (ENCD_LVL_CD,ENCD_LVL_ID,ENCD_LVL_NM,OBJ_ID,ROW_ACT_IND,SRC,VER_NBR,SRC_DT)
  VALUES ('2',2,'Holdings level 2 ','1001','Y','MFHD Leader 17 Encoding Level: http://www.loc.gov/marc/holdings/hdleader.html',1,TO_DATE( '20120322000000', 'YYYYMMDDHH24MISS' ))
/
INSERT INTO OLE_CAT_ENCD_LVL_T (ENCD_LVL_CD,ENCD_LVL_ID,ENCD_LVL_NM,OBJ_ID,ROW_ACT_IND,SRC,VER_NBR,SRC_DT)
  VALUES ('3',3,'Holdings level 3 ','1002','Y','MFHD Leader 17 Encoding Level: http://www.loc.gov/marc/holdings/hdleader.html',1,TO_DATE( '20120322000000', 'YYYYMMDDHH24MISS' ))
/
INSERT INTO OLE_CAT_ENCD_LVL_T (ENCD_LVL_CD,ENCD_LVL_ID,ENCD_LVL_NM,OBJ_ID,ROW_ACT_IND,SRC,VER_NBR,SRC_DT)
  VALUES ('4',4,'Holdings level 4 ','1003','Y','MFHD Leader 17 Encoding Level: http://www.loc.gov/marc/holdings/hdleader.html',1,TO_DATE( '20120322000000', 'YYYYMMDDHH24MISS' ))
/
INSERT INTO OLE_CAT_ENCD_LVL_T (ENCD_LVL_CD,ENCD_LVL_ID,ENCD_LVL_NM,OBJ_ID,ROW_ACT_IND,SRC,VER_NBR,SRC_DT)
  VALUES ('5',5,'Holdings level 4 with piece designation ','1004','Y','MFHD Leader 17 Encoding Level: http://www.loc.gov/marc/holdings/hdleader.html',1,TO_DATE( '20120322000000', 'YYYYMMDDHH24MISS' ))
/
INSERT INTO OLE_CAT_ENCD_LVL_T (ENCD_LVL_CD,ENCD_LVL_ID,ENCD_LVL_NM,OBJ_ID,ROW_ACT_IND,SRC,VER_NBR,SRC_DT)
  VALUES ('m',6,'Mixed level ','1006','Y','MFHD Leader 17 Encoding Level: http://www.loc.gov/marc/holdings/hdleader.html',1,TO_DATE( '20120322000000', 'YYYYMMDDHH24MISS' ))
/
INSERT INTO OLE_CAT_ENCD_LVL_T (ENCD_LVL_CD,ENCD_LVL_ID,ENCD_LVL_NM,OBJ_ID,ROW_ACT_IND,SRC,VER_NBR,SRC_DT)
  VALUES ('u',7,'Unknown ','1007','Y','MFHD Leader 17 Encoding Level: http://www.loc.gov/marc/holdings/hdleader.html',1,TO_DATE( '20120322000000', 'YYYYMMDDHH24MISS' ))
/
INSERT INTO OLE_CAT_ENCD_LVL_T (ENCD_LVL_CD,ENCD_LVL_ID,ENCD_LVL_NM,OBJ_ID,ROW_ACT_IND,SRC,VER_NBR,SRC_DT)
  VALUES ('z',8,'Other level ','1008','Y','MFHD Leader 17 Encoding Level: http://www.loc.gov/marc/holdings/hdleader.html',1,TO_DATE( '20120322000000', 'YYYYMMDDHH24MISS' ))
/