Interested to Buy Any Domain ? << Click Here >> for more details...
How to create index-by table in oracle?
- 3 Answers
- 6694 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 to view existing locks on the database?
How to create a table in a specific tablespace?
Explain what are the characteristics of data files?
How to define a variable to match a table column data type?
How to build data dictionary view an new database?
What is a Sequence ?
How to login to the server without an instance?
What is ADDM Advisor in Oracle?
What is the sid in oracle?
What is the difference between substr & instr functions?
What to do if the startbd.bat failed to start the xe instance?
how to retrive xml data for using sql query?
Oracle General 
