The NVL function evaluates a column or an expression this way:
- If it’s not NULL, it returns the evaluated value.
- If it’s NULL, it returns the indicated value in the second parameter of NVL.
Category: Oracle
Tablespace size of an Oracle Database
How can I know the size of my Oracle Database? What is the size of the Tablespaces in an Oracle Database?
An Oracle database stores the data in logical units called Tablespaces. Therefore, to know the size of the whole instance you need to know the size of each tablespace. Continue reading “Tablespace size of an Oracle Database”