Dear all,

Is there a way that I can view my databases while at work or through the internet? I am running a Filemaker 9.0 V3 and i want my databases to be viewable wherever I am and to my mobile phone. But it needs to have a security so that no one can access it without my permission. 

Topor.

I am loading up a Linux server from scratch. I have downloaded the latest stable release of MySQL.

When installing MySQL Server, by default, I noticed that the MySQL installation on Linux places the location at /var/lib/ folder.

I do not want to use the /var/lib folder. I have a separate partition that I wish to use for MySQL data files.

Is there a way to change the default data file location?

Can I use Access to make a simple payroll program?

Hello everyone,

I have a requirement as below :

 If p=s and q=t and r=u then display a value.

I want an equivalent query in Oracle for this.

Thanks in advance.

Hi,

I have been working on Oracle for quite sometime now. I have always used the DECODE function that represents IF-THEN-ELSE clause. I read somewhere that from Oracle 8i onwards CASE statement has been introduced to get the same result. But which one out of the two is better considering both are used to do the same task?

Hello everyone,

I have a table student where other that the student name, student id, subjects, marks details, I also store whether the student has some salary or not. This last field stores the salary amount if its valid in a particular student's case or it is NULL. Any pointers on this will be highly appreciated.

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                    All Not NULL

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(*) and count(1)?

I have an issue when creating a huge table space. Reports this error:

SQL1139N The total size of the table space is too big Explanation: The size of the current table space is too big.

The size of a REGULAR table space is limited to 0xFFFFFF (16777215) pages while the size of a TEMPORARY/LONG table space is limited to 2 tera bytes (2 TB).

Thank you