Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
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.
Reverse of a number
Srinivas
1
Srinivas
My_employee
Srinivas
Srinivas
Nested loops
test
Srinivas
Please log in to post a comment.