Welcome to Radu Parvu’s site on tech and news of the world!

Italy Availability for Oracle Database@Azure

Oracle

  • Italy Availability for Oracle Database@Azure

    Italy Availability for Oracle Database@Azure

    Learn what Azure and OCI regions support Oracle Database@Azure, and how to find availability zone mapping for Azure regions. — Read on docs.oracle.com/en-us/iaas/Content/database-at-azure/oaa_regions.htm

  • Top Factors for Oracle Database Migration Success

    Top Factors for Oracle Database Migration Success

    To migrate Oracle database instances to Oracle Database on Azure, key criteria include database size, workload characteristics, version compatibility, application dependencies, performance requirements, high availability, security compliance, current infrastructure, customization complexity, migration strategy feasibility, backup procedures, and cost implications. Assessing these ensures effective migration planning.

  • Oracle Database: Constraints Tutorial

    Oracle Database: Constraints Tutorial

    This article compiles various queries and code blocks used to manage disabled constraints in a database schema. It includes SQL statements to identify and enable these constraints. The content will be updated regularly with new insights, and it lists the tested database versions, starting with Oracle Database 23ai.

  • Ensuring PL/SQL Code Integrity with Checksums

    Ensuring PL/SQL Code Integrity with Checksums

    The content explains how to implement a checksum for PL/SQL procedures to detect unauthorized modifications. It details steps for generating a checksum using Oracle’s DBMS_CRYPTO, storing it for future verification, and comparing it against current values. This approach helps ensure the integrity of PL/SQL procedures over time.

  • Setting up Oracle Base Database Service on OCI

    Setting up Oracle Base Database Service on OCI

    Oracle Base Database service is a for pay offering on OCI but it is quite reasonably priced and suitable for setting up test environments. Still the setup is relatively complex and the scope of this article is the out line the main steps used. Setup the Network Decide the compartment to be used. In my…

  • SQLcl: Setup on a Mac

    SQLcl: Setup on a Mac

    Simple and straightforward steps about how to setup Oracle’s new SQL command line tool on a macOS X environment. Download Application and Environment Setup Attempt to start the application: Setup Java Download Java from the Oracle site. As I am on a mac wit M processor (ARM) , I cannot install jre-8u371-macosx-x64.dmg, so I cannot…

  • ALTER TABLE [TBU]

    TBU …

  • SELECT [TBU]

    TBU

  • Comparing Oracle Databases: Initialization Parameters

    Comparing Oracle Databases: Initialization Parameters

    A method for comparing the Oracle init parameters of several PDB’s

  • Overview: SELECT SAMPLE

    Overview: SELECT SAMPLE

    One feature that many developers and data analysts are not aware of is the SAMPLE function in Oracle. It is quite an old feature (not sure exactly when it was added). Below is a simple example of how it works.

  • Oracle Instant Client for macOS

    Oracle Instant Client for macOS

    Oracle does not release anymore full client packages for the Mac clients. Therefore, we need to use the Instant Client from: