What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

2 Answers  

---

what are tables and fields? : Sql dba

0 Answers  

---

Explain the rollback statement?

0 Answers  

---

create a store procedure and created synonms for that store procedure after modify that store procedure will effect on synonms? If we delete the store procedure what happened to that synonms?

2 Answers   Polaris,

---

What is data definition language?

0 Answers  

---

Is left join faster than inner join?

0 Answers  

---

Is sqlite free?

0 Answers  

---

What are different types of tables in sql?

0 Answers  

---

What is cte?

0 Answers  

---

declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?

7 Answers   Oracle,

---

What are the sql commands?

0 Answers  

---

What is query optimization in sql?

0 Answers  

---