Answer Posted / shipra

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

What is a trigger word?

961

---

What are the properties of a transaction?

1072

---

What is Difference Between Unique and Primary Key Constraints?

1058

---

What do you understand by exception handling in pl/sql?

961

---

what is bcp? When does it used? : Sql dba

933

---

how many ways to get the current time? : Sql dba

948

---

What is update query?

920

---

Are pl sql variables case sensitive?

997

---

How to use sql*plus built-in timers?

1094

---

What is sql and also describe types of sql statements?

994

---

what is a relationship and what are they? : Sql dba

1024

---

what is the difference between truncate and drop statements? : Sql dba

1033

---

Are stored procedures faster than dynamic sql?

980

---

Does mysql_real_escape_string prevent sql injection?

907

---

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1124

---