by Choma | May 20, 2018 | Uncategorized
To blow away one of your newly created databases, instead of using the DBCA, try it manually in sqlplus. Requirements database must be closed, exclusively mounted, restricted 1- Start The database sqlplus / as sysdba SQL> startup ORACLE instance started. Total...
by mawundaga | May 1, 2018 | Uncategorized
Oracle introduced the long-awaited Database 12c Release 2 earlier this year at Oracle Open World. SQL and PL/SQL: Starting with Oracle Database 12c Release 2 (12.2), we can truncate the return string of LISTAGG function, to fit within the maximum length supported for...
Recent Comments