Oracle 21c New Feature in SQL*Plus – set jsonprint

New sqlplus feature is introduced in Oracle 21c release sql plus for json output format, to illustrate:

SQL> show jsonprint

jsonprint NORMAL

SQL> select json(‘[{fname:”Emad”},{lname:”al-mousa”}]’) from dual;

JSON(‘[{FNAME:”EMAD”},{LNAME:”AL-MOUSA”}]’)

——————————————————————————–

[{“fname”:”Emad”},{“lname”:”al-mousa”}]

SQL> set jsonprint pretty

SQL> show jsonprint

jsonprint PRETTY

SQL> select json(‘[{fname:”Emad”},{lname:”al-mousa”}]’) from dual;

JSON(‘[{FNAME:”EMAD”},{LNAME:”AL-MOUSA”}]’)

——————————————————————————–

[

  {

    “fname” : “Emad”

  },

  {

    “lname” : “al-mousa”

  }

]

Oracle 21c in Oracle Cloud ATP – Default Tablespace Encryption Algorithm

Tablespace encryption is very important database security feature where data at rest is encrypted for protection against any attempt of physical access to copy data file levels. Of course Oracle cloud provides security protection and encrypts tablespaces. In Oracle 21c a new security parameter feature called “ Default Tablespace Encryption Algorithm” this parameter will set the default/required encryption algorithm for newly created tablespaces…..let us briefly explore it:

The following query will list encrypted tablespaces:

SQL> select * from v$encrypted_tablespaces;

The following is the new parameter and its default value

SQL> SHOW PARAMETER TABLESPACE_ENCRYPTION_DEFAULT_ALGORITHM

its worth stating that in Oracle ATP you can’t execute create tablespace sql command: https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/appendix-restrictions-sql.html#GUID-791E7112-07F7-46F0-BD81-777C8FAD83A0