Interested to Buy Any Domain ? << Click Here >> for more details...
How to create index-by table in oracle?
- 3 Answers
- 6402 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / santosh kumar
declare
type str is table of number index by binary_integer;
tab_res str; ---------declaring variable....
min_eid number;
max_eid number;
begin
select min(employee_id),max(employee_id) into
min_eid,max_eid
from employees;
for i in min_eid..max_eid loop
select salary into tab_rec(i) from employees
where employee_id=i;
end;
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / su
declare
TYPE tab IS TABLE OF varchar2(200)
INDEX BY binary_integer;
t tab;
v_counter number : =0;
BEGIN
FOR c_emp IN (SELECT ENAME FROM emp)
LOOP
v_counter := v_counter + 1;
t(v_counter):= c_emp.ename;
END LOOP;
FOR i IN 1 .. t.last
LOOP
dbms_output.put_line(t(i));
END LOOP;
EXCEPTION
WHEN others THEN
dbms_output.put_line(sqlcode);
dbms_output.put_line(sqlerrm);
END;
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sourav mukhopadhyay
Create index INDEXNAME
ON table(column-name);
| Is This Answer Correct ? | 1 Yes | 6 No |
What are cursor?where are they used?
How to initialize variables with default values?
How to add a new column to an existing table with a default value?
how to retrieve 1st and last row of table without using group functions??
What are the types of synonyms?
What is hot backup and logical backup?
Explain the use of constraints option in exp command.
what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval
How to use "out" parameter properly?
What is columnar storage what is the advantage?
How to export data to a csv file?
How to delete all rows a table in oracle?
Oracle General 
