Search Result

zaffer · Oct 19 '11, 09:18 AM

Code:

SELECT trunc(sysdate) dt, count(*) as count
FROM ATM_MONITOR.ATM_PROBLEM
WHERE trunc(sysdate) = trunc(create_time)
union
SELECT trunc(sysdate)-1 dt, count(*) as count
FROM ATM_MONITOR.ATM_PROBLEM
WHERE trunc(sysdate)-1 = trunc(create_time)
union
SELECT trunc(sysdate)-2 dt, count(*) as count
FROM ATM_MONITOR.ATM_PROBLEM
WHERE trunc(sysdate)-2 = trunc(create_time)

...

S Kajim · Oct 26 '10, 04:19 PM

Hi there,

I need to calculate leap year days between two dates in PL/SQL. Will someone be able to help?

Jerico1313 · May 14 '09, 04:14 PM

I am returning the following error when i try to pass an oracle generated GUID through an out parameter. Here is the following error message from SQL+ worksheet:

BEGIN Project.spm_Dat aInsertTest ( ' ', :out_PPLorgGUID , :out_SubNo); END;

*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 1

Below is the Test Stored Procedure...

0301102 · Jan 3 '09, 10:12 AM

Hi,

I have a input parameter call DOMAIN_NAME (Example: seng.com.my), and i need slipt it into 2 word, becasue "seng" is the label and ".com.my" is the zone,
so my i know how to slpit it into two word? Or any one have a better idea to solve the mentioned problem? Your help will be appreciated. Thx.

Thanks & Regards
seng

Search Result

PL/SQL return count for all dates

Calculate leap year days between two dates

Returning an Oracle generated GUID through an out parameter

slipt a string into 2 word in Oracle PL?SQL