TestOBD

Publikace

    Odrážky:
Querystring:
SELECT 'id'||to_char(row_number() over (order by OBD_FF_PUBLIKACE.NAZEV)) AS "id2", (CASE WHEN ID_FORMA = '73' THEN 'article-journal' WHEN ID_FORMA = '67' THEN 'chapter' WHEN ID_FORMA = '57' THEN 'chapter' WHEN ID_FORMA = '63' THEN 'book' WHEN ID_FORMA = '106' THEN 'chapter' WHEN ID_FORMA = '81' THEN 'paper-conference' WHEN ID_FORMA = '109' THEN 'paper-conference' WHEN ID_FORMA = '121' THEN 'article-journal' WHEN ID_FORMA = '70' THEN 'motion_picture' WHEN ID_FORMA = '17' THEN 'article' WHEN ID_FORMA = '110' THEN 'article' WHEN ID_FORMA = '87' THEN 'patent' ELSE 'book' END) AS "type", PRIJMENI || ', ' || JMENO AS "author", NAZEV AS "title", DECODE(ZDROJ_NAZEV,null,'',ZDROJ_NAZEV) AS "container-title", VYDAVATEL_NAZEV AS "publisher", VYDAVATEL_MISTO AS "publisher-place", ROK, OBD_FF_PUBLIKACE.ID AS idpub, KODAUTORA as idauth, PRIJMENI as family, JMENO as given, KONANI_MESTO AS "event-place", STRANY AS "page", CISLO AS "issue", DECODE(ROCNIK,'Neuveden',' ',ROCNIK) AS "volume", DAT_KON_ZACATEK FROM VERSO.OBD_AUTOR_DATA, VERSO.OBD_FF_PUBLIKACE WHERE OBD_FF_PUBLIKACE.ID IN (507939) AND OBD_AUTOR_DATA.ID_PUBLIKACE IN (SELECT OBD_AUTOR_DATA.ID_PUBLIKACE FROM VERSO.OBD_AUTOR_DATA WHERE KODAUTORA='38203310') AND ROK >= '1348' AND ROK <= '9999' AND OBD_AUTOR_DATA.TYP=1 AND OBD_AUTOR_DATA.ID_PUBLIKACE=OBD_FF_PUBLIKACE.ID ORDER BY OBD_AUTOR_DATA.PORADI
Úvod > TestOBD