 | |
doing hints on view
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: doing hints on view -
02-07-2008
, 11:19 AM
|
How can I do instead of using package in my example, use a standard sql. select t.column_1, t.column_2, t2.name , ... where t2.name = t. my_package.my_func(t.column_1, '2') ... from my_table t, my_table2 t2 where t2.name = t.name || ' - 1' (*) the (*) doesn't work. What should I do instead ? Thanks  |
asking us how to make bad code work how about describing the business
problem you are trying to address.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
#12
| |||
| |||
|
|
How can I do instead of using package in my example, use a standard sql. select t.column_1, t.column_2, t2.name , ... where t2.name = t. my_package.my_func(t.column_1, '2') ... from my_table t, my_table2 t2 where t2.name = t.name || ' - 1' (*) the (*) doesn't work. What should I do instead ? Thanks |
asking us how to make bad code work how about describing the business
problem you are trying to address.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
#13
| |||
| |||
|
|
How can I do instead of using package in my example, use a standard sql. select t.column_1, t.column_2, t2.name , ... where t2.name = t. my_package.my_func(t.column_1, '2') ... from my_table t, my_table2 t2 where t2.name = t.name || ' - 1' (*) the (*) doesn't work. What should I do instead ? Thanks |
asking us how to make bad code work how about describing the business
problem you are trying to address.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
#14
| |||
| |||
|
|
cannot find any reason to use user defined functions at all in this case. You can do all that in just one SQL statement, it would be much faster and better understandable. Gints Plivnahttp://www.gplivna.eu |
out all the real logic. I think that the hint would need to be in the
package on the cursor rather than in the view but without a better
explanation of why a packagted function is being used it is very
difficult to try to determine what the heck is the point of the code.
HTH -- Mark D Powell --
#15
| |||
| |||
|
|
cannot find any reason to use user defined functions at all in this case. You can do all that in just one SQL statement, it would be much faster and better understandable. Gints Plivnahttp://www.gplivna.eu |
out all the real logic. I think that the hint would need to be in the
package on the cursor rather than in the view but without a better
explanation of why a packagted function is being used it is very
difficult to try to determine what the heck is the point of the code.
HTH -- Mark D Powell --
#16
| |||
| |||
|
|
cannot find any reason to use user defined functions at all in this case. You can do all that in just one SQL statement, it would be much faster and better understandable. Gints Plivnahttp://www.gplivna.eu |
out all the real logic. I think that the hint would need to be in the
package on the cursor rather than in the view but without a better
explanation of why a packagted function is being used it is very
difficult to try to determine what the heck is the point of the code.
HTH -- Mark D Powell --
#17
| |||
| |||
|
|
cannot find any reason to use user defined functions at all in this case. You can do all that in just one SQL statement, it would be much faster and better understandable. Gints Plivnahttp://www.gplivna.eu |
out all the real logic. I think that the hint would need to be in the
package on the cursor rather than in the view but without a better
explanation of why a packagted function is being used it is very
difficult to try to determine what the heck is the point of the code.
HTH -- Mark D Powell --
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.