Answer Posted / 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;

What is a pragma statement?

1262

---

What is assignment operator in pl sql?

1038

---

explain commit and rollback in mysql : sql dba

1020

---

How to get list of all tables from a database?

1160

---

What are the various restrictions imposed on view in terms of dml?

966

---

What is raw datatype in sql?

1045

---

How does sql*loader handles newline characters in a record? : aql loader

1046

---

what is a materialized view? : Sql dba

1062

---

Explain about various levels of constraint.

949

---

What is pl sql record in oracle?

1035

---

How to display the current date in sql?

1078

---

Can we enter data in a table in design view?

969

---

what is the difference between join and union? : Sql dba

1113

---

Why commit is not used in triggers?

1040

---

What is a sql schema used for?

1105

---