Syntax

Click to skip syntax diagram
Read syntax diagramSkip visual syntax diagram>>-SET TRANSACTION---------------------------------------------->
 
   .-,-----------------------------------------.
   V                    .-SERIALIZABLE-----.   | (1)
>----+-ISOLATION LEVEL--+-NO COMMIT--------+-+-+---------------><
     |                  +-READ UNCOMMITTED-+ |
     |                  +-READ COMMITTED---+ |
     |                  '-REPEATABLE READ--' |
     | .-READ ONLY--.                        |
     +-+-READ WRITE-+------------------------+
     '-DIAGNOSTICS SIZE--+-integer--+--------'
                         '-variable-'
 
Notes:
  1. Only one ISOLATION LEVEL clause, one READ WRITE or READ ONLY clause, and one DIAGNOSTICS SIZE clause may be specified.