List the differences between plsql - function & procedures

2 Answers   TCS, Verizon,

---

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,

---

What are types of indexes in sql?

0 Answers  

---

How to assign sql query results to pl sql variables?

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  

---

Explain the rollback statement?

0 Answers  

---

Why do we create stored procedures & functions in pl/sql and how are they different?

0 Answers  

---

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

0 Answers  

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

0 Answers  

---

what are the differences among rownum, rank and dense_rank? : Sql dba

0 Answers  

---

how to get a list of all tables in a database? : Sql dba

0 Answers  

---

How do you display "13th of November, 17 days left for month end" without hardcoding the date.

3 Answers  

---