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

TRUNCATE TABLE OLE_CAT_LND_POL_T DROP STORAGE
/
INSERT INTO OLE_CAT_LND_POL_T (LND_POL_CD,LND_POL_ID,LND_POL_NM,OBJ_ID,ROW_ACT_IND,SRC,SRC_DT,VER_NBR)
  VALUES ('a',1,'Will Lend','febedf5c-7e31-4af5-b3ce-05a100af895a','Y','MFHD 008-20 http://www.loc.gov/marc/holdings/hd008.html',TO_DATE( '20120405120000', 'YYYYMMDDHH24MISS' ),1)
/
INSERT INTO OLE_CAT_LND_POL_T (LND_POL_CD,LND_POL_ID,LND_POL_NM,OBJ_ID,ROW_ACT_IND,SRC,SRC_DT,VER_NBR)
  VALUES ('b',2,'Will Not Lend','6437c4df-471e-4192-838b-0d3942b5da75','Y','MFHD 008-20 http://www.loc.gov/marc/holdings/hd008.html',TO_DATE( '20120405120000', 'YYYYMMDDHH24MISS' ),1)
/
INSERT INTO OLE_CAT_LND_POL_T (LND_POL_CD,LND_POL_ID,LND_POL_NM,OBJ_ID,ROW_ACT_IND,SRC,SRC_DT,VER_NBR)
  VALUES ('c',3,'Will lend hard copy only','3bdad86c-a6c2-4332-80db-e9fcbbb8fa36','Y','MFHD 008-20 http://www.loc.gov/marc/holdings/hd008.html',TO_DATE( '20120405120000', 'YYYYMMDDHH24MISS' ),1)
/
INSERT INTO OLE_CAT_LND_POL_T (LND_POL_CD,LND_POL_ID,LND_POL_NM,OBJ_ID,ROW_ACT_IND,SRC,SRC_DT,VER_NBR)
  VALUES ('l',4,'Limited lending policy','acbadb5f-47da-49fd-8fda-c13e5710898f','Y','MFHD 008-20 http://www.loc.gov/marc/holdings/hd008.html',TO_DATE( '20120405120000', 'YYYYMMDDHH24MISS' ),1)
/
INSERT INTO OLE_CAT_LND_POL_T (LND_POL_CD,LND_POL_ID,LND_POL_NM,OBJ_ID,ROW_ACT_IND,SRC,SRC_DT,VER_NBR)
  VALUES ('u',5,'unknown','3ff8b76a-780c-4ea2-98a1-c17e09938c92','Y','MFHD 008-20 http://www.loc.gov/marc/holdings/hd008.html',TO_DATE( '20120405120000', 'YYYYMMDDHH24MISS' ),1)
/