What is mutating sql table?

0 Answers  

---

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

1 Answers  

---

can a stored procedure call itself or recursive stored procedure? : Sql dba

0 Answers  

---

what is the sql query to display current date? : Sql dba

1 Answers  

---

What is pl sql block in dbms?

0 Answers  

---

I have a procedure in a procedure. The inner procedure contains out parameter. How I can call the inner procedure in the out procedure and send the inner procedure parameter value(out parameter value) into out procedure?

2 Answers  

---

Is sqlite good enough for production?

0 Answers  

---

What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no difference. 2. A PRIMARY KEY cannot be declared on multiple columns. 3. A UNIQUE CONSTRAINT cannot be declared on multiple columns. 4. A table can have multiple PRIMARY KEYS but only one UNIQUE CONSTRAINT. 5. A table can have multiple UNIQUE CONSTRAINTs but only one PRIMARY KEY.

7 Answers   Satyam,

---

Can you join a table to itself?

0 Answers  

---

How do temporal tables work?

0 Answers  

---

Mention what does plv msg allows you to do?

0 Answers  

---

What are the two types of exceptions in pl/sql?

0 Answers  

---