Technical Blog
Pages
(Move to ...)
Home
Oracle DBA
ERP
Oracle Apps
Data Warehouse
Java
UNIX
Hadoop
JOBS4U
▼
Showing posts with label
Level
.
Show all posts
Showing posts with label
Level
.
Show all posts
Jun 10, 2011
Convert a number to word
›
select to_char(to_date('1983','J'),'JSP') from dual; In this query the number is converting into Julian date then ...
Sep 22, 2008
Alphabets,Level, Analytic Query
›
Alphabets WITH AlphaBet AS ( SELECT CHR((ROWNUM + 64)) AS Character FROM DUAL CONNECT BY level SELECT * FROM AlphaBet; -------------...
›
Home
View web version