If I have an object implementing the Map interface in Java and I wish to iterate over every pair contained within it, what is the most efficient way of going through the map? Will the ordering of elements depend on the ...
Question
Oraask Latest Questions
Question
[code] create table test_date (creation_date date); [/code] [code] Insert into test_date (CREATION_DATE) Values (TO_DATE('07/14/2017 14:45:10', 'MM/DD/YYYY HH24:MI:SS')); COMMIT; [/code] --My code [code] select * from test_date where TO_CHAR(creation_date,'DD-MON-YY') = NVL(TO_CHAR (TO_DATE (:pv_date, 'YYYY-MM-DD HH24:MI:SS'), 'DD-MON-YY'), TO_CHAR(creation_date,'DD-MON-YY')); [/code] I am comparing dates in my code using the fnd_standard_date valueset. But it is not fetching data. I am passing pv_date ...
Question
Hello, Which of these queries is the do better performance NOT IN vs NOT EXISTS? and please give me an clear example if possible. thanks