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;

Is sql a backend language?

0 Answers  

---

What kind of join is join?

0 Answers  

---

What is pl/sql and what is it used for?

4 Answers  

---

What are the qualities of 2nf?

0 Answers  

---

What do you mean by field in sql?

0 Answers  

---

I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.

7 Answers   MTS,

---

Is ms sql is free?

0 Answers  

---

What is sql server and ase?

0 Answers  

---

How do I run a sql trace?

0 Answers  

---

how will be date change into string

4 Answers  

---

How to process query result in pl/sql?

0 Answers  

---

display null value rows with out using null function?

8 Answers   Infosys,

---