2020 – The year we wish to forget!

2020 was a unique year, with a lot of new normal. Among the new normal is how conferences and work is being done. The new normal of “online” conferences helped many of us participate in various conferences worldwide. Though I could not travel after the London Oracle Open World in February, I was fortunate to … Read more

Oracle Tidbits – November 2020 #OraTidbit

“Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in November 2020. I hope you find these helpful to learn something new or to remind you of its existence and use. #OraTidbit #SQLcl Oracle SQLcl (SQL Developer Command-Line) is a Java-based command-line interface for Oracle Database. Using SQLcl, you can interactively or batch execute SQL and … Read more

Oracle Tidbits – October 2020 #OraTidbit

Happy Halloween! “Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in October 2020. I hope you find these helpful to learn something new or to remind you of its existence and use. #OraTidbit #AutonomousDB The default operation mode of Autonomous Database is Read/Write. If you select Read-Only mode users can only run queries. You can … Read more

Oracle Tidbits: September 2020 #OraTidbit

“Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in September 2020. I hope you find these helpful to learn something new or to remind you of its existence and use. #OraTidbit #OracleCloud #AutonomousDB Sep 2020 #New: Refreshable clone of Autonomous DB. With a refreshable clone, the system creates a clone that can be easily updated … Read more

Oracle Tidbits – August 2020 #OraTidbit

“Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in August 2020. I hope you find these helpful to learn something new or to remind you of its existence and use. #OraTidbit #OrclDB When gathering optimizer statistics manually, you can reproduce the object prioritization of automatic collection by using the DBMS_AUTO_TASK_IMMEDIATE package. This package runs the … Read more

Oracle TidBits – July 2020 #OraTidBit

“Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in July 2020. I hope you find these helpful to learn something new or to remind you of its existence and use. #OrclDB #db20c Starting in Oracle Database 20c, the parameter to enable or disable password file case sensitivity is removed. All passwords in 20c password files … Read more

Oracle Tidbits – June 2020 #OraTidbit

“Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in June 2020. I hope you find these helpful to learn something new or to remind you of its existence and use. #OraTidbit You can pre-format SQL query output in #SQLDev and #SQLcl using SET SQLFORMAT. The options are csv, html, xml, json, ansiconsole, insert, loader, fixed, … Read more