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 =...
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...
<<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.
I have my application on Solaris with Tomcat. Now I want to do following things:
when this application starts prompt user for his user name/password, if they typed these matching the ones in Active Directory (the users run this application on window XP on company's hosted active directory) then...
No. 00:02, 00:04, 00:07, 00:12 etc are the time when transaction arrived. I really have one columns showing when we received transactions in our database(Oracle). User wants me to set up query saying how many/what percentage of transactions we receieved in 10 minutes interval staring mid-night...
I have data like:
0.01
0.02
0.03
0.23
0.29
..
..
23.20
This data I have in excel spreadsheet I like to plot that will shows how many data(percent and absolute values)
I have in 10 minutes interval( In above I have in first 10 minutes 3 transactions, in next 10 minutes 0 transactions and in...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.