Answer / shipra

select rownum seq
, name
, age
from ( select name
, age
from your_table
order by name
)

Answer / naresh

by using nvl function

Explain the methods used to protect source code of pl/sql.

0 Answers  

---

Why we use joins in sql?

0 Answers  

---

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

4 Answers  

---

Why does %isopen return false for an implicit cursor?

1 Answers  

---

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

0 Answers  

---

How can triggers be used for the table auditing?

0 Answers  

---

what are all types of user defined functions? : Sql dba

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  

---

What is numeric function sql?

0 Answers  

---

How do I order columns in sql?

0 Answers  

---

What are the advantages of sql? Explain

0 Answers  

---

how to select unique records from a table? : Sql dba

0 Answers  

---