Hi,
I have a query taking lot of time.
I have the query. Using cloudcontrol, I can "see" and "export" bind variables.
When exporting, cloudControl creates a file holding:
-- ============================================================================================== --
-- This file is generated by EM Database Express. --
-- The SQL bind variables, if any, will be declared below. --
-- ============================================================================================== --
declare
P0 TIMESTAMP := 787703080F051F; -- HEXDUMP
P1 TIMESTAMP := 787703080F051F; -- HEXDUMP
P2 TIMESTAMP := 787703080F051F; -- HEXDUMP
begin
-- SELECT ... WHERE (this_.ModifiedAt >= :p0 ....
end;
/
Problem: how can I see what is the date value of hexdump 787703080F051F?
Even running the file, assigning the value gives a problem.
Kind regards.