Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE GLOBALSETTINGS
- SET settingValue = case
- when settingName = 'SessionTTL' then '40'
- when settingName = 'MaxUsersActive' then '50'
- else settingValue
- end
- WHERE settingName in ('SessionTTL', 'MaxUsersActive');
- //The result:
- Error starting at line 1 in command:
- UPDATE GLOBALSETTINGS
- SET settingValue = case
- when settingName = 'SessionTTL' then '40'
- when settingName = 'MaxUsersActive' then '50'
- else settingValue
- end
- WHERE settingName in ('SessionTTL', 'MaxUsersActive')
- Error at Command Line:7 Column:6
- Error report:
- SQL Error: ORA-00904: "SETTINGNAME": invalid identifier
- 00904. 00000 - "%s: invalid identifier"
- *Cause:
- *Action:
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement