Cursor Employee Table. [Table create, insert and display], Oracle

Cursor Employee Table. [Table create, insert and display]

Language: Editor: Layout:

DROP TABLE EmployeeTab\\
CREATE TABLE EmployeeTab (id NUMBER(3),name VARCHAR2(20),location VARCHAR2(20),city VARCHAR2(20),sal NUMBER(8))\\
TRUNCATE TABLE EmployeeTab\\
INSERT INTO EmployeeTab VALUES (101,'Hennry','Main Road','Mumbai',14000)\\
INSERT INTO EmployeeTab VALUES (102,'Moana','MG Road','Bangalore',23000)\\
INSERT INTO EmployeeTab VALUES (103,'Rahul','Cross Road','Manali',2500)\\
INSERT INTO EmployeeTab VALUES (104,'Hanna','L&T Road','Delhi',50000)\\
INSERT INTO EmployeeTab VALUES (105,'Briana','TTK Road','Bangalore',92000)\\
INSERT INTO EmployeeTab VALUES (106,'Chris','L&T Road','Delhi',60400)\\
SELECT * FROM EmployeeTab\\

DECLARE
    CURSOR EmpCur IS SELECT * FROM EmployeeTab;
BEGIN
    FOR EmpRec IN EmpCur 
        LOOP
            dbms_output.put_line('  <*(  )*> /\*\     Employee Id : '||EmpRec.id);
            dbms_output.put_line('   \*\/*/ /*/\*\    Employee Name : '||EmpRec.name);
            dbms_output.put_line('    \*\/ <*(  )*>   Employee Location : '||EmpRec.location);
            dbms_output.put_line('    /\*\  \*\/*/    Employee City : '||EmpRec.city);
            dbms_output.put_line('   /*/\*\  \*\/     ');
        END LOOP;
END;


absolute service time: 1,14 sec

	ID	NAME	LOCATION	CITY	SAL
1	101	Hennry	Main Road	Mumbai	14000
2	102	Moana	MG Road	Bangalore	23000
3	103	Rahul	Cross Road	Manali	2500
4	104	Hanna	L&T Road	Delhi	50000
5	105	Briana	TTK Road	Bangalore	92000
6	106	Chris	L&T Road	Delhi	60400

<*( )*> /\*\ Employee Id : 101 \*\/*/ /*/\*\ Employee Name : Hennry \*\/ <*( )*> Employee Location : Main Road /\*\ \*\/*/ Employee City : Mumbai /*/\*\ \*\/ <*( )*> /\*\ Employee Id : 102 \*\/*/ /*/\*\ Employee Name : Moana \*\/ <*( )*> Employee Location : MG Road /\*\ \*\/*/ Employee City : Bangalore /*/\*\ \*\/ <*( )*> /\*\ Employee Id : 103 \*\/*/ /*/\*\ Employee Name : Rahul \*\/ <*( )*> Employee Location : Cross Road /\*\ \*\/*/ Employee City : Manali /*/\*\ \*\/ <*( )*> /\*\ Employee Id : 104 \*\/*/ /*/\*\ Employee Name : Hanna \*\/ <*( )*> Employee Location : L&T Road /\*\ \*\/*/ Employee City : Delhi /*/\*\ \*\/ <*( )*> /\*\ Employee Id : 105 \*\/*/ /*/\*\ Employee Name : Briana \*\/ <*( )*> Employee Location : TTK Road /\*\ \*\/*/ Employee City : Bangalore /*/\*\ \*\/ <*( )*> /\*\ Employee Id : 106 \*\/*/ /*/\*\ Employee Name : Chris \*\/ <*( )*> Employee Location : L&T Road /\*\ \*\/*/ Employee City : Delhi /*/\*\ \*\/