Answer Posted / swapna

select ename from emp where sal>(select avg(sal) from emp);

What is the difference between stored procedure and view?

1020

---

What is column?

996

---

How sql query is executed?

1136

---

How many triggers can be applied to a table?

1067

---

How do you add a column to a table?

1056

---

what is an alias command? : Sql dba

1118

---

What is difference between hql and native sql?

1177

---

Write a query to find the names of users that begin with "um" in sql?

999

---

Why is sharding used?

1004

---

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1119

---

What are tables and fields?

1039

---

Is there any restriction on the use of union in embedded sql?

1160

---

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1039

---

How to convert comma separated string to array in pl/sql?

1188

---

What is materialized view in sql?

925

---