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  

---

if a string is there like s1,s2,s3,s4.How to find count of commas in this.

4 Answers  

---

What is ttitle and btitle?

0 Answers  

---

What is bulk collections?

2 Answers  

---

What are the operators used in select statements?

0 Answers  

---

select 1,col1,col2 from table1. output?

5 Answers   Ramco,

---

Why we use sql profiler?

0 Answers  

---

can i use global variables in stored procedure or function

1 Answers   L&T,

---

difference between pl/sql table and normal pl/sql table

2 Answers  

---

What are the ddl commands?

0 Answers  

---

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

0 Answers  

---

declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?

7 Answers   Oracle,

---