Answer Posted / kaveesh

select sysdate from dual; It works in ORACLe 10g.
Kaveesh

How to Insert multiple rows with a single insert statement?

744

---

What are sp_configure commands and set commands?

721

---

What are different types of roles provided by ssrs?

128

---

Can you move the resources after pausing the node? : sql server database administration

770

---

How to transfer a table from one schema to another?

742

---

---

how to avoid cursors? : Sql server database administration

652

---

What is ddl command?

701

---

Is sql different from sql server?

691

---

What happens if the update subquery returns no rows in ms sql server?

790

---

What is rs.exe utility?

138

---

What are drillthrough reports?

128

---

Explain activity monitors

799

---

You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

714

---

What are the dis_advantages of stored procedures, triggers, indexes?

1924

---

What are ddl (data definition language) statements for tables in ms sql server?

749

---