Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE items(
    name VARCHAR2(50) not null,
    variable VARCHAR2(50) not null);

INSERT INTO items VALUES
('123456789','123456');
1 rows affected

INSERT INTO items VALUES
('12345678','123457');
1 rows affected

INSERT INTO items VALUES
('12345679','123458');

1 rows affected

INSERT INTO items VALUES
('1234569','123459');
1 rows affected

INSERT INTO items VALUES
('12349','1234410');
1 rows affected

INSERT INTO items VALUES
('12344123','1234411');
1 rows affected

INSERT INTO items VALUES
('12346','1234412');
1 rows affected

INSERT INTO items VALUES
('12233','1223313');
1 rows affected

INSERT INTO items VALUES
('1223311','1223314');
1 rows affected

SELECT * FROM items WHERE SUBSTR(name,1,5)=SUBSTR(variable,1,5);



NAME
VARIABLE


123456789
123456

12345678
123457

12345679
123458

1234569
123459

12344123
1234411

12233
1223313

1223311
1223314


SELECT * FROM items WHERE name LIKE SUBSTR(variable,1,5)||'%'


NAME
VARIABLE


123456789
123456

12345678
123457

12345679
123458

1234569
123459

12344123
1234411

12233
1223313

1223311
1223314


SELECT * FROM items WHERE name LIKE '%'||SUBSTR(variable,1,5)


NAME
VARIABLE


12233
1223313


SELECT * FROM items WHERE name LIKE '%'||SUBSTR(variable,1,5)||'%'


NAME
VARIABLE


123456789
123456

12345678
123457

12345679
123458

1234569
123459

12344123
1234411

12233
1223313

1223311
1223314

NAME	VARIABLE
123456789	123456
12345678	123457
12345679	123458
1234569	123459
12344123	1234411
12233	1223313
1223311	1223314