create table sales
2 (
3 sales_id number,
4 cust_id number,
5 sales_amt number,
6 sale_category varchar2(6)
7 generated always as
8 (
9 case
10 when sales_amt <= 10000 then ‘LOW’
11 when sales_amt > 10000 and sales_amt <= 100000 then ‘MEDIUM’
12 when sales_amt > 100000 and sales_amt <= 1000000 then ‘HIGH’
13 else ‘ULTRA’
14 end
15 ) virtual
16 );

SQL> insert into sales (sales_id, cust_id, sales_amt) values (1,1,100);

1 row created.

SQL> insert into sales (sales_id, cust_id, sales_amt) values (2,102,1500);

1 row created.

SQL>insert into sales (sales_id, cust_id, sales_amt) values (3,102,100000);

1 row created.

SQL> commit;

Commit complete.

SQL> select * from sales;

SALES_ID CUST_ID SALES_AMT SALE_C

1 1 100 LOW
2 102 1500 LOW
3 102 100000 MEDIUM