Oracle queries

[ashish_ietk2000]

Dear friends
i am in trouble can u plzzzz help me .i have 2 questions plz sove it

1- i have to use if condition with select statement
2-make such type of query so that it deletes duplicate data in a table

Thanx
Ashish Pandey

[srinu.oracle]

To eleminate duplicate rows use this one and try it.
select distinct job from emp;
useing decode function we can implement the if condition in select statement.i don't know exact quary i will send tomarrow.

[vanimohankumar]

hello friend

for deleting duplicate values in table use following query

delete * from table_name
where row_id < (select max(row_id) from table_name
group by column_name);

this query wll delete the duplicates rows

[Angela]

Ashish did you try the suggestions given by our friends here in this thread. What is the result? Is your problem solved? Let us know so that we could know your status of query

[Abdul Qadeer]

1. In order to user it in if statement you have to make procedure,or cursor
then use this syntax in then condition.

delete from table_name where rowid not in (select max(rowid)
from table_name group by column_name); (not null column).

[psiva_exforsys]

we can delete the duplicate records from the table using with the below querys

delete ename from emp a where rowid < (select min(rowid) from emp b
where a.rowid<=b.rowid);


Decode function:

we can select the employee based on the sex(male (M) and Female(F) using decode function

select decode(M,'Male',1,
decode (F,'Female,0) from emp;

Syntax for decode like if...than...else

IF s = search1
THEN result1
ELSE default
Exercises


Regards,
Siva.P
Bangalore