SELECT TO_CHAR (2014 + LEVEL) year, TO_CHAR (2014 + LEVEL) AS YEARS
FROM DUAL
CONNECT BY LEVEL <= 50
ORDER BY 1 DESC
বুধবার, ২৯ মে, ২০২৪
Days between two parameter dates
SELECT :pSDATE + LEVEL - 1 dt
FROM DUAL
CONNECT BY LEVEL <= ( :pEDATE - :pSDATE + 1);
সোমবার, ২৭ মে, ২০২৪
Date difference to hour minute (Duty time calculation)
CREATE OR REPLACE FUNCTION DF_DATE_DIFF_TO_HOUR_MIN (pSDATE DATE,
pEDATE DATE)
RETURN VARCHAR2
AS
vHOUR_MIN VARCHAR2 (200);
BEGIN
SELECT NVL(TO_CHAR (TRUNC (Seconds_ / (60 * 60)), 'FM9900'),0)
|| ':'
|| NVL(TRUNC (MOD (Seconds_, 60 * 60) / 60),0)
|| ':'
|| NVL(TRUNC(MOD (Seconds_, 60),2),0) INTO vHOUR_MIN
FROM (SELECT (pEDATE - (pSDATE - 0 / 24)) * 24 * 60 * 60 AS Seconds_
FROM DUAL);
RETURN vHOUR_MIN;
END;
SELECT DF_DATE_DIFF_TO_HOUR_MIN(:pSDATE, :pEDATE) FROM DUAL;
রবিবার, ১৯ মে, ২০২৪
To Resolve connected to idle instance
1. Connect the DB sqlplus / as sysdba
2. startup nomount
3. alter database mount;
4. Clear an unarchived redo logs
alter database clear unarchived logfile group 1;
alter database clear unarchived logfile group 2;
alter database clear unarchived logfile group 3;
5. shutdown immediate
6.startup
alter session set container=pdbdbname;
এতে সদস্যতা:
পোস্টগুলি (Atom)