Answer / guest

The advantages of views are
1)Data abstraction
2)Simple retrieving of data.

Answer / nishi

- Provide an additional level of table security, by restricting access to a predetermined set of rows and columns of a table.

- Hide data complexity.

- Simplify commands for the user.

- Present the data in a different perspective from that of the base table.

- Store complex queries.

Answer / ven

secutiry of the data for ex: in bank domain some of the
columns data don't want to see others then we can restrict
the columns and create views and share the columns
whichever others can see.

T1: T2 A X--- this is updated record B B like this T1 table having no.of records updated. write a query"retrive updated record from T2"

2 Answers   Cognizant,

---

What happens to the current transaction if the session is ended?

0 Answers  

---

Explain the use of rows option in imp command.

0 Answers  

---

What are the different types of modules in oracle forms?

0 Answers  

---

1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]

2 Answers  

---

How you find out version of installed workflow?

1 Answers  

---

How to connect the oracle server as sysdba?

0 Answers  

---

i have a table with the columns below as Emp_ID Address_ID Address_Line City Country -------- --------- ----------- ------ --------- Q: Display the Emp_ID's those having more than one Address_ID

7 Answers   IBM,

---

Whatz the main diff between Subquery and a Join

14 Answers   Oracle, Zeta Interactive,

---

select to_char('10','10') from dual This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL why? pls help

6 Answers  

---

What is data type in oracle?

0 Answers  

---

What is parameterized cursor in oracle?

0 Answers  

---