SHARE
TWEET

Untitled

a guest Jun 26th, 2019 47 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. create or replace type final as object ( ename1 varchar2(10), sal1
  2. NUMBER(7,2));--object
  3.  
  4. create or replace type construct is table  of final; /*nested table of
  5. object*/ type
  6.  
  7. create or replace function returnmore (empno1 number) /*Function to
  8. return more*/
  9. return construct
  10. AS
  11. vemp construct:=construct();
  12. vename varchar2(10);
  13. vsal1 NUMBER(7,2);
  14. begin
  15.  
  16. select ENAME,sal into vename,vsal1 from emp where empno=empno1;
  17. vemp.extend;
  18. vemp(1):=construct(vename,vsal1);
  19. return vemp;
  20. end;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top