Thanks for the question, Avisha.
Asked: November 07, 2016 - 11:36 am UTC
Last updated: November 08, 2016 - 6:39 am UTC
Version: ORACLE 11 XE
Viewed 1000+ times
SQL> CREATE OR REPLACE PACKAGE TBOOK AS 2 FUNCTION TBOOK1(JID VARCHAR2) RETURN VARCHAR2; 3 END; 4 / Package created. SQL> SQL> SQL> CREATE OR REPLACE PACKAGE BODY TBOOK AS 2 JID2 VARCHAR2(6); 3 JID1 VARCHAR2(6); 4 FUNCTION TBOOK1(JID VARCHAR2) 5 RETURN VARCHAR2 6 IS 7 BEGIN 8 JID1:= JID; 9 SELECT 'x' JID INTO JID2 FROM dual; 10 RETURN JID2; 11 END TBOOK1; 12 END TBOOK; 13 / Package body created. SQL> SQL> select tbook.tbook1('test') from dual; TBOOK.TBOOK1('TEST') --------------------------------------------------------- x
Check out more PL/SQL tutorials on our LiveSQL tool.
PL/SQL reference manual from the Oracle documentation library