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 »

iPad Mini, priced at $299

Apple could price an 8-in. iPad as low as $299, an analyst said today, as part of a strategy to "crush the opposition."
Read More

Read more »

Red Hat Enterprise Virtualization 3.0

WHY OUR CUSTOMERS LOVE RHEV

Red Hat Enterprise Virtualization Read Now

Read more »

iPad 3 Release Date, Feature and Specifications, LTE support

iPad-3 Mock-Up

Apple will unveil the next iPad on March 7, according to reports. So many reports saying that iPad 3 will be released on 7 March, and a great news for iPad lovers.

 Another great news about iPad 3 is that it may be the first product by Apple that will support LTE. LTE news has announced by on Hardware expert and he says that Apple will move towards Powerful network.

"I think Apple passed on LTE [in 2011] because they thought that would be questioned since it would have appealed to such a small number of possible customers," Vronko said.

Read more »

Is Valentine's Day Celebrated in Pakistan or Not Must Watch

Read more »