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

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

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;


run \| edit \| history \| help	1

Please log in to post a comment.

Advertise here.