Interested to Buy Any Domain ? << Click Here >> for more details...
How to create index-by table in oracle?
- 3 Answers
- 6426 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 |
How would you design a database for an e-commerce website?
How to install oracle odbc drivers?
What is Java Pool in Oracle?
Can you assign multiple query result rows to a variable?
Explain what are the advantages of views?
How to start your 10g xe server?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
Draw E-R diagram for many to many relationship ?
What is open database communication (odbc) in oracle?
What is oracle and what are its different editions?
can a view be updated?
How to get execution path reports on query statements?
Oracle General 
