Answer / sumit

No function can be called from a sql query if the function
has dml statements inside.

Answer / venu

We can call a function in sql query if we declare function
as PRAGMA AUTONOMOUS TRANSACTION.

how many no of table can be join in a sql query.

4 Answers  

---

Write a query to find five highest salaries from EMP table. (there is a column SALARY)

24 Answers   Cap Gemini, iNautix,

---

Is pl sql and postgresql same?

0 Answers  

---

Can we enter data in a table in design view?

0 Answers  

---

a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

1 Answers   CGI,

---

---

If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.

4 Answers   Saama Tech, TCS,

---

write a query to display diference between two dates in sql server

2 Answers  

---

How do we use distinct statement? What is its use?

0 Answers  

---

What is primary key and foreign key?

0 Answers  

---

can we create index on index?

7 Answers   iFlex, Symphony,

---

How can we avoid duplicating records in a query?

0 Answers  

---

How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". It consists of multiple columns. Then if we insert rows into this table with duplicate records then how can we retrieve only duplicate records from that table?

28 Answers   Alps, Aricent, Bank Of America, Wipro,

---