Difference in pdb level: db_name vs con_name
Hi
Oracle 19c
I am planning on using this this sys_context(userenv) in one of my scripts. And I stumbled onto the following. So which one should I use.
What is the difference, and can these 2 differ at some point..?
I mean is it possibile to have user created pluggable database where con_name != db_name .?
SQL> col db_name for a15;SQL> col con_name for a15;SQL> select sys_context('userenv', 'con_name') as con_name, sys_context('userenv', 'db_name') as db_name from dual;CON_NAME DB_NAME--------------- ---------------PDBET PDBET
For example, here in create and alter statements, does this name refers to db_name or con_name ?