( CODE_HORSE, CODE_FATHER, Операторы DML 301 CODE_MOTHER, NAME, MARK, DEPTH) AS (SELECT HORSE.CODE_HORSE, HORSE.CODE_FATHER, HORSE.CODE_MOTHER, PEDIGREE.DEPTH + 1 FROM HORSE JOIN PEDIGREE ON HORSE.CODE_HORSE = PEDIGREE.CODE_FATHER WHERE –- ограничение глубины рекурсии PEDIGREE.DEPTH < :MAX_DEPTH UNION PEDIGREE.DEPTH + 1 FROM HORSE JOIN PEDIGREE ON HORSE.CODE_HORSE = PEDIGREE.CODE_MOTHER WHERE –- ограничение глубины рекурсии PEDIGREE.DEPTH < :MAX_DEPTH ) SELECT

pedigree. WITH RECURSIVE PEDIGREE ( CODE_HORSE, CODE_FATHER, CODE_MOTHER, NAME, MARK, DEPTH) AS (SELECT HORSE.CODE_HORSE, HORSE.CODE_FATHER, HORSE.CODE_MOTHER, HORSE PEDIGREE.DEPTH + 1 FROM HORSE JOIN PEDIGREE ON HORSE.CODE_HORSE = PEDIGREE.CODE_FATHER WHERE Chapter 6. Data Manipulation (DML) Statements 234 PEDIGREE.DEPTH < :MAX_DEPTH :MAX_DEPTH UNION ALL SELECT HORSE.CODE_HORSE, HORSE.CODE_FATHER, HORSE.CODE_MOTHER, HORSE.NAME, 'M' || PEDIGREE.MARK, PEDIGREE.DEPTH + 1 FROM HORSE

pedigree. WITH RECURSIVE PEDIGREE ( CODE_HORSE, CODE_FATHER, CODE_MOTHER, NAME, MARK, DEPTH) AS (SELECT HORSE.CODE_HORSE, HORSE.CODE_FATHER, HORSE.CODE_MOTHER, HORSE PEDIGREE.MARK, PEDIGREE.DEPTH + 1 FROM HORSE JOIN PEDIGREE ON HORSE.CODE_HORSE = PEDIGREE.CODE_FATHER WHERE PEDIGREE.DEPTH < :MAX_DEPTH UNION ALL SELECT Chapter PEDIGREE.DEPTH + 1 FROM HORSE JOIN PEDIGREE ON HORSE.CODE_HORSE = PEDIGREE.CODE_MOTHER WHERE PEDIGREE.DEPTH < :MAX_DEPTH ) SELECT CODE_HORSE, NAME, MARK, DEPTH FROM

auftritt. WITH RECURSIVE PEDIGREE ( CODE_HORSE, CODE_FATHER, CODE_MOTHER, NAME, MARK, DEPTH) AS (SELECT HORSE.CODE_HORSE, HORSE.CODE_FATHER, HORSE.CODE_MOTHER, HORSE PEDIGREE.DEPTH + 1 FROM HORSE JOIN PEDIGREE ON HORSE.CODE_HORSE = PEDIGREE.CODE_FATHER Chapter 6. Data Manipulation-Statements (DML) 304 WHERE PEDIGREE.DEPTH < :MAX_DEPTH :MAX_DEPTH UNION ALL SELECT HORSE.CODE_HORSE, HORSE.CODE_FATHER, HORSE.CODE_MOTHER, HORSE.NAME, 'M' || PEDIGREE.MARK, PEDIGREE.DEPTH + 1 FROM HORSE

is full. -904 335544676 sort_mem_err Sort error: not enough memory -904 335544683 req_depth_exceeded Request depth exceeded. (Recursive definition?) -904 335544758 sort_rec_size_err Sort record size of

is full. -904 335544676 sort_mem_err Sort error: not enough memory -904 335544683 req_depth_exceeded Request depth exceeded. (Recursive definition?) -904 335544758 sort_rec_size_err Sort record size of

is full. -904 335544676 sort_mem_err Sort error: not enough memory -904 335544683 req_depth_exceeded Request depth exceeded. (Recursive definition?) -904 335544758 sort_rec_size_err Sort record size of

stdout file names in backups and restores. A section has been added to Gbak Caveats giving more in depth detail about these two special file names. 1.9 11 Apr 2013 ND A section has been added to explain