Answer / 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

Answer / madhusudhan.madireddy

limit access and view to required fields only

Answer / santosh kumar

Hi,

Advantages of views:

1. View the data without storing the data into the object.

2. Restict the view of a table i.e. can hide some of columns in the tables.

3. Join two or more tables and show it as one object to user.

4. Restict the access of a table so that nobody can insert the rows into the table.

Disadvatages:

1. Can not use DML operations on this.

2. When table is dropped view becomes inactive.. it depends on the table objects.

3. It is an object, so it occupies space.

What is a procedure in pl sql?

0 Answers  

---

how to drop an existing table in mysql? : Sql dba

0 Answers  

---

what is the difference between undefined value and null value? : Sql dba

0 Answers  

---

What is delimiter in pl sql?

0 Answers  

---

Can we create clustered index without primary key?

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.

4 Answers   CGI, IBM,

---

I have a tablle like this. cust acc --------------- a 1 b 2|3 c 4|5|6 I Want below o/p: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 Please any one can you have any ideas share me. I have urgent requirement.

4 Answers   Cap Gemini, MTS,

---

Write a procedure to return the month and the number of developers joined in each month (cursor )

2 Answers   Tech Mahindra,

---

How to display Row Number with Records in Oracle SQL Plus?

0 Answers   MCN Solutions,

---

Is trigger a stored procedure?

0 Answers  

---

Is primary key a clustered index?

0 Answers  

---

Can we create table in function?

0 Answers  

---