Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
DECODE() example
SELECT JOB_ID, SUM(DECODE(department_id,20,salary))"dept_id=20", SUM(DECODE(department_id,50,salary)) "dept_id=50",SUM(SALARY)"TOTAL" FROM EMPLOYEES GROUP BY JOB_ID
run
|
edit
|
history
|
help
0
display student details in pl/sql
temporal overlap in oracle
record type
minimum of two(replace)
max of 2(function)
SQL Test
Character inception test
EMP
emp
checking for lower case