Which Functions Using Integer ==> String's i.e 2 ==> Two...
Like that string's ==> integer values ? It is Possible ?
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
How to create an oracle testing table?
How to load a large xml file?
Can objects of the same schema reside in different tablespace?
How to use select statement to count the number of rows in oracle?
How oracle handles dead locks?
What is oracle open database communication (odbc)?
What happens if recursive calls get out of control?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
How can you use check constraints for self referential integrity?
What is key preserved table?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
How to convert characters to dates in oracle?
How to save query output to a local file?
How to assign a table row to a record variable?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.