Answer Posted / harsha vardhan reddy

1.It is a LOGICAL and VIRTUAL object.

2.It is stored select statement.

3.It allows DESCRIBE,DML,SELECT on it.

4.It will not hold data in it.

5.It supports to share "selected rows and columns with
other user"

6.It provides security while sharing.


regards,
harsha518@gmail.com
harsha.vardhan@cmcltd.com

What is execute immediate in oracle?

1073

---

Explain oracle left join with an example?

1055

---

What is pragma autonomous transaction in oracle?

1121

---

State the various uses of dbcc command?

1100

---

What is the difference between formal parameters and actual parameters?

1146

---

What is Undo Management Advisor in Oracle?

1151

---

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2265

---

> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?

2087

---

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1083

---

Is primary key indexed by default in oracle?

1041

---

Whats the benefit of dbms_stats over analyze?

2064

---

How to assign a tablespace to a users in oracle?

1086

---

How to run create database statement again?

1213

---

What is a nested table and how is it different from a normal table?

1100

---

Is there a function to split a string in plsql?

1103

---