Hello, You can find time difference between two times by using to_char and to_date sql functions. Use to_char(sysdate, ‘sssss’) in order to calculate seconds from midnight.
select to_char(sysdate, 'sssss') from dual;
TO_CHAR(SYSDATE,’SSSSS’) ———————— 42881 1 row selected. We can also convert seconds to time with…
Hello, Converting physical files into binary data type is an important requirement. In this tutorial, I am going to explain converting files into blob data type. Basically, Oracle has two large object data types. BLOB (Binary Large Object): Used for keeping…
Hello, You can use the following sql script in order to find profile values
SELECT fpo.profile_option_name profil_adi,
FROM fnd_profile_options fpo,
WHERE fpo.profile_option_name = fpl.profile_option_name
AND fpo.profile_option_id = fpv.profile_option_id
AND fpv.level_value = fu.user_id(+)
AND fpv.level_value = frt.responsibility_id(+)
AND fpv.level_value = fa.application_id(+)
AND fpl.user_profile_option_name =
'<User Profile Option Name'
Hello, During extension developments for OAF pages, sometimes we need extra fields which are not available in standard view object. In this kind of situations, we are creating a new view object and make it extend standard view object. Please follow carefully…
Hello, In my previous tutorial, I did an example about Java Concurrent Program with External Jars. In this tutorial, I will develop a simple java application which generates an Excel(xlsx) file and run it as a shell concurrent program in Oracle…