Answer Posted / murali

select level,max(sal) from emp where level=&levelno connect by prior sal>sal group by level;

what is foreign key? : Sql dba

585

---

Is there a way to automate sql execution from the command-line, batch job or shell script?

555

---

what is sql server agent? : Sql dba

599

---

Explain table and field in sql?

581

---

What are system versioned tables?

549

---

---

What is the requirement of self-join?

540

---

explain advantages of myisam over innodb? : Sql dba

595

---

Is sqlite good enough for production?

531

---

What is a recursive join sql?

593

---

How many indexes can be created on a table in sql?

494

---

What are the rules to be applied to nulls whilst doing comparisons?

750

---

What is set serveroutput on?

642

---

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

804

---

What is a pdo connection?

512

---

What are the packages in pl sql?

569

---