| How to retrieve records from SCOTT.EMP table, without using data block wizard? [message #557899] |
Sun, 17 June 2012 06:46  |
 |
kashif_khan8281
Messages: 11
Registered: June 2012
Location: PAKISTAN
|
Junior Member |
|
|
i want to retrieve records of empno from SCOTT.EMP talbe in form but without data block wizard using ..how .. and what logic will be in coding
DECLARE
TYPE EROC IS TABLE OF VARCHAR2(200) INDEX BY BINARY_INTEGER;
E1 EROC;
NO_EMPNO VARCHAR2(2000);
CONTR BINARY_INTEGER:=0;
BEGIN
FOR I IN (SELECT * FROM EMP) LOOP
CONTR:= CONTR+1;
E1(CONTR):=I.EMPNO;
END LOOP;
FOR J IN 1..CONTR LOOP
:V_EMPNO :=(E1(J));
END LOOP;
END;
just caling here EMPNO and :v_empno is fields on form...
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
