SQL>
SQL> CREATE TABLE EMP (EMPNO NUMBER(4) NOT NULL,
2 ENAME VARCHAR2(10),
3 JOB VARCHAR2(9),
4 MGR NUMBER(4),
5 HIREDATE DATE,
6 SAL NUMBER(7, 2),
7 COMM NUMBER(7, 2),
8 DEPTNO NUMBER(2));
Table created.
SQL>
SQL> INSERT INTO EMP VALUES (7369, 'SMITH', 'CLERK', 7902, TO_DATE('17-DEC-1980', 'DD-MON-YYYY'), 800, NULL, 20);
1 row created.
SQL> INSERT INTO EMP VALUES (7499, 'ALLEN', 'SALESMAN', 7698, TO_DATE('20-FEB-1981', 'DD-MON-YYYY'), 1600, 300, 30);
1 row created.
SQL> INSERT INTO EMP VALUES (7521, 'WARD', 'SALESMAN', 7698, TO_DATE('22-FEB-1981', 'DD-MON-YYYY'), 1250, 500, 30);
1 row created.
SQL> INSERT INTO EMP VALUES (7566, 'JONES', 'MANAGER', 7839, TO_DATE('2-APR-1981', 'DD-MON-YYYY'), 2975, NULL, 20);
1 row created.
SQL> INSERT INTO EMP VALUES (7654, 'MARTIN', 'SALESMAN', 7698,TO_DATE('28-SEP-1981', 'DD-MON-YYYY'), 1250, 1400, 30);
1 row created.
SQL> INSERT INTO EMP VALUES (7698, 'BLAKE', 'MANAGER', 7839,TO_DATE('1-MAY-1981', 'DD-MON-YYYY'), 2850, NULL, 30);
1 row created.
SQL> INSERT INTO EMP VALUES (7782, 'CLARK', 'MANAGER', 7839,TO_DATE('9-JUN-1981', 'DD-MON-YYYY'), 2450, NULL, 10);
1 row created.
SQL> INSERT INTO EMP VALUES (7788, 'SCOTT', 'ANALYST', 7566,TO_DATE('09-DEC-1982', 'DD-MON-YYYY'), 3000, NULL, 20);
1 row created.
SQL> INSERT INTO EMP VALUES (7839, 'KING', 'PRESIDENT', NULL,TO_DATE('17-NOV-1981', 'DD-MON-YYYY'), 5000, NULL, 10);
1 row created.
SQL> INSERT INTO EMP VALUES (7844, 'TURNER', 'SALESMAN', 7698,TO_DATE('8-SEP-1981', 'DD-MON-YYYY'), 1500, 0, 30);
1 row created.
SQL> INSERT INTO EMP VALUES (7876, 'ADAMS', 'CLERK', 7788,TO_DATE('12-JAN-1983', 'DD-MON-YYYY'), 1100, NULL, 20);
1 row created.
SQL> INSERT INTO EMP VALUES (7900, 'JAMES', 'CLERK', 7698,TO_DATE('3-DEC-1981', 'DD-MON-YYYY'), 950, NULL, 30);
1 row created.
SQL> INSERT INTO EMP VALUES (7902, 'FORD', 'ANALYST', 7566,TO_DATE('3-DEC-1981', 'DD-MON-YYYY'), 3000, NULL, 20);
1 row created.
SQL> INSERT INTO EMP VALUES (7934, 'MILLER', 'CLERK', 7782,TO_DATE('23-JAN-1982', 'DD-MON-YYYY'), 1300, NULL, 10);
1 row created.
SQL>
SQL> CREATE OR REPLACE PROCEDURE show_emps (i_job IN VARCHAR2 DEFAULT '%')
2 AS
3 CURSOR emp_cur
4 IS
5 SELECT * FROM emp WHERE job LIKE i_job ORDER BY ename;
6 emp_rec emp_cur%ROWTYPE;
7 BEGIN
8 HTP.print ('EMP table<title>');<br/> 9 HTP.print ('<UL>');<br/> 10 OPEN emp_cur;<br/> 11 LOOP<br/> 12 FETCH emp_cur INTO emp_rec;<br/> 13 EXIT WHEN emp_cur%NOTFOUND;<br/> 14 HTP.print ('<LI>' || emp_rec.ename || '</LI>');<br/> 15 HTP.print ('<LI>' || emp_rec.job || '</LI>');<br/> 16 HTP.print ('<LI>' || emp_rec.hiredate || '</LI>');<br/> 17 HTP.print ('<LI>' || emp_rec.sal || '</LI>');<br/> 18 END LOOP;<br/> 19 CLOSE emp_cur;<br/> 20 END;<br/> 21 /<br/>Procedure created.<br/>SQL><br/>SQL> drop table emp;<br/>Table dropped.<br/>SQL>
</code>
</div>
</div>
<br />
<footer class="py-12 bg-dark">
<div class="container">
<div class="row mb-12">
<div class="col-md-12">
<p class="text-center text-black">Copyright © Mega Code Archive 2024</p>
</div>
</div>
<div class="row mb-12">
<div class="col-md-2">
<div class="row">
.NET
</div>
<div class="row">
<a href="/Page/Categories/2/ASP Net">ASP.Net</a>
</div>
<div class="row">
<a href="/Page/Categories/3/ASP Net Tutorial">ASP.Net Tutorial</a>
</div>
<div class="row">
<a href="/Page/Categories/6/C#">C#</a>
</div>
<div class="row">
<a href="/Page/Categories/7/C# Book">C# Book</a>
</div>
<div class="row">
<a href="/Page/Categories/8/C# by API">C# by API</a>
</div>
<div class="row">
<a href="/Page/Categories/9/C# Tutorial">C# Tutorial</a>
</div>
<div class="row">
<a href="/Page/Categories/38/VB Net">VB.Net</a>
</div>
<div class="row">
<a href="/Page/Categories/39/VB Net by API">VB.Net by API</a>
</div>
<div class="row">
<a href="/Page/Categories/40/VB Net Tutorial">VB.Net Tutorial</a>
</div>
<div class="row">
<a href="/Page/Categories/41/Visual CPlusPlus Net">Visual C++ .Net</a>
</div>
<div class="row">
<a href="/Page/Categories/42/VisualBasic Script">VisualBasic Script</a>
</div>
</div>
<div class="col-md-2">
<div class="row">
Java
</div>
<div class="row">
<a href="/Page/Categories/15/Java">Java</a>
</div>
<div class="row">
<a href="/Page/Categories/16/Java Book">Java Book</a>
</div>
<div class="row">
<a href="/Page/Categories/17/Java by API">Java by API</a>
</div>
<div class="row">
<a href="/Page/Categories/18/Java Tutorial">Java Tutorial</a>
</div>
<div class="row">
Script
</div>
<div class="row">
<a href="/Page/Categories/13/Flash ActionScript">Flash ActionScript</a>
</div>
<div class="row">
<a href="/Page/Categories/14/Flex">Flex</a>
</div>
<div class="row">
<a href="/Page/Categories/19/JavaScript DHTML">JavaScript DHTML</a>
</div>
<div class="row">
<a href="/Page/Categories/20/JavaScript Reference">JavaScript Reference</a>
</div>
<div class="row">
<a href="/Page/Categories/21/JavaScript Tutorial">JavaScript Tutorial</a>
</div>
</div>
<div class="col-md-2">
<div class="row">
Database
</div>
<div class="row">
<a href="/Page/Categories/25/MSSQL">MSSQL</a>
</div>
<div class="row">
<a href="/Page/Categories/26/MSSQL Tutorial">MSSQL Tutorial</a>
</div>
<div class="row">
<a href="/Page/Categories/27/MySQL">MySQL</a>
</div>
<div class="row">
<a href="/Page/Categories/28/MySQL Tutorial">MySQL Tutorial</a>
</div>
<div class="row">
<a href="/Page/Categories/29/Oracle PLSQL">Oracle PLSQL</a>
</div>
<div class="row">
<a href="/Page/Categories/30/Oracle PLSQL Tutorial">Oracle PLSQL Tutorial</a>
</div>
<div class="row">
<a href="/Page/Categories/33/PostgreSQL">PostgreSQL</a>
</div>
</div>
<div class="col-md-2">
<div class="row">
Languages
</div>
<div class="row">
<a href="/Page/Categories/1/Android">Android</a>
</div>
<div class="row">
<a href="/Page/Categories/4/C">C</a>
</div>
<div class="row">
<a href="/Page/Categories/5/C Tutorial">C Tutorial</a>
</div>
<div class="row">
<a href="/Page/Categories/10/CPlusPlus">C++</a>
</div>
<div class="row">
<a href="/Page/Categories/11/CPlusPlus Tutorial">C++ Tutorial</a>
</div>
<div class="row">
<a href="/Page/Categories/12/Delphi">Delphi</a>
</div>
<div class="row">
<a href="/Page/Categories/31/Perl">Perl</a>
</div>
<div class="row">
<a href="/Page/Categories/32/PHP">PHP</a>
</div>
<div class="row">
<a href="/Page/Categories/34/Python">Python</a>
</div>
<div class="row">
<a href="/Page/Categories/35/Python Tutorial">Python Tutorial</a>
</div>
<div class="row">
<a href="/Page/Categories/36/Ruby">Ruby</a>
</div>
<div class="row">
<a href="/Page/Categories/37/Silverlight">Silverlight</a>
</div>
</div>
<div class="col-md-2">
<div class="row">
Office
</div>
<div class="row">
<a href="/Page/Categories/22/MSOfficeExcel 2007 Tutorial">MSOfficeExcel 2007 Tutorial</a>
</div>
<div class="row">
<a href="/Page/Categories/23/MSOfficePowerPoint 2007 Tutorial">MSOfficePowerPoint 2007 Tutorial</a>
</div>
<div class="row">
<a href="/Page/Categories/24/MSOfficeWord 2007 Tutorial">MSOfficeWord 2007 Tutorial</a>
</div>
<div class="row">
Data
</div>
<div class="row">
<a href="/Page/Categories/43/XML">XML</a>
</div>
<div class="row">
<a href="/Page/Categories/44/XML Tutorial">XML Tutorial</a>
</div>
</div>
<div class="col-md-2">
<div class="row">
Others
</div>
<div class="row">
<a href="/Home/About">About</a>
</div>
</div>
</div>
</div>
</footer>
</div>
</body>
</html>