How to display all Friday's in a year with date?
Answers were Sorted based on User's Feedback
Answer / dinesh
DECLARE
c date:='01-JAN-15';
d date:='31-DEC-15';
a number(10);
BEGIN
a:=d-c;
FOR i in 1..a
LOOP
IF to_char(c,'DY')='FRI' THEN
DBMS_OUTPUT.PUT_LINE('THIS IS FRIDAY DATE:='|| ' '|| c);
END IF;
c:=c+1;
END loop;
END;
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / dinesh
CREATE OR REPLACE PROCEDURE display_day_date(c date,d date,v varchar2) IS
a number(10);
m date:=c;
BEGIN
a:=d-m;
FOR i in 1..a
LOOP
IF to_char(m,'DY')= v THEN
DBMS_OUTPUT.PUT_LINE('THIS IS'||' '|| v ||' ' || 'DATE for the year '||' '||to_char(m,'yyyy')|| ' '|| m);
END IF;
m:=m+1;
END loop;
END;
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / nihar meher
declare
a date;
b date;
c number(15);
begin
select trunc(sysdate,'yyyy') into a from dual;
select add_months(trunc(sysdate,'yyyy'),12)-1 into b from dual;
c:=b-a;
for i in 1..c
loop
if to_char(a,'dy')='fri'
then
dbms_output.put_line(a);
end if;
a:=a+1;
end loop;
end;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kuldeep
select * from
(
SELECT (TRUNC (SYSDATE, 'yyyy') + LEVEL - 1) dt,
TRIM(TO_CHAR ((TRUNC (SYSDATE, 'yyyy') + LEVEL - 1), 'Day')) dy
FROM DUAL
CONNECT BY LEVEL <= 365
)
where dy='Friday'
Is This Answer Correct ? | 0 Yes | 0 No |
What is varchar example?
What are stored procedures in mysql?
what is outer join? what is selef join? what is difference between them? what is cartecion join?
1 Answers Fiserv, Herbinger, Synechron,
What is recursive join in sql?
What are the difference between Functions/Stored Procs and Triggers and where are they used.
what is the purpose of update command in oracle?
How many unique keys can a table have?
Why use truncate instead of delete?
How to export the table data (this table having 18 million records) to .csv file. Please tell me is there any faster way to export the data.
what is 'force view'?
Give the structure of the procedure ?
What is the difference between instead of trigger and after trigger?