Answer Posted / bibhu

select new_no as new_noz
from t01
union
select old_no as new_noz
from t01
order by new_noz

What is mutating error in pl sql?

1002

---

What are the three pl sql block types?

987

---

What is the function that is used to transfer a pl/sql table log to a database table?

988

---

what is 'mysqlimport'? : Sql dba

1018

---

What is where clause in sql?

1020

---

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1056

---

Explain the purpose of %type and %rowtype data types with the example?

973

---

What is a table partition?

1106

---

What is a recursive join sql?

1051

---

What are the operators in sql?

1002

---

what is the difference between blob and text? : Sql dba

1002

---

What is union?

1137

---

What is difference between sql and oracle?

1098

---

What if we write return in procedure?

1400

---

what is the bond code in materialized view?

2983

---