what are the advantages of using stored procedures? : Sql dba

0 Answers  

---

Can we call procedure in select statement?

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,

---

Explain the difference between rename and alias?

0 Answers  

---

What are the two different parts of the pl/sql packages?

0 Answers  

---

---

Which language is used in sql?

0 Answers  

---

How to start the command-line sql*plus?

0 Answers  

---

Name three sql operations that perform a sort.

0 Answers  

---

Name the operator which is used in the query for pattern matching?

0 Answers  

---

How to call shell script from pl sql procedure?

0 Answers  

---

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

0 Answers  

---

how to find the First and Last Observation from the table: Ex: OBS Name Sal Ans like: OBS Name Sal 105 E 5000--> 105 E 5000 102 B 2000 104 D 4000 103 C 3000 101 A 1000--> 104 D 4000

4 Answers  

---