Oracle EBS Service Invocation Framework (Business Events – SIF)
In this tutorial, I am going to invoke an external test web service with SIF. SIF mechanism is based on events, therefore we are going to define business events and subscriptions. After that, we can raise events in pl/sql. You…
Time Difference in Oracle SQL
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.
|
1 2 3 |
select to_char(sysdate, 'sssss') from dual; |
TO_CHAR(SYSDATE,’SSSSS’) ———————— 42881 1 row selected. We can also convert seconds to time with…
PL/SQL File to Blob
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…
List of Days between two dates in Oracle SQL
Hello, You can use the following SQL Script in order to fetch list of days between two dates.
|
1 2 3 4 5 |
SELECT to_date('01.01.2014', 'dd.mm.rrrr') + LEVEL - 1, LEVEL FROM DUAL CONNECT BY LEVEL <= to_date('15.01.2014', 'dd.mm.rrrr') + 1 - to_date('01.01.2014', 'dd.mm.rrrr'); |
Result;
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
TO_DATE('01.01.2014','DD.MM.RRRR')+LEVEL-1 LEVEL ------------------------------------------ ---------- 01/01/2014 1 02/01/2014 2 03/01/2014 3 04/01/2014 4 05/01/2014 5 06/01/2014 6 07/01/2014 7 08/01/2014 8 09/01/2014 9 10/01/2014 10 11/01/2014 11 12/01/2014 12 13/01/2014 13 14/01/2014 14 15/01/2014 15 15 rows selected. |
Oracle Global Temporary Tables
Hello, In this tutorial, Oracle Global Temp Tables will be covered. Temporary Tables keep data as private for the session that created it. Data will be kept until SESSION or TRANSACTION ends. The usage need for temp tables is not…