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 |
How to fix oracle error ora-00942: table or view does not exist
What is query syntax?
How to order siblings in oracle hierarchy queries?
What is out parameter used for eventhough return statement can also be used in pl/sql?
How to rename a table?
how to write date and time literals? : Sql dba
What is the difference between RDBMS and DBMS?
20 Answers Practical Viva Questions, Sapient, Stag Computers,
What is difference between CHAR and VARCHAR2?What is the maximum SIZE allowed for each type?
How can you save or place your msg in a table?
What is the different between Stored Procedure and Procedure?
what is the difference between truncate and drop statements? : Sql dba
What are the subsets of sql?