Recent posts

Grouping of Null and Not Null fields

Hi,

I have to form a query in such a way that all the NULL values in a column are grouped together and Not NULL values are grouped separately.

In algorithm form my output should be:
Total_Count            Columnxyz
number1                    NULL
number2  ...



Read more
Stuart Written on 04/28/2011 in Question

Difference between count(1) and count(*)

Hi,

I am new to Oracle. I have a doubt regarding two basic queries I see everyday at work. Say, I have a table employee with 1000 records. When I fire:

 

Select count(*) from employee;

 

And

 

Select count(1) from employee;

 

They both give me the same result - 1000.

Is there any difference between count(*)...



Read more
justin Written on 04/28/2011 in Question

Can multiple access points be used on the same LAN?

I have 3 access points, that I plan to install on my Local Area Network and I want to use them at the same time.

Is this possible?



Read more
Byron Written on 04/28/2011 in Question

How to index my website in Google and Bing?

Hello everyone. I just created my first ever website for my business and I want to ask for help regarding search engine indexing. Right now there are two major search engines dominating the market, Google and Bing (since Yahoo is now powered by Bing). My website got indexed in...



Read more
Maria Alexa Written on 04/28/2011 in Question

My computer getting stock or freeze while sending emails

When I send emails, my computer gets stuck or freezes, and sometimes, it turns off. I'm wondering what the problem might be. Is there anyone who knows any solution to this?



Read more
antonio Written on 04/28/2011 in Question

CPU won’t start after installing Call of Duty game

 

Hi! I was using my computer a while ago and was installing Call of Duty. While the system was copying the files, I left it for a while and when I came back, the CPU is already turned off. When I tried to turn it back on, it doesn’t...



Read more
Jonathan Tan Written on 04/27/2011 in Question

Internet connection gets disconnected when I am not using my laptop

Hi everyone,

I need help with my internet.  It seems to disconnect, when I leave my laptop. What I usually do is, just leave it when I am done using it.

Earlier,  whenever I come back to use it, I still had my internet working.  However now, when I come back,...



Read more
sinigang Written on 04/27/2011 in Question

I can’t find a certain file that I’m looking for!

I'm trying to search for a certain file (it's an invoice) but have no luck searching for it. Can you share some tips or suggestions to help find a file in Windows Vista?



Read more
a_panganiban Written on 04/27/2011 in Question

Reverse the values of an Array

Hi All

I need to write a program that will show the reverse order of an array’s elements.

What will be code for reversing the values of an array?

For example: if array = 5,8,12,19,25

Then program will show the out put as:

25,19,12,8,5

Any help would really be appreciated.



Read more
Dev_Raj Written on 04/27/2011 in Question

Need Program Output for a health card menu

Hi

I need to write a program. It’s very much difficult for me to attempt without any help. Please give me an idea solution to understand how can i solve this program?

This is about to write a program that will display the following menu of a health club:

  1. Standard Adult Membership
  2. Child...



    Read more
jAlbert Written on 04/27/2011 in Question