Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
lakhan
--Oracle 11g Express Edition --please drop objects you've created at the end of the script --or check for their existance before creating --'\\' is a delimiter select banner as "oracle version" from v$version\\ select * from emp\\ --select sysdate from dual --select ENAME,(SYSDATE-HIREDATE)/7 AS 'WEEKS' from emp wher --select TO_CHAR(SAL ,'$99,999.00') AS ESAL from emp where ENAME='SMITH' select ENAME,SAL, NVL(COMM,0),(SAL*12)+(SAL*12*NVL(COMM,0)) AN_SAL from emp
run
|
edit
|
history
|
help
0
Srinivas
Srinivas
Srinivas
2
Example of Local and Global variables
Srinivas
Cursor Employee Table. [Table create, insert and display]
PL/SQL variables and constant
IT
oracle plan