Oracle 11g Release 2

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

create table employees(id int);
select * from employees;
select SQL_ID, HASH_VALUE, PLAN_HASH_VALUE from v$sql where sql_text like 'select * from %mployees';


SQL_ID
HASH_VALUE
PLAN_HASH_VALUE


f34thrbt8rjt5
4069246757
1445457117


select * from Employees;
select SQL_ID, HASH_VALUE, PLAN_HASH_VALUE from v$sql where sql_text like 'select * from %mployees';


SQL_ID
HASH_VALUE
PLAN_HASH_VALUE


f34thrbt8rjt5
4069246757
1445457117

bvgw7mnuubskb
900063819
1445457117

SQL_ID	HASH_VALUE	PLAN_HASH_VALUE
f34thrbt8rjt5	4069246757	1445457117
bvgw7mnuubskb	900063819	1445457117