{"id":2631,"date":"2020-11-30T22:52:56","date_gmt":"2020-12-01T04:52:56","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=2631"},"modified":"2026-02-07T15:06:35","modified_gmt":"2026-02-07T21:06:35","slug":"oracle-tidbits-november-2020-oratidbit","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2020\/2631\/","title":{"rendered":"Oracle Tidbits &#8211; November 2020 #OraTidbit"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u201c<strong>Oracle *daily* TidBits<\/strong>\u201d (#oratidbit) published on\u00a0<a rel=\"noreferrer noopener\" href=\"https:\/\/www.facebook.com\/hashtag\/oratidbit\" target=\"_blank\">Facebook &amp;<\/a><a rel=\"noreferrer noopener\" href=\"https:\/\/twitter.com\/search?q=%23oratidbit\" target=\"_blank\">Twitter,<\/a>\u00a0during weekdays in November 2020. I hope you find these helpful to learn something new or to remind you of its existence and use.<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><tbody><tr><td>#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 PL\/SQL statements. SQLcl provides inline editing, statement completion, command recall, and supports existing SQL*Plus scripts.<\/td><\/tr><tr><td>#OraTidbit #Liquibase is an open-source database-independent library for tracking, managing, and applying database schema changes. With the Liquibase feature in SQLcl, you can generate and execute single object changelogs.<\/td><\/tr><tr><td>#OraTidbit #SQLDev There are two options for working with databases other than Oracle in SQL Developer: Creating database connections so that you can view schema objects and data. Migrating these databases to Oracle to take advantage of the full range of Oracle Database features and capabilities.<\/td><\/tr><tr><td>#OraTidbit #SQLDev The SQL Developer unit testing feature provides a framework for testing PL\/SQL objects, such as functions and procedures, and monitoring such objects&#8217; results over time. You create tests, and for each, you provide information about what is to be tested and what result is expected.<\/td><\/tr><tr><td>#OraTidbit Users of #AutonomousDB can subscribe to events and get notified. An event could be a resource lifecycle state change or a system event impacting a resource. Example events are DatabaseDownBegin, DatabaseDownEnd, MaintenanceBegin, MaintenanceEnd, DatabaseConnection.<\/td><\/tr><tr><td>#OraTidbit #OracleCloud Zero Downtime Migration lets you quickly and smoothly move your Oracle databases from on-premises environments and Oracle Cloud Infrastructure Classic to the Oracle Cloud without incurring significant downtime.<\/td><\/tr><tr><td>#OraTidbit #AutonomousLinux #Linux Every system running Autonomous Linux is patched automatically. This helps keep systems secure and compliant, eliminating the risk of unpatched systems. Ksplice technology allows patching for kernel and key userspace libraries without restarting or scheduled downtime.<\/td><\/tr><tr><td>#OraTidbit #AutonomousLinux #Linux Oracle Autonomous Linux automatically tunes memory management, network algorithms, and disk I\/O based on workload, so applications run at higher performance and better reliability.<\/td><\/tr><tr><td>#OraTidbit #AutonomousDB #Azure You can use Shared Access Signatures (SAS) URL in any DBMS_CLOUD procedure that takes a URL to access files in Azure Blob Storage, without the need to create a credential. (New Feature)<\/td><\/tr><tr><td>#OraTidbit #AutonomousDB #AWS You can use a presigned URL in any DBMS_CLOUD procedure that takes a URL to access files in Amazon Simple Storage Service, without the need to create a credential. (New Feature)<\/td><\/tr><tr><td>#OraTidbit #VirtualBox Oracle VM VirtualBox supports importing of cloud instances from an Oracle Cloud Infrastructure service. When you import a cloud instance, Oracle VM VirtualBox creates and registers a new VM automatically on the localhost.<\/td><\/tr><tr><td>#OraTidbit #DB20c Starting in Oracle Database 20c, the parameter to enable or disable password file case sensitivity is removed. All passwords in new password files are case-sensitive.<\/td><\/tr><tr><td>#OraTidbit #DB20c MAX_IDLE_BLOCKER_TIME sets the number of minutes that a session holding needed resources can be idle before it is a candidate for termination. Unlike MAX_IDLE_TIME, MAX_IDLE_BLOCKER_TIME terminates resources only when they are needed.<\/td><\/tr><tr><td>#OraTidbit #DB20c Oracle ASM Flex Disk Group supports Cloning a PDB in one CDB to a new PDB in a different CDB. Previously point-in-time database clones could only clone a pluggable database (PDB) in a multitenant container database (CDB) to a new PDB in the same CDB.<\/td><\/tr><tr><td>#OraTidbit Oracle Database AutoUpgrade enables you to upgrade one or many Oracle Database instances at the command-line using a single command and a single configuration file. AutoUpgrade runs the pre-upgrade tasks, performs automated fix-ups where needed, runs the database upgrade, and finishes by completing post-upgrade tasks.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u201cOracle *daily* TidBits\u201d (#oratidbit) published on\u00a0Facebook &amp;Twitter,\u00a0during 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 &#8230; <a title=\"Oracle Tidbits &#8211; November 2020 #OraTidbit\" class=\"read-more\" href=\"https:\/\/bijoos.com\/oraclenotes\/2020\/2631\/\" aria-label=\"Read more about Oracle Tidbits &#8211; November 2020 #OraTidbit\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":2175,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[27],"tags":[58],"class_list":["post-2631","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tidbits","tag-oratidbit"],"acf":[],"jetpack-related-posts":[{"id":2197,"url":"https:\/\/bijoos.com\/oraclenotes\/2018\/2197\/","url_meta":{"origin":2631,"position":0},"title":"Oracle Tidbits &#8211; June 2018 #oratidbit","author":"biju.thomas","date":"July 1, 2018","format":false,"excerpt":"\u201cOracle *daily* TidBits\u201d (#oratidbit) published on\u00a0\u00a0Facebook,\u00a0Twitter,\u00a0and\u00a0Google+\u00a0during weekdays\u00a0in June 2018. Hope you find these helpful to learn something new or to remind you of its existence and use. #oratidbit #db18c A shared single client access name (Shared SCAN) enables the sharing of one set of SCAN virtual IPs (VIPs) and Listeners\u2026","rel":"","context":"In &quot;TidBits &amp; Quick Tips&quot;","block_context":{"text":"TidBits &amp; Quick Tips","link":"https:\/\/bijoos.com\/oraclenotes\/category\/tidbits\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/04\/oratidbit.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":2586,"url":"https:\/\/bijoos.com\/oraclenotes\/2020\/2586\/","url_meta":{"origin":2631,"position":1},"title":"Oracle Tidbits &#8211; June 2020 #OraTidbit","author":"biju.thomas","date":"June 30, 2020","format":false,"excerpt":"\u201cOracle *daily* TidBits\u201d (#oratidbit) published on\u00a0Facebook &Twitter,\u00a0during 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,\u2026","rel":"","context":"In &quot;TidBits &amp; Quick Tips&quot;","block_context":{"text":"TidBits &amp; Quick Tips","link":"https:\/\/bijoos.com\/oraclenotes\/category\/tidbits\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2167,"url":"https:\/\/bijoos.com\/oraclenotes\/2018\/2167\/","url_meta":{"origin":2631,"position":2},"title":"Oracle Tidbits &#8211; March 2018 #oratidbit","author":"biju.thomas","date":"April 1, 2018","format":false,"excerpt":"\u201cOracle *daily* TidBits\u201d (#oratidbit) published on Facebook, Twitter, and Google+\u00a0during weekdays\u00a0in March 2018. You will also see these tidbits on the right side of this blog as well\u2026 Hope you find these helpful to learn something new or to remind you of its existence and use. #oratidbit #db18c SQL*Plus Feature:\u2026","rel":"","context":"In &quot;TidBits &amp; Quick Tips&quot;","block_context":{"text":"TidBits &amp; Quick Tips","link":"https:\/\/bijoos.com\/oraclenotes\/category\/tidbits\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2374,"url":"https:\/\/bijoos.com\/oraclenotes\/2018\/2374\/","url_meta":{"origin":2631,"position":3},"title":"Oracle Tidbits &#8211; December 2018 #oratidbit","author":"biju.thomas","date":"December 31, 2018","format":false,"excerpt":"\u201cOracle *daily* TidBits\u201d (#oratidbit) published on\u00a0\u00a0Facebook,\u00a0Twitter,\u00a0and\u00a0Google+\u00a0during weekdays\u00a0in December 2018. The list is short as there were no #oratidbit during the Christmas holidays. Hope you find these helpful to learn something new or to remind you of its existence and use. HAPPY NEW YEAR 2019! #oratidbit #orcldb When you move the\u2026","rel":"","context":"In &quot;TidBits &amp; Quick Tips&quot;","block_context":{"text":"TidBits &amp; Quick Tips","link":"https:\/\/bijoos.com\/oraclenotes\/category\/tidbits\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/04\/oratidbit.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":2115,"url":"https:\/\/bijoos.com\/oraclenotes\/2017\/2115\/","url_meta":{"origin":2631,"position":4},"title":"Oracle Tidbits &#8211; October 2017 #oratidbit","author":"Biju","date":"November 2, 2017","format":false,"excerpt":"\u201cOracle *daily* TidBits\u201d (#oratidbit) published on Facebook, Twitter, and Google+\u00a0during weekdays\u00a0in October 2017. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well\u2026 Hope you find these helpful to learn something new or to remind you\u2026","rel":"","context":"In &quot;TidBits &amp; Quick Tips&quot;","block_context":{"text":"TidBits &amp; Quick Tips","link":"https:\/\/bijoos.com\/oraclenotes\/category\/tidbits\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2017\/02\/oratidbit.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":2144,"url":"https:\/\/bijoos.com\/oraclenotes\/2018\/2144\/","url_meta":{"origin":2631,"position":5},"title":"Oracle Tidbits &#8211; February 2018 #oratidbit","author":"Biju","date":"March 1, 2018","format":false,"excerpt":"\u201cOracle *daily* TidBits\u201d (#oratidbit) published on Facebook, Twitter, and Google+\u00a0during weekdays\u00a0in February 2018. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well\u2026 Hope you find these helpful to learn something new or to remind you\u2026","rel":"","context":"In &quot;TidBits &amp; Quick Tips&quot;","block_context":{"text":"TidBits &amp; Quick Tips","link":"https:\/\/bijoos.com\/oraclenotes\/category\/tidbits\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2017\/02\/oratidbit.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2018\/04\/oratidbit.jpg?fit=273%2C91&ssl=1","_links":{"self":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2631","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/comments?post=2631"}],"version-history":[{"count":2,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2631\/revisions"}],"predecessor-version":[{"id":2633,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/2631\/revisions\/2633"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media\/2175"}],"wp:attachment":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media?parent=2631"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=2631"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=2631"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}