Hello Friends, I know that why subqueries used, but that work we want to use from subqueries same we can do from signle query, then why it is important to use subqueries in oracle?? tell me good example... Raj Khatri

Dear Friend, I don;t know which type of query u want, as ur mind asks.. but i have one query which will give u same result which u want.. select category,product from table_name where product in('jeans','machine gun','pepsi'); from taht u can view same result as u want, Raj Khatri

If iam making a table of location in that table i have columns city,county,condition. And i had some values added in these columns.. after addeding the values in these three columns now i want to add the new column temperature by alter table location add(tempareture number(2)); but i want to add the values from start in this new column how that is possible is that possible for 1st column value as follow.. insert into location(tempareture) values(34) where city='Athens'; like that in other columns i can put the value tempareture???? please tell me solution.. Raj Khatri

Dear Friend There are many types of the Joins. which type of the join u want to use?? 1-Inner join 2-Outer join 3-Self Join You have example of inner join by our one friend if u need other 2's then reply.. Raj Khatri