Answer Posted / ashokram s

Using view you can restrict the data and thus granting privilege on the view instead of base table can ensure security that all data cant be accessible by a particular user

What is sql stand for?

945

---

What is mutating table error?

1116

---

How to pipe multiline string to isql?

959

---

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4095

---

What are sql commands?

935

---

How do I edit a trigger in sql developer?

935

---

What is pl/sql table? Why it is used?

989

---

What is a composite primary key?

1031

---

what is a relationship and what are they? : Sql dba

1025

---

What are some predefined exceptions in pl/sql?

1063

---

Can we use loop in sql?

922

---

What does bitemporal mean?

1009

---

What is the difference between a primary key and a unique key?

998

---

what are the differences among rownum, rank and dense_rank? : Sql dba

981

---

What is sql*loader and what is it used for? : aql loader

1094

---