Interested to Buy Any Domain ? << Click Here >> for more details...
How to create index-by table in oracle?
- 3 Answers
- 6577 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 is backup in Oracle?
Explain parameter file in oracle.
State and explain the different types of data models?
Why is oracle so popular?
What is Private Database Link ?
What is the Extension of Oracle Database? As extension of Access Database is .mdb
How to define an oracle cursor variable?
Explain the use of indexes option in exp command.
What is the difference between translate and replace?
What is a table in oracle?
What is transport network substrate (tns) in oracle?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
Oracle General 
