Oracle REPLACE ROUND Functions- Oracle REPLACE,ROUND Functions



Sitemap

Oracle REPLACE,ROUND Functions

REPLACE(char, search_str[, replace_str])
              ANSI alternative to decode() Replace every occurrence of search_str
              with replace_str, replace_str defaults to null.

select REPLACE('Earn Money','Mon')   from dual
Result :Earn ey

select REPLACE('Earn Money','Mon','K')   from dual
Result :Earn Key

ROUND(n,d)    n rounded to d decimal places (d defaults to 0)
select ROUND(10.00)   from dual
Result:10

select ROUND(10.99,2)   from dual
Result:10.99

select ROUND(10.99,1)   from dual
Result:11

Page 1

Earn Money

Pay-to-Online

Thanks for your Donation.

WorkAtHome

Freelancer Jobs

Expired Domain Name Lists with Google PageRank

Jobs

Make Web Sites

Free Web Tools

Add Country Flag to your site

Google PageRank Checker

Google Bulk PageRank Checker

Google Sitemap

Send Free SMS

Send Me Email alert when you add new books

Most searched EBooks

Internet Million Dollars - The Next Edition.
It Works! We Make Our Customers Millionaires! Order Now And Get $600 Bonus & Free Money Making Website!!!

The Turnkey Money Machine
That Prints Non-Stop Profits For You Automatically, The Lazy Way

Help us to maintain this site free