SET Serveroutput ON
DECLARE
veno emp.eno%type;
BEGIN
veno := '&veno';
DBMS_OUTPUT.PUT_LINE(emp_name.find_name(veno));
END;
/
Easy Learning... (Web Development,.NET Technology,Oracle,Silverlight,REST,SQL,Oracle,MySQL,Data Science, Python and many more ...)
Tuesday, October 13, 2020
RDBMS PLSQL Program 35 Program generate package body with single function in it
CREATE OR REPLACE PACKAGE BODY emp_name AS
FUNCTION find_name(veno emp.eno%TYPE) return varchar IS
vename emp.ename%TYPE;
BEGIN
SELECT ename INTO vename
FROM emp
WHERE eno = veno;
RETURN vename;
END;
END emp_name;
/
RDBMS PLSQL Program 34 Program generate package specification with single function in it
CREATE OR REPLACE PACKAGE emp_name AS
FUNCTION find_name(veno emp.eno%type)return varchar;
END emp_name;
/
Saturday, October 10, 2020
RDBMS PLSQL Program 33 Program to call package
SET Serveroutput ON
DECLARE
veno emp.eno%type;
BEGIN
veno := '&veno';
emp_sal.find_sal(veno);
END;
/
RDBMS PLSQL Program 32 Program generate package body with single procedure in it
CREATE OR REPLACE PACKAGE BODY emp_sal AS
PROCEDURE find_sal(veno emp.eno%TYPE) IS
vesalary emp.esalary%TYPE;
BEGIN
SELECT esalary INTO vesalary
FROM emp
WHERE eno = veno;
dbms_output.put_line('Salary: '|| vesalary);
END;
END emp_sal;
/
RDBMS PLSQL Program 31 Program generate package specification with single procedure in it
CREATE OR REPLACE PACKAGE emp_sal AS
PROCEDURE find_sal(veno emp.eno%type);
END emp_sal;
/
Thursday, October 08, 2020
Saturday, October 03, 2020
Thursday, October 01, 2020
Subscribe to:
Comments (Atom)