Can we use joins in subquery?

0 Answers  

---

Can we alter stored procedure?

0 Answers  

---

What does pragma mean?

0 Answers  

---

what is the difference between delete and truncate commands? : Sql dba

0 Answers  

---

Why do we need sharding?

0 Answers  

---

What is a behavioral trigger?

0 Answers  

---

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

0 Answers   Microsoft,

---

What are wait events. Describe the wait event tables.

1 Answers   CTS,

---

What is restrict in sql?

0 Answers  

---

What is the difference between join and union.

27 Answers   3i Infotech, ABC, Oracle, Polaris, TCS, XT Global,

---

can we delete the trigger in a view? if yes why if not why?

5 Answers   Tech Mahindra,

---

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 Answers   Oracle, TCS,

---