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
0
Please
log in
to post a comment.
Extract Year from Date Field Example
Assignment 1(1)
Srinivas
alle angemeldeten Benutzer können eine gegebene aktion ausgeben ( im Web )
Srinivas
change output of table strings and numbers using ascii value modification
Регулярное выражение, ограничить количество
To find out first day of month without trunc function
0607-3
Srinivas
Please log in to post a comment.