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

How to create a temporary table in oracle?

1331

---

How to check the oracle tns settings?

1088

---

What are the differences between number and binary_float in oracle?

1149

---

How to use fetch statement in a loop?

1067

---

What is a oracle database?

1108

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1984

---

Is oracle a programming language?

1037

---

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

1065

---

What is difference between sid and service name in oracle?

1008

---

Explain about your project and its relation to the current job position you are applying to?

1075

---

Explain parameter file in oracle.

1081

---

How to export several tables together?

1105

---

What do you mean by merge in oracle and how can you merge two tables?

1007

---

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2422

---

How to convert numbers to characters in oracle?

1078

---