Which Functions Using Integer ==> String's i.e 2 ==> Two...
Like that string's ==> integer values ? It is Possible ?
- 2 Answers
- 3834 Views
- Oracle, SAH, I also Faced
- E-Mail Answers
Answer Posted / rajesh.mca
Using To_char() function
ex: select sal , To_char(To_Date(sal,'j'),'jsp') as "Sal in
words" from emp
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
Explain oracle data types with examples?
How do we create privileges in oracle?
How to define an oracle cursor variable?
How to list all user accounts in oracle?
What is difference between sid and service name in oracle?
What is redo log?
Difference between varchar and varchar2 data types?
What do you mean by a database transaction & what all tcl statements are available in oracle?
What is coalesce function?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
Whats the benefit of dbms_stats over analyze?
What is blob data type in oracle?
How to drop an index?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
query optmization techniques and quwry analyser+projects+ppts
