The following should be sufficient, you do not need the join:
Code:
select table1.stk_no
, table1.stk_date
, table1.stk_qty
from table1
where table1.stk_date between '20081101'
and '20081130'
Pilgrim333
Last Activity: Aug 19 '09, 04:23 PM
Joined: Oct 30 '08
Location: Home
-
Hi,
The following should be sufficient, you do not need the join:
Pilgrim.... -
Hi Amit,
In addition to posting the code, could you answer a few questions?
- What is the difference between the new environment and the other environments?
- Does the code work when you call the procedure in another procedure in it's own schema?
- Are you trying to access the cursor through an Oracle procedure or through a java or dotnet application?
Pilgrim.Leave a comment:
-
Hi,
You can also try to write a procedure to do this for you. I think this would be easier. Make use of the all_tables view etc.
Pilgrim.Leave a comment:
-
Hi,
There are a couple of things you are doing wrong.
First of all, you want the orderdate to be equal to the max orderdate, so loose the in keyword and replace it with '='
In the sub query, get rid of the group by, this is not needed, as you only want the max of the orderdate and no other fields.
I think you want the most recent order placed by each customer, so in the sub query, in the where clause, just get...Leave a comment:
-
Pilgrim333 replied to Cursor that is supposed to return one value Returns duplicated values of same rowin OracleHi,
Is this the exact code you are using? If not, then please post the exact code, otherwise it is just everyone's guess, cause there are a lot of things that can go wrong. If it is the exact code, I can't think of a reason why Oracle would return the same key twice (If it is returning the primary key)
Pilgrim.Leave a comment:
-
Hi,
Newsgroups are a good source as well.
Pilgrim.Leave a comment:
-
That is an easily made mistake, especially when you are just starting with Oracle. You can find more info on the concat operater at:
Concatenation Operator
Pilgrim.Leave a comment:
-
Hi,
Stating the error would be nice. What Oracle version are you using?
Pilgrim.Leave a comment:
-
Hi,
Most tools like TOAD and PL/SQL Developer make it able for you to see it in the interface under the table.
Pilgrim.Leave a comment:
-
Good to hear your problem is solved. The use of either queries is depending on your personal preference.
Good luck with the rest of your application.
Pilgrim.Leave a comment:
-
I did not get it that it should be for multiple id's. But if that is the issue, then my personal preference would still go to the following code
...Code:SELECT 'BILLING' as "Repository" , o.ORDER_ID as "Order ID" , O.ORDER_DATE as "Date Ordered" , s.SHIP_DATE as "Date Shipped" , (s.SHIP_DATE-O.ORDER_DATE) as "Lag Time" FROMLeave a comment:
-
Hi,
Indeed, you should specify the orderdate in de select statement and the group by statement.
Pilgrim.Leave a comment:
-
Hi,
The easiest way to do this:
...Code:SELECT 'BILLING' as "Repository" , o.ORDER_ID as "Order ID" , O.ORDER_DATE as "Date Ordered" , s.SHIP_DATE as "Date Shipped" , (s.SHIP_DATE-O.ORDER_DATE) as "Lag Time" FROM BILLING_DB.ORDERS o , BILLING_DB.SHIPPING s WHERE o.ORDER_ID = s.SHIP_ORDER_IDLeave a comment:
-
Hi,
Could you post both of the queries you have tried?
Pilgrim.Leave a comment:
-
Hi,
Good to see that your problem is solved.
Pilgrim....Leave a comment:
-
Hi,
What is the problem you are facing? What have you tried till now?
Pilgrim.Leave a comment:
-
Hi,
Google gives you a lot of results on this specific error code. I suggest you try some of the solutions posted, if nothing helps you, please post again, with the actions you have already taken.
Pilgrim.Leave a comment:
-
Hi,
If you are just submitting the query, then you can use the follwing:
This will ask for user input.Code:select * from myTable where name like '&p%
Pilgrim...Leave a comment:
-
Hi,
Check you parenthesis and quotes, i think you are making a mistake with that.
Pilgrim.Leave a comment:
-
Good to hear Jam, congrats on getting it working.
A good lesson, when implementing bussiness rules, autonumbering etc. that needs to be done on a table, always implement it in the table triggers. This way you ensure that these necessities will always be met, no matter what interface is used for manipulating data.
If you have more issues, please let us know.
Pilgrim.Leave a comment:
No activity results to display
Leave a comment: