by mawundaga | Nov 1, 2020 | Uncategorized
This is an example of annotation, hover the highlighted “annotation” word to see it in action!If you find the plugin useful, I would love to get a review or rating: https://wordpress.org/support/view/plugin-reviews/tinymce-annotateAlso, any donation would...
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...
by Choma | Jan 23, 2018 | Uncategorized
What is DB_UNIQUE_NAME? DB_UNIQUE_NAME specifies a globally unique name for the database. Databases with the same DB_NAME within the same DB_DOMAIN (for example, copies of a database created for reporting or a physical standby) must have a unique DB_UNIQUE_NAME. Every...
by Choma | Jan 18, 2018 | Uncategorized
Trigger To Log Multiple DDL Activities Setup Database Triggers for Schema Auditing and Logon/Logoff Events In order to effectively audit schema changes, and logon and logoff events, Oracle provides DDL triggers to audit all schema changes and can report the exact...
by Choma | Jan 18, 2018 | Uncategorized
1. What are the types of Oracle Data Guard? Oracle Data Guard is classified in to two types based on way of creation and method used for Redo Apply. They are as follows. 1.Physical standby (Redo Apply technology) 2.Logical standby (SQL Apply Technology) 2. What are...
Recent Comments