Hi all,
I'm working on a script that turns on and off the 'row archival visibility' for it's session. But I want to only execute "alter session set row archival visibility = ALL", if the session is currently set to ACTIVE. Is there a way to query for that value? I know it's doesn't hurt to set it to what it already is, but since my script does it many time, I'm trying to avoid multiple alter session commands.
Thanks