Answer Posted / md sajjad

No We cannot create index on view:
e.g
1* create view emp_view as select * from emp where
deptno=20
SQL> /

View created.


1* create index indx_emp on emp_view(empno)
SQL> /
create index indx_emp on emp_view(empno)
*
ERROR at line 1:
ORA-01702: a view is not appropriate here

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2727

---

Why is oracle database so popular?

768

---

How to convert characters to times in oracle?

761

---

How do we get field details of a table?

730

---

What is a nvl function? How can it be used?

754

---

What are the attributes of the cursor?

759

---

Can we write dml statement in function in oracle?

822

---

What are the common oracle dba tasks?

851

---

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

876

---

What's dateware house and what's clustor with practicle example

1917

---

How to list all user accounts in oracle?

812

---

What is the usage of save points in oracle database?

735

---

Can you assign multiple query result rows to a variable?

747

---

What happens if the imported table already exists?

771

---

How to revoke create session privilege from a user in oracle?

759

---