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;

Which is faster joins or subqueries?

936

---

What are the different types of dbms?

965

---

What are the types of optimization?

895

---

State few characteristics of pl/sql?

938

---

How do I find duplicates in sql?

888

---

Explain what is a field in a database and record in a database?

1028

---

What is difference between sql function and stored procedure?

952

---

What is a trigger word?

974

---

What are the types of keys?

942

---

What is sql*loader and what is it used for?

1059

---

Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

2498

---

What is the function that is used to transfer a pl/sql table log to a database table?

964

---

What are schema-level triggers?

1054

---

Is oracel sql developer written in java?

1068

---

What is a database? Explain

1060

---