How do you optimize a stored procedure in sql?

0 Answers  

---

How many sectors are in a partition?

0 Answers  

---

how would you enter characters as hex numbers? : Sql dba

0 Answers  

---

ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.

2 Answers  

---

what is the difference between clustered and non clustered index in sql? : Sql dba

0 Answers  

---

Does access use sql?

0 Answers  

---

What is pl/sql table? Why is it used?

0 Answers  

---

what are the advantages of cursors than procedures?

2 Answers  

---

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????

8 Answers   rsystems,

---

What is data control language (dcl)?

0 Answers  

---

What are the two parts of design view?

0 Answers  

---

What are the uses of sysdate and user keywords?

0 Answers  

---