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 pls integer?

1054

---

Cite the differences between execution of triggers and stored procedures?

1091

---

Why cross join is used?

1085

---

What are sql data types?

1037

---

Why we use joins in sql?

987

---

what is single byte over head in oracle..?

2412

---

What is compound trigger?

1048

---

Can there be more than one function with a similar name in a pl/sql block?

998

---

what is a constraint? : Sql dba

1186

---

What are types of exception?

924

---

How do you optimize a stored procedure in sql?

970

---

What are the different operators available in sql?

1014

---

What is flag in sql?

1045

---

Mention what pl/sql package consists of?

1008

---

What is bitemporal narrowing?

1317

---