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

What is a table index?

1098

---

What is a relational database management system?

1120

---

Explain the use of consistent option in exp command.

1066

---

Name the various constraints used in oracle?

1019

---

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1865

---

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2272

---

how to do daily transactions with out sql* loader control file regesterd in apps?

1685

---

What is SQL Tuning Advisor in Oracle?

1178

---

Explain oracle’s system global area (sga).

1139

---

What is the order of defining local variables and sub procedures/functions?

1061

---

How to create a new table in oracle?

1153

---

How to do paging with oracle?

995

---

Explain about the analyze command in oracle?

1052

---

How do I spool to a csv formatted file using sqlplus?

1033

---

What is transaction control statement and how many types of transaction control statement in Oracle?

1155

---