23ai
-
Oracle SQL: DELETE … RETURNING: Efficient Data Removal with Immediate Feedback
The article discusses the Oracle Database feature “DELETE … RETURNING,” which allows for the deletion of rows while simultaneously retrieving data from those rows. This simplifies operations, reduces network round-trips, and enhances performance. It highlights Oracle’s advanced capabilities, making it invaluable for efficient data manipulation and maintaining records in enterprise systems.
-
Control DDL Commands in Oracle Databases
This article discusses implementing a database-level trigger to manage and restrict DDL operations by limiting access to specific users. Unauthorized users attempting DDL actions will encounter a custom error message. The trigger code is provided, along with examples of error stacks generated from prohibited actions such as adding a column or truncating a table. This…
-
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.
-
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…