what are all the common sql function? : Sql dba

0 Answers  

---

How do I view stored procedures?

0 Answers  

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

1 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 the difference between nvl function, ifnull function, and isnull function?

0 Answers  

---

---

Mention what is the plv (pl/vision) package offers?

0 Answers  

---

How to Declare Fixed Length String Value In PL SQL

0 Answers  

---

What is a table in a database?

0 Answers  

---

While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?

8 Answers   iFlex,

---

how to get enames with comma seperated values by deptwise on emp table?

8 Answers  

---

IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF SELECT * FROM EMP,DEPT;

1 Answers  

---

What is a mutating table

5 Answers   TCS, Tech Mahindra,

---