Why do we need pl sql?

0 Answers  

---

What is nosql vs sql?

0 Answers  

---

How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for example emp id =5, repeated in two times in rows same id how to delete same empid please any one of the write query send in my id

8 Answers   CGCI,

---

When is a declare statement required?

0 Answers  

---

What schema means?

0 Answers  

---

---

List the various privileges that a user can grant to another user?

0 Answers  

---

Name the different types of indexes in sql and define them.

0 Answers  

---

How do I run a sql script?

0 Answers  

---

How to fetch records from a partitioned table?

2 Answers   HSBC,

---

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as NN,NN,NN,NE,NN,NN,NE,CE, Its some urgent requirement ,thanks in advance

6 Answers  

---

How do I count duplicates in sql?

0 Answers  

---

Can we alter stored procedure?

0 Answers  

---