declare
type location_record_type is record
(
street_address varchar2(40),
postal_code varchar2(12),
city varchar2(30),
state_province varchar2(25),
country_id char(2) not null := 'US'
);
--Use Oracle 18c Qualified Expression:
v_location location_record_type :=
location_record_type('1234 Fake Street', '90210', 'Springfield', 'KY' /*use default country_id*/);
begin
dbms_output.put_line('It worked!');
end;
Statement processed.
It worked!