Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Srinivas
CREATE TABLE Worker(WORKER_ID INT, FIRST_NAME VARCHAR(25), LAST_NAME VARCHAR(25), SALARY INT, JOINING_DATE DATE, DEPARTMENT VARCHAR(25), PRIMARY KEY(WORKER_ID)) INSERT INTO Worker (WORKER_ID, FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE, DEPARTMENT) VALUES (001, 'Monika', 'Arora', 100000, '14-02-20 09.00.00', 'HR'), (002, 'Niharika', 'Verma', 80000, '14-06-11 09.00.00', 'Admin'), (003, 'Vishal', 'Singhal', 300000, '14-02-20 09.00.00', 'HR'), (004, 'Amitabh', 'Singh', 500000, '14-02-20 09.00.00', 'Admin'), (005, 'Vivek', 'Bhati', 500000, '14-06-11 09.00.00', 'Admin'), (006, 'Vipul', 'Diwan', 200000, '14-06-11 09.00.00', 'Account'), (007, 'Satish', 'Kumar', 75000, '14-01-20 09.00.00', 'Account'), (008, 'Geetika', 'Chauhan', 90000, '14-04-11 09.00.00', 'Admin')
run
|
edit
|
history
|
help
0
TALUNO
PL/SQL declaracionVariables
max of 2(function)
change output of table strings and numbers using ascii value modification
ERR
emp
scott
check if concatinated string obtained after reversing s1 and s2 both is a palindrome or not
Srinivas
submask