Thanks. That's helpful. Quick question: what would be the difference between a.order_item_id < b.order_item_Id and a.order_item_id > b.order_item_Id ? I keep getting different results for both rules. I would expected that both a.order_item_id < b.order_item_Id or a.order_item_id > b.order_item_Id would give the same result.
This would give you the same number of records however the order might be different depending on if you less "". Consider this example. we have two records prod_id1 prod_id2 1 2 2 1 if you use < operator, the output count is 1 and the output is prod_id1 prod_id2 1 2 iif you use > operator, the output count is 1 and the output is prod_id1 prod_id2 2 1
Hi Vivek I have a question I have 200 packages in that many procedures and functions are there.If some error occurred in that how can I find the package name and procedure and line number?? I said we can go with backtrace is there any alternative solution.. Thanks in advance
So we have different jobs that will call these packages, our starting point will be identifying the job that has failed, then we will check what packages were being called by it, A well designed project will also have a log for the job which will capture the ORA error or what exactly went wrong. So we will only look at things that are relevant to us
Beautifully articulated and illustrated, Thank you
Thanks a lot :)
Superb and simple explanation
Thanks Supreet :)
Thanks. That's helpful.
Quick question: what would be the difference between a.order_item_id < b.order_item_Id and a.order_item_id > b.order_item_Id ? I keep getting different results for both rules. I would expected that both a.order_item_id < b.order_item_Id or a.order_item_id > b.order_item_Id would give the same result.
This would give you the same number of records however the order might be different depending on if you less "".
Consider this example. we have two records
prod_id1 prod_id2
1 2
2 1
if you use < operator, the output count is 1 and the output is
prod_id1 prod_id2
1 2
iif you use > operator, the output count is 1 and the output is
prod_id1 prod_id2
2 1
Thank you for the explanation!
Thanks for the help
Useful. Thank you
which one is video of this video next part continued
Will u give access for this connection as a user
Unfortunately I don't have this DB up now.
Hi, can you share the solution for the problem statement discussed at the end of the video.
Hi Vivek
I have a question
I have 200 packages in that many procedures and functions are there.If some error occurred in that how can I find the package name and procedure and line number?? I said we can go with backtrace is there any alternative solution..
Thanks in advance
So we have different jobs that will call these packages, our starting point will be identifying the job that has failed, then we will check what packages were being called by it, A well designed project will also have a log for the job which will capture the ORA error or what exactly went wrong.
So we will only look at things that are relevant to us