Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

How to create an oracle testing table?

1006


How to load a large xml file?

1001


Can objects of the same schema reside in different tablespace?

999


How to use select statement to count the number of rows in oracle?

985


How oracle handles dead locks?

1017


What is oracle open database communication (odbc)?

959


What happens if recursive calls get out of control?

998


can u send the sql dumps to sivakumarr1987@gmail.com plz help me

2995


How can you use check constraints for self referential integrity?

915


What is key preserved table?

959


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 ?

2412


How to convert characters to dates in oracle?

1022


How to save query output to a local file?

967


How to assign a table row to a record variable?

965


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.

1793