Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Extract Year from Date Field Example
--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\\ -- extract year from date example -- base data example select sysdate from dual\\ -- extract year select to_char(sysdate, 'YYYY') from dual\\
run
|
edit
|
history
|
help
0
Cursor Employee Table. [Table create, insert and display]
lakhan
Srinivas
ishu
ff
test out
oracle procedure example
Srinivas
Srinivas
wq1