Content Comparison

-- Oracle DDL Script
-- Converted from SQL Server by ChatGPT
-- Ebiexperts 2024-03-08 JPG (Oracle Version)

-- Drop table if exists
BEGIN
  EXECUTE IMMEDIATE 'DROP TABLE SAM_ExtRules CASCADE CONSTRAINTS';
EXCEPTION
  WHEN OTHERS THEN
    IF SQLCODE != -942 THEN
      RAISE;
    END IF;
END;
/

-- Create table
CREATE TABLE SAM_ExtRules (
  RuleId NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY PRIMARY KEY,
  AppName NVARCHAR2(255) NOT NULL,
  ActorName NVARCHAR2(255) NOT NULL,
  FullName NVARCHAR2(255) DEFAULT NULL,
  SaACCESS NVARCHAR2(10) DEFAULT 'USER' NOT NULL,
  SaOMIT NVARCHAR2(255) DEFAULT NULL,
  SaRESTRICT CLOB DEFAULT NULL,
  CreateDate TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  ModifDate TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Create index
CREATE INDEX SAM_ExtRules_AppName_IDX ON SAM_ExtRules (AppName, ActorName);

-- Trigger to update ModifDate
CREATE OR REPLACE TRIGGER trgAfterUpdate
BEFORE UPDATE ON SAM_ExtRules
FOR EACH ROW
BEGIN
  :NEW.ModifDate := CURRENT_TIMESTAMP;
END;
/