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;

can i use global variables in stored procedure or function

1 Answers   L&T,

---

Its possible to add more than one primary key for the table

4 Answers  

---

What is the use of %rowtype?

0 Answers  

---

What is the difference between joins?

0 Answers  

---

Which are sql * plus commands?

0 Answers  

---

---

How to get list of all tables from a database?

0 Answers  

---

What is compute?

0 Answers  

---

Explain the difference in execution of triggers and stored procedures?

0 Answers  

---

difference between table level constraint and column level and advantages of table level constraint

4 Answers   Doyensys,

---

What is identity column in sql server?

0 Answers  

---

Describe types of sql statements?

0 Answers  

---

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

4 Answers   Cap Gemini, MTS,

---