No, the set prompt command is not supported.
Through Tools > Preferences > Appearance you can set connection indicators though. You could for example define a red background color when connected to a production database, a yellow background when connected through a DBA account, and so on.