Answer / Kunal Kishor

In SQL, you can use INNER JOIN or the SQL keyword WHERE to fetch common records from two tables. The result set contains only those rows where there is a match in the specified join column.

How do you truncate?

1 Answers  

---

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

1 Answers   Wipro,

---

how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?

6 Answers  

---

What is scalar data type in pl sql?

1 Answers  

---

What is the difference between distinct and unique in sql?

1 Answers  

---

What is the usage of the distinct keyword?

1 Answers  

---

How long it takes to learn pl sql?

1 Answers  

---

In what condition is it good to disable a trigger?

1 Answers  

---

How do I order columns in sql?

1 Answers  

---

What is left join in sql?

1 Answers  

---

What are different categories of sql commands?

1 Answers  

---

Are there any features that are decommissioned in 11g that are not present in 11g?

1 Answers  

---