Previous Topic: DIALECT_TEXTNext Topic: SCROLL_AMOUNT (Scroll Amount Values for Dialect)


Task

List all the dialect text values for commands.

SELECT DLECT.NAME, CMD.NAME, TEXT.TEXT_VALUE
  FROM
  MODEL M,
  DIALECT DLECT,
  DIALECT_TEXT TEXT,
  COMMAND CMD
  WHERE
  M.NAME = 'my model name'
  AND DLECT.MODEL_ID = M.ID
  AND TEXT.DIALECT_ID = DLECT.ID
  AND TEXT.OBJECT_ID = CMD_ID
ORDER BY DLECT.NAME, CMD.NAME;