Recent content by Rajesh99

Sorry my set was too simple, how will the following data set work: 20800 - Tom 100 20800 - Tom 100 20800 - Tom 200 20800 - Jack 100 20800 - Jack 300 20800 - Jack 400 20820 - Jack 100 ziocode distinct count(order #, name) 20800 5 20820 1 I like to get...

I had A TABLE outer joined more than once, I got different results every time I changed order of outer join. But what you are saying it is illegal to outer join a table more than once? Do you have any oracle reference to prove this? I have not read this anywhere in oracle manuals? I have been...

Sory my set was too simple, how will the following data set work: 20800 - Tom 100 20800 - Tom 100 20800 - Tom 200 20800 - Jack 100 20800 - Jack 300 20800 - Jack 400 ziocode distinct count(order by name) 20800 5 I like to get 5 as distinct count for Name/order#...

Questions: Well you are right I get some results which look meaningless when I outer join table many times, You can join only outer join table only once in sql? Is that right? Also can if I do outer join followed by inner join what is first going to be excuted by sql e.g. where master.pk =...

Option 1 will work. Thanks.

I have a number of tables they have some master/child realtionship i.e they can be joined by related columns. Now I understand I can create outer joins in these tables and should start with a MASTER table and from their keep joining tables to each other including ALL columns that are common...

Thanks. I have really four unqiue records in above, i have some other coumns in the result set and I do not care for them. I want to have in result set for each zip code list of unique NAME+ORDER#: 20800 - Tom 100 20800 - Tom 200 20800 - Jack 300 20800 - Jack 400 The temp tables and...

No I have same customer name in zip code. Here is an example: zip code Name order# 20800 - Tom 100 20800 - Tom 100 20800 - Tom 200 20800 - Jack 300 20800 - Jack 400 ziocode distinct count(order by name) 20800 4 In other words I have 4 unique order for Tom&order#...

I have a table like: orderid, custname, zipcode, orderdate. I want to count to do like this: select orderdate, count(distinct custname,zipcode) from a_able group by orderdate. Bu this does not work. I am trying to get for an order how many distinct custname were their in in zip code...

I have a huge table and I intend to do: insert into another_table select * from big_table; Will this run into can not extend rollback segment error?

Is there a view that can give me cause of error why it failed on refresh(SQLERROR)?

Is there a dictionary view that can give me status of refresh of Materialzed view(i.e, success, error code if failed on error etc)?

<<EOF lells sqlplus run all tha sql commands that come upto EOF under. Unfortnately I can create temp file etc so thai is the only option I have. I tried to escape << as \</< that did not work. I only use perl once a while so not current with what else can I do.

I have a legacy code and need to run this from perl. I can not use DBI as this needs to fit in legacy. system("sqlplus \/NOLOG <<EOF connect scott\/tiger\@store; select sysdate from dual; exit EOF "); This does not work and keeps prompting me for help on sqlplus. Seems somewhere may be at <<...

Thanks. Seems teh two examples there need an extra text item to type in. I am looking to have a lisbox where you type and list scrolls up automatically to closest match.