Hey guys,

I have deleted an oracle data file. But it seems I couldn't completely remove it because when I'm trying to make a new one with the same name oracle says: "data file already exists !!!" What to do?

Hi all,

I am having problems removing a data file in oracle database. I removed it but when I tried to make one with the same name then it said that "data file already exists".

But how it can exist when I personally deleted the file?

Can anyone help me?

Can any one help me altering an Oracle table? I have made a table and it has some data in it. But unfortunately, I forgot to make any primary key on that table. Is it possible to make a primary key now? I don't want to delete my previous data, that is already in the table.

Hi,

Hi,

I have a user created in Oracle by the name "joseph". The initial table space was named as "tspjoseph" which used a data file named "josephtsp.dbf". Unfortunately, I set the size to 1GB which is not full filling the requirement. My whole software is up and the database is also filled with important data. Is there any way I can increase it, without affecting the current data?

Hi,

I am using Oracle to learn SQL. Just introductory. I downloaded the Oracle setup file from Oracle's homepage named – "oracleXE 10g". The software installed successfully, but I don't seem to find the user Scott, which was used in the class lecture. I missed the lecture so could not figure out if there was anything said which was not covered in the papers. I asked a partner who said it was a default user. Then why can't I access it? Do I need a configuration or something to be set up at the beginning? Or am I using the wrong version? The instructor said in the paper that it was 10g, are there any variance within 10g?

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