SET Statement

  1. SET param = value

Assigns value to the param setting for the current session. You cannot change server settings this way.

You can also set all the values from the specified settings profile in a single query.

  1. SET profile = 'profile-name-from-the-settings-file'

For more information, see Settings.