Answer / dinesh

Its not batter to modify where clause column with function(Performance issue). So we need to create function based index. Eg.
Create Index Fun_indx on EMP (UPPER(FIRST_NAME).
we can't create function based index on aggregate function.
but we can create NVL function as function.
also we can create function based index on user define function but function should be"DETERMINISTIC".
eg
create or replace function fun_index(a in number) Return
Number DETERMINISTIC IS
BEGIN
'''
,,,
END;

What is magic table?

6 Answers  

---

Why function is used in sql?

0 Answers  

---

Can we use insert statement in function?

0 Answers  

---

is it mandatory to select all the column in a view then what columns should be selected

2 Answers  

---

Explain spool.

0 Answers  

---

---

Why we use stored procedure instead of query?

0 Answers  

---

Can a foreign key be null?

0 Answers  

---

package specification-3 procedures package body-4 procedures how can i write for other procedure in package body

2 Answers   Reliance,

---

write a query to delete similar records in different tables with same structure

4 Answers  

---

what are dynamic queries in t-sql? : Transact sql

0 Answers  

---

What is sql*plus?

0 Answers  

---

I need a exceptoin in pl/sql block so that if any errors occur in the block then no exception should errors should raise?

1 Answers  

---