Answer Posted / sanket.infy

select * from table t1 where rownum = 5 ;

Can we use pl sql in mysql?

708

---

How can I change database name in sql?

698

---

What is posting?

775

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

722

---

Is sql injection illegal?

769

---

---

How do I copy a table in sql?

688

---

How do I pipe the output of one isql to another?

719

---

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

931

---

What are the types of optimization?

684

---

Explain commit, rollback and savepoint.

764

---

What is a design view?

699

---

what is the functionality of the function htmlentities? : Sql dba

691

---

what are dynamic queries in t-sql? : Transact sql

737

---

What is union, minus and interact commands?

933

---

Can we rename a column in the output of sql query?

721

---