What is Function based Index and which type of function we can use in Function base index.
can we use aggregate,NVL function in Function based Index..
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 This Answer Correct ? | 0 Yes | 0 No |
What is date functions?
What is a record in pl/sql?
What is the difference between sql and isql*plus?
What is the plv (pl/vision) package offers?
i have a word ***********hello********world******. I require a o/p **********hello world**********, Need to delete the middle stars.
What is a pl/sql block?
How can you load microsoft excel data into oracle? : aql loader
What are the disadvantages of not performing database normalization?
declare v_count number(8,3); v_sal scott.emp.sal%type := '&P_sal'; cursor cur_name is select sal from scott.emp where sal between (v_sal-100) and (v_sal +1000); begin v_count :=nvl(sql%rowcount ,0); if v_count = 0 then dbms_output.put_line('no records are fetch in the given sal range'); else dbms_output.put_line('There is/are '||to_char(v_count)|| ' salaries are selected in the given range '); end if; end; in the above programm .....for any sal range ....always it shows the following message.. no records are fetch in the given sal range please find the mistake and share with me...with thansk and regards..sarao....
Does it possible to pass object (or) table as an argument to a remote procedure?
Why stored procedure is better than query?
i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75