Posts

Oracle 26ai: Easy Data Validation with Assertions

Image
What You Will Learn Discover the new Assertion feature in Oracle 26ai. You will learn what it is, why it helps, and how to use it in real-world scenarios.  The Problem with Check Constraints Usually, we use a CHECK constraint to restrict what data goes into a column. But this method is too rigid. For example, imagine a table with a STATUS column that only allows 'ACTIVE' or 'INACTIVE'. If you later decide to add a new status like 'DELETED', you have to manually alter the table and update the CHECK constraint. This takes time and makes maintenance harder as your app grows. The Solution: Assertions To fix this, Oracle 26ai introduces Assertions. Assertions handle validation automatically by checking your data against a lookup table. Instead of hardcoding the rules, the assertion checks the lookup table in real-time. If you add 'DELETED' to your lookup table, the assertion automatically accepts it. You never have to change your main table structure again. P...
Post a Comment
Read more

Configuring email in Oracle APEX

Image
Reason for wrote this post:     From  Mylearn Workspace  we can easily send mails without any obstacles. But in our OCI free tier account we need to do some initial setup for sending email from APEX workspace or DB. Else it will be in mail queue itself. What you will get:     Basic idea of email triggering from DB. How to configure default sender email and send test email from OCI free tier APEX workspace. Steps involved:     1.  Create user and generate SMTP credentials     2.  Getting Public end point URL     3.  Updating Instance settings in Administration     4.  Validating the configuration Create user and generate SMTP credentials In left navigation menu go to the Identity & Security tab navigate to Domain section. Under Default domain go to Users tab and Create User with required details (we can go with default user also, for the testing purpose I created new user and used it) Once th...
Post a Comment
Read more

Creating new ATP instance & Login to APEX

Image
What you will get from this post:       A complete guidance to create an Autonomous Transaction Processing database and login to the Oracle APEX. Also we'll cover how to connect Cloud DB with local SQL Developer. Steps to be followed: After successful signup process, we'll be redirected to the OCI home page From the home page left side menu go to Identity & Security tab and find Compartments . For creating ATP instance its not necessary to create a compartment. But for the formal way we should not create DB under a root directory. Under compartments tab create a new Compartment under root. Then navigate to left side panel and choose Oracle Database & click  Autonomous Transaction Processing and select the compartment which you created the above.  Click Create Autonomous Database & provide required details. Choose Always Free configuration options & network access type as Secure access from everywhere. These are steps we need to follo...
Post a Comment
Read more

OCI Free Tier Account Signup

Image
Why I'm writing this?     Many of us are unaware of this service. My colleague was hesitant to provide his credit card details because his Amazon cloud services subscription was extended without his knowledge. For Oracle Cloud Infrastructure (OCI), the credit card details are used solely for identity verification with a refundable $1 charge. No charges will occur unless the account is upgraded. When I struggled to create an OCI Free Tier Account, I decided to write an article to help others avoid similar difficulties. What will you get from this?     Complete understanding to create an OCI Free Tier Account. Pre Requisites: E-Mail Id Mobile Number Credit card or Debit card Billing address of the credit card or Debit card Account Creation:     Open OCI sign-in page in any browser or  Click Here  to navigate to that page. Click Sign Up button. Before proceeding make sure international transaction is enabled in your credit or debit card.   ...
Post a Comment
Read more