Answer Posted / kiran

select count(*) "NoFDevelopers",to_char(hiredate,'Mon') from emp group by to_char(hiredate,'Mon');

What are the advantages of pl sql over sql?

539

---

What are sql ddl commands?

539

---

Mention what is the plv (pl/vision) package offers?

634

---

How do I count rows in sql query?

487

---

what is the difference between a local and a global temporary table? : Sql dba

547

---

---

what are the t string functions available in tsql? : Transact sql

536

---

what is the difference between sql and t-sql? : Transact sql

592

---

What program will open a mdb file?

491

---

how to show all tables with 'mysql'? : Sql dba

597

---

How to add new employee details in an employee_details table with the following details

641

---

How do you optimize a stored procedure query?

561

---

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

548

---

What is the difference between function, procedure and package in pl/sql?

556

---

What is a table?

563

---

What is the difference between python and sql?

517

---