Count Number of Particular Character of String Oracle SQl,Remove Particular character

The below Query Display Number of 'a' either it is upper case or lower case.


select first_name,length(first_name)-length(replace(lower(first_name), 'a')) from employees; 


Count The Number of 'A'
select first_name,length(first_name)-length(replace(first_name, 'A')) from employees; 

Read more »

Oracle Partitioning Overview

Read Now

Read more »

Oracle 11g SecureFiles

Introduction With the whirling phases of application development its content has to be efficient to handle both relational and unstructured data in accessible form. Relational content looks fine and flexible to follow even crude strategies of storage but unstructured data like documents of varied sort audios videos and many more are add up the challenges for designers and architects.

Oracle 11g SecureFiles 

Read more »

Oracle Buys Cloud-based Customer Service Company RightNow For $1.5 Billion

Oracle this morning announced that it has acquired RightNow – both companies are listed on NASDAQ – for $43 per share or roughly $1.5 billion net of RightNow’s cash and debt. With the acquisition, Oracle is adding a robust cloud-based customer service offering (see graph below) to its own Public Cloud solution – more info on that here. RightNow’s share price closed at $35.96 last week, so the deal represents a premium of roughly 20 percent on its closing price on Friday the 21st of October.

RightNow’s solutions help companies handle customer interactions across a multitude of channels, including call and contact centers, the Web and social networks.

Its products are used by nearly 2,000 organizations across the globe, the company says.

Founded in 1997, RightNow went public in 2004. The company boasted a market cap of $1.2 billion at market close last week.

The acquisition by Oracle is expected to close later this year or in early 2012. As usual, the transaction is subject to a number of things, including RightNow stockholder approval, regulatory approvals and other customary closing conditions.

Oracle has closed 6 acquisitions this year. While its takeovers of RightNow and Endeca are pending, the company has completed the purchases of Datanomic, FatWire, Inquira, Ndevr, Ksplice and Pillar Data Systems in 2011 alone.

 

Reference: http://www.linkedin.com/news?actionBar=&articleID=865054301&ids=c3sMe30Qc3sUb3sOcPoUcz0Te2MNc3cQdj0RdzwIe3oNcPwMejoU&aag=true&freq=weekly&trk=eml-tod-b-ttle-96&ut=1bm65ItOx1EQY1

Read more »