Answer Posted / jini

you have to write a query like this to replace the
tablename and column name

select &ename,&sal
from &emp

but make sure emp is a table and ename,sal are columns

What is pivot query?

828

---

Why is %isopen always false for an implicit cursor?

767

---

How do you remove duplicate records from a table?

675

---

Can we perform dml in function?

796

---

What are sql data types?

744

---

---

What is a null value?

849

---

What is a clob in sql?

728

---

Is t sql a programming language?

761

---

What are the usages of sql?

752

---

describe mysql connection using mysql binary. : Sql dba

754

---

how to dump a table to a file with 'mysqldump'? : Sql dba

739

---

The in operator may be used if you know the exact value you want to return for at least one of the columns.

726

---

What is the difference between execution of triggers and stored procedures?

748

---

how to use regular expression in pattern match conditions? : Sql dba

730

---

What are the two types of periodical indexes?

662

---